Excel Formula Bar Disappeared? How to Show It Again

If the Excel formula bar disappeared, turn it back on from View > Show > Formula Bar in Excel for Microsoft 365 on Windows. If the bar is visible but too short to read, expand it with the arrow at its right edge or press Ctrl+Shift+U.

Show the formula bar in Excel for Windows

The formula bar sits above the worksheet grid, below the ribbon. It displays the contents of the selected cell and lets you enter or edit that content. In current Microsoft 365 Excel for Windows, use the ribbon to restore it:

Open the workbook in Excel.
Select the View tab.
In the Show group, select the Formula Bar checkbox.

The bar should reappear immediately, usually between the ribbon and the column headings. This setting controls whether the formula bar is displayed in the Excel application; it does not delete or change any cell contents. If the checkbox is already selected, look for a different cause, such as a collapsed bar or a formula that is hidden by worksheet protection.

You can also check the related Excel option on Windows: select File > Options > Advanced, then look under Display for Show formula bar. Select the checkbox and choose OK. The View-tab checkbox is usually the quicker fix, while the Options page is useful if you are checking Excel’s display preferences more broadly.

Check whether the bar is hidden or merely collapsed

A formula bar can look missing when it has been reduced to a very narrow strip. Check just above the worksheet’s column letters for a thin line, an input area, or a small expand arrow at the far right of the bar. Select the arrow to enlarge the editing area. In Windows desktop Excel, Ctrl+Shift+U also expands or collapses the formula bar.

An expanded formula bar can use more than one line, which is helpful when a cell contains a long formula or a large amount of text. If the bar is present but only one line high, use its expand control rather than turning the Formula Bar checkbox off and on. When expanded, the worksheet grid has less vertical room; collapse the bar again when you want more rows on screen.

Do not confuse this with a collapsed ribbon. The ribbon contains tabs such as Home and View, while the formula bar is a separate area below it. If the ribbon has disappeared, press Ctrl+F1 on Windows to toggle the ribbon display, or select a ribbon tab. Restoring the ribbon does not itself switch on the formula bar, so check the View tab’s Formula Bar option separately.

Where to find the setting on Mac and in Excel for the web

Excel’s interface differs slightly across platforms, but the setting is still a display control. In Excel for Mac, look for Formula Bar under the View menu or on the View tab, depending on the version and layout. Select it to show the bar. Older Mac releases may label the application preferences as Preferences rather than Settings; if you use that route, check the View preferences for the formula-bar option.

In Excel for the web, open the View tab and look for the formula-bar display option, commonly grouped with other display controls. The web interface can change, and some commands may be arranged differently from desktop Excel. If you cannot find the control in the ribbon, check whether the ribbon is simplified or narrow, then use the View tab’s available display options.

Keyboard shortcuts can also vary by operating system, keyboard layout, and Excel version. The Windows shortcut for expanding or collapsing the formula bar is Ctrl+Shift+U. On a Mac, use the menu or View-tab control if that shortcut does not work in your configuration; the Windows shortcut should not be assumed to behave identically on every Mac keyboard.

What the formula bar does—and what hiding it does not do

The formula bar shows the contents of the active cell. Select a cell containing a formula and the bar displays the formula; select a cell containing a number or text and it displays that value or text. You can click in the bar to edit the selected cell’s contents without typing directly into the grid. The Name Box, immediately to its left, identifies the selected cell or range and is a separate control.

Hiding the formula bar changes only the workspace display. Formulas continue to calculate, and cell values remain in the worksheet. It does not remove formulas, convert them to values, or protect them from being viewed by other means. If the bar is taking up screen space, hiding it can be a personal display choice, but it is not a way to secure workbook information.

