Excel Formula Bar Not Showing? How to Restore It

If the formula bar is missing in Excel for Microsoft 365 on Windows, open the View tab and, in the Show group, select Formula Bar. If it is already enabled, check whether the bar is collapsed, whether the selected cell contains a formula, or whether worksheet protection is hiding that formula.

Restore the formula bar in Excel for Windows

The formula bar sits below the ribbon and above the worksheet grid. It displays the contents of the active cell, including a formula when the selected cell contains one. Its visibility is controlled by a setting in Excel, so the first fix is usually a single checkbox:

Click the View tab on the ribbon.
Find the Show group.
Select the checkbox labeled Formula Bar.

If the box was clear, the bar should appear immediately. The worksheet does not need to be restarted, and changing this display setting does not alter cell values or formulas. If the checkbox is already selected but you still cannot see the bar, continue with the checks below rather than repeatedly toggling it.

You can also check the setting in Excel Options. Choose File > Options > Advanced, scroll to the Display section, and make sure Show formula bar is selected. This is useful if the ribbon is crowded, customized, or difficult to navigate. Click OK to apply the change.

Check the view in Excel for the web and on Mac

In Excel for the web, look on the View tab for the Formula Bar option in the display or show controls. The layout can differ slightly from the Windows desktop ribbon as Microsoft updates the web interface, but the relevant control is still a visibility checkbox. If the workbook is open in a browser and the option is not immediately visible, expand the ribbon or inspect the other View controls.

In Excel for Mac, use the View tab or the macOS menu bar’s View menu and enable Formula Bar. The exact placement can depend on the current ribbon layout and Excel release. The Windows-only path File > Options does not apply on Mac; Mac has its own Excel settings and menus. Excel for the web also does not use the Windows File > Options dialog.

These controls affect what you see, not whether a workbook’s formulas exist. If a formula bar appears on one device but not another, compare the display setting in each Excel app. A local display choice can make the same workbook look different without changing the workbook’s underlying calculations.

Make sure the bar is not merely collapsed

A formula bar can be visible but too short to show much content. If you see a narrow strip below the ribbon, look for the small expand control at the right end of the bar. Select it to expand the formula bar. You can also drag the lower edge of the bar downward to give it more vertical space. Drag the edge upward again when you want to reclaim room for the worksheet.

This matters most when a cell contains a long formula, a lengthy text value, or several lines of content. A narrow formula bar may show only part of the entry, which can make it seem as though the formula is missing. Expanding the bar changes the amount of visible space; it does not change the cell’s contents.

On Windows, Ctrl+Shift+U expands or collapses the formula bar. If the shortcut does not seem to work, click a worksheet cell first and check that Excel has focus. The ribbon checkbox is the more dependable way to confirm whether the entire bar is hidden. Mac keyboard shortcuts can differ, so use the View control if the Windows shortcut is not recognized.

Distinguish a hidden formula bar from Show Formulas

The formula bar and Excel’s Show Formulas worksheet view are separate features. The formula bar is the single-cell entry area above the grid. Show Formulas changes the worksheet grid so cells display their formulas instead of calculated results. Turning on the second feature does not restore a missing formula bar.

If the formula bar is present but cells show expressions such as =SUM(B2:B8) instead of totals, check the Formulas tab and turn off Show Formulas. You can also check whether the affected cells are formatted as Text or whether a formula was entered with a leading apostrophe. Those situations can make an entry appear as text rather than calculate, but they are different from hiding the formula bar itself.

Conversely, if a cell shows a calculated result in the grid and you want to inspect its formula, select that cell. Its formula should appear in the formula bar unless the cell is blank, the formula is hidden by protection, or the bar is not displayed. Selecting a different cell is a quick way to tell whether the issue concerns one cell or the whole interface.

Understand what worksheet protection can hide

Sometimes the formula bar is present, but a particular formula is not visible there. A worksheet author can mark formula cells as hidden and then protect the sheet. With that combination in place, Excel can continue to show the calculated result in the cell while withholding the formula from the formula bar. This is a protection feature, not evidence that the formula bar has disappeared.