One related command is often mistaken for the formula-bar switch: Show Formulas. This changes what appears inside worksheet cells, displaying formulas in the grid instead of their calculated results. It does not show or hide the formula bar. In Excel for Windows, the shortcut Ctrl+` toggles Show Formulas; the grave-accent key is commonly near the upper-left of the keyboard, but its position varies. If formulas suddenly appear across the sheet, check the Formulas tab for Show Formulas or use the shortcut again.

When a selected cell’s formula is blank

Sometimes the formula bar itself is visible, but it appears empty for a particular cell. First select a cell that you know contains content. The bar changes to reflect the active selection, so a blank cell naturally produces an empty-looking entry area. Clicking a different cell can also reveal that the bar was working all along.

A more important exception involves protected worksheets. Excel allows a cell’s formula to be marked as hidden and then concealed when the worksheet is protected. In that situation, the formula bar can be visible but not reveal the formula for that protected cell. The worksheet’s protection and the cell’s settings are different from the application-wide Formula Bar checkbox.

If you own or are authorized to edit the workbook, check whether the sheet is protected and ask its owner for the appropriate access if necessary. Do not assume that a blank formula bar means the formula has been erased. A cell may contain a constant value, be genuinely empty, or have a formula hidden by protection. The displayed result alone does not tell you which case applies.

Troubleshooting when the checkbox does not solve it

If selecting View > Show > Formula Bar does not restore the area, work through these checks before changing workbook data:

Confirm the application and window. Make sure you are in the Excel workbook you intended to open, not a preview, another spreadsheet app, or a second Excel window with a different layout.
Look for a collapsed bar. Inspect the narrow area between the ribbon and column headings, then use the expansion arrow or Ctrl+Shift+U on Windows.
Check the View tab again. Make sure the Formula Bar option is selected. If it is selected already, turn it off and back on once, then check the display.
Maximize the Excel window. A small window or crowded ribbon can make controls harder to locate. Maximizing the window may expose the full Show group, although it does not replace the Formula Bar setting.
Separate display issues from cell issues. Select several known nonempty cells. If the bar appears but one cell’s contents do not, investigate that cell or sheet protection rather than the global display option.
Reopen the workbook or Excel. If the interface seems stuck, save your work and reopen the workbook. Avoid force-closing Excel while unsaved changes are present.

If the control is missing from the ribbon, the ribbon may be simplified, the window may be too narrow, or the interface may differ in your Excel version. Widen the window or inspect the View menu and settings. On a managed work computer, organizational policies can affect available features, so contact your administrator if standard display controls remain unavailable.

Formula bar versus editing in the worksheet

You do not have to use the formula bar to edit a cell. Select a cell and begin typing to replace its contents, or double-click the cell to edit within the grid. You can also select the cell and press F2 in Windows to edit its contents. These alternatives can help when you need to make a quick change, but they do not restore the bar or provide its larger editing area.

The formula bar is especially useful for long formulas, text strings, and content that is difficult to inspect in a narrow column. It can make it easier to place the cursor within a formula without changing the cell’s displayed result. For example, a cell may show a short calculated value even though its underlying formula is lengthy; selecting the cell lets you inspect that underlying expression in the bar.

When you edit, Excel applies the change to the selected cell whether you type in the grid or in the formula bar. Press Enter to commit an edit or Esc to cancel an edit in progress. If you are unsure whether you are editing or replacing a cell, check the selection and the text cursor before typing.

Frequently Asked Questions

Why did my Excel formula bar disappear?
Most often, the Formula Bar display option was turned off. On Windows, select View > Show > Formula Bar. If the option is on, check whether the bar is collapsed or whether you selected an empty or protected cell.

How do I make the formula bar bigger?
Use the expand arrow at the right side of the formula bar, or press Ctrl+Shift+U in Excel for Windows. The expanded bar provides more room to read or edit long content and can be collapsed again when you finish.

Can I show formulas in cells without using the formula bar?
Yes. The Show Formulas command displays formulas in the worksheet grid instead of their calculated results. It is separate from the Formula Bar checkbox; on Windows, Ctrl+` toggles this display.

Why can’t I see a formula in the bar for one cell?
The selected cell may be empty or contain a fixed value rather than a formula. If the worksheet is protected, the cell’s formula may also be marked as hidden. Select another known formula cell and, if needed, check the sheet’s protection settings with the workbook owner.

Does hiding the formula bar delete or change formulas?
No. Hiding the bar changes the interface, not the workbook’s cell contents or calculation behavior. Formulas remain in their cells unless someone edits or removes them.

Keep the worksheet comfortable to use

For most people, the best fix is simply to switch the Formula Bar option back on from the View tab. If you want more room for the grid, you can hide it again later; if you need to inspect long cell contents, expand it temporarily. Remember that the formula bar, the ribbon, and Show Formulas are three separate display features, and that a protected formula can be concealed even while the bar itself remains visible. Checking those distinctions usually identifies the cause without changing the workbook’s data.

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.