To inspect this possibility, select a cell that you believe contains a formula and look at the formula bar. If it is blank for that cell but shows contents for other cells, protection or the cell’s contents may explain the difference. On Windows, the sheet’s protection status can be checked on the Review tab. If the sheet is protected, changing its protection settings may require the password set by the workbook’s owner.

Do not try to bypass protection on a workbook you are not authorized to change. If you need to review or edit a hidden formula, ask the workbook owner for access or an unprotected copy. If you own the file and know the password, use the available Review tab controls to unprotect the sheet, then review the cell’s protection settings. Unprotecting a sheet can permit edits, so take care not to change data accidentally.

Troubleshoot when the checkbox does not fix it

If the Formula Bar option is enabled and nothing appears, narrow down where the problem occurs. These checks can separate a display issue from a workbook-specific or screen-layout issue:

Try another workbook. If the formula bar appears in a new or different workbook, the original sheet may have hidden formulas, protection, or unusual workbook-specific behavior.
Select a cell with known content. A blank selected cell naturally gives you no formula or value to inspect. Click a cell that visibly contains a number or text.
Check the window layout. Maximize the Excel window and look just below the ribbon. A compact window, a minimized ribbon, or limited screen space can make interface elements harder to spot, even though minimizing the ribbon is not the same as hiding the formula bar.
Recheck the View setting. A setting may have been toggled inadvertently. Confirm that Formula Bar remains selected after you switch workbooks or reopen Excel.
Close and reopen Excel. If the display remains abnormal after checking the setting, save your work and restart the app. This can help recover from a temporary interface problem, but it should not be treated as a fix for protected or hidden formulas.

If the issue affects every workbook and the setting is enabled, note whether other ribbon controls or interface elements are also missing. That points more toward an Excel display or installation problem than a formula issue. Check for available Microsoft 365 updates, and, if necessary, use the repair options available for Office on Windows. Before making broader changes, save open workbooks and confirm that you can reopen them.

What the formula bar shows—and what it does not

When you select a cell, the formula bar shows that cell’s underlying entry. For a formula cell, it normally shows the formula text while the grid shows the calculated result. For a cell containing a typed number or text, it shows that value or text. For an empty cell, it is empty. This difference is useful when checking whether a displayed number is calculated or was typed directly.

The formula bar is also an editing area. You can select a cell and click in the bar to review or edit its contents, then press Enter to commit a change or Esc to cancel an edit. Editing a formula this way changes the worksheet; simply turning the bar on, expanding it, or selecting a cell does not. If you only want to inspect a formula, avoid typing or deleting characters in the bar.

It is not a complete history of a cell’s calculations, nor does it reveal formulas hidden by sheet protection. It displays the selected cell’s current content. To examine dependencies or trace how a result is calculated, Excel’s formula-auditing tools may be more appropriate, provided the workbook permits access to the formulas.

Frequently Asked Questions

How do I turn the formula bar back on in Excel?
In Excel for Windows, select View > Show > Formula Bar. If it is already checked, look for a collapsed bar or a formula hidden by worksheet protection.

Why is the formula bar blank when I click a cell?
The selected cell may be empty. If the cell visibly has a calculated result but its formula is not shown, the formula may have been hidden on a protected worksheet. Check another known content cell to distinguish these cases.

Why can I see a result in the cell but not its formula?
A worksheet can be configured to hide formulas and then protected. Excel can display the result while keeping the formula out of the formula bar. Ask the workbook owner for permission if you need to inspect it.

Does Show Formulas bring back the formula bar?
No. Show Formulas changes what appears inside worksheet cells; Formula Bar is a separate display control. Turn on Formula Bar from the View controls to restore the entry area above the grid.

Can I resize the formula bar?
Yes. Use the expand control at its right edge or drag its lower border downward. Resizing gives long formulas more room to display but does not alter the worksheet’s data.

Why does the formula bar appear in one workbook but not another?
The visibility control is an Excel display setting, while individual sheets can also hide formulas through protection. Compare the View setting and select a known formula cell in each workbook to identify which situation applies.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.