How to Close the Formula Bar in Excel on Any Device

Formulas & functions · Updated November 20, 2026

To close—or hide—the formula bar in Excel, open the View tab and clear the Formula Bar checkbox. In Excel for Microsoft 365 on Windows, find it under View > Show > Formula Bar. This hides the bar from the worksheet view; it does not remove formulas or change cell contents. You can turn it back on from the same control whenever you need it.

What You’ll Need

  • Excel for Microsoft 365 on Windows, Excel for Mac, or Excel for the web.
  • An open workbook. You do not need to select a particular cell or change any workbook data.
  • Access to the ribbon or View menu, depending on your Excel version and device.

Step-by-Step

  1. Open the workbook and locate the ribbon. In the desktop version of Excel, the ribbon is the strip of tabs and commands above the worksheet. If the ribbon is minimized, click a tab such as Home or use the ribbon display control to show it. In Excel for the web, open the workbook in your browser and look for the ribbon above the sheet.
  2. Select the View tab. In Excel for Microsoft 365 on Windows, click View on the ribbon. This tab contains controls for changing what is visible in the worksheet window. You do not need to use the Formula tab, the name box, or a cell’s right-click menu.
  3. Find the Formula Bar control. On Windows, look in the Show group on the View tab. The group includes display controls such as Gridlines, Headings, and Formula Bar. The Formula Bar option is a checkbox, so its checked or unchecked state indicates whether the bar is displayed.
  4. Clear the Formula Bar checkbox. Click Formula Bar once. When the checkmark disappears, the formula bar should vanish from above the worksheet grid. The cells and their displayed values remain in place; only the separate input and editing area has been hidden.
  5. Check the worksheet and continue working. Click a cell to confirm that the worksheet grid is still usable. You can continue selecting cells, entering data, and editing formulas directly in cells. If you want the formula bar back, return to View > Show > Formula Bar and click the option again so it is checked.
  6. Use the matching control on Mac or the web. In Excel for Mac, open the View tab and toggle the Formula Bar option off; depending on the Mac layout, you may also find the control in the View menu. In Excel for the web, use View and turn off Formula Bar in the display options. The wording and placement can vary slightly with window width or interface updates, but the setting is a visibility toggle, not a command to delete worksheet content.

After hiding it, the worksheet grid may gain a little vertical space. This can be useful on a small display or when you want a less cluttered view. The bar is not a separate pop-up window, so there is no close button to click. Use its checkbox or toggle instead.

Common Mistakes

  • Looking for an X button. Excel does not normally provide a close button on the formula bar. It is part of the worksheet interface, and you show or hide it from the View controls.
  • Confusing the formula bar with the ribbon. Hiding the ribbon or collapsing its tabs is a different action. If the commands disappear but the formula bar remains, expand the ribbon and use the Formula Bar option on the View tab.
  • Turning off gridlines instead. Gridlines are the faint boundaries between cells. Switching them off changes the sheet’s appearance but leaves the formula bar visible. Make sure you select Formula Bar, not Gridlines or Headings.
  • Expecting the setting to remove formulas. Hiding the bar only changes what is shown around the worksheet. It does not clear formulas, convert them to values, or prevent the selected cell’s contents from being edited.
  • Clicking the checkbox repeatedly without checking its state. Each click reverses the setting. If the bar disappears and then returns, it may simply have been toggled on again. Look for the checkmark and click only as needed.
  • Assuming the formula bar is the same as the name box. The name box is the small field to the left of the formula bar that usually displays the selected cell address. Hiding the formula bar does not necessarily hide the name box or other ribbon controls.

Tips

  • Remember the route, not a special close shortcut. The dependable method is the Formula Bar checkbox on the View tab. In Windows Excel, Ctrl+Shift+U expands or collapses the formula bar when it is displayed; it does not hide the bar entirely. Do not use it as a substitute for the visibility toggle.
  • Edit formulas in the worksheet when the bar is hidden. Select a cell and type, or use the cell itself to edit its contents. In desktop Excel, pressing F2 starts editing the selected cell. This is handy for quick changes, although long formulas may be harder to inspect inside a narrow cell.
  • Show the bar temporarily for a long formula. If you need to read or edit a lengthy expression, turn the formula bar back on, select the relevant cell, and use the bar to review the formula. Hide it again afterward if you prefer the extra room.
  • Distinguish the bar from a taller formula bar. Excel can expand the formula bar to display more lines. On Windows, Ctrl+Shift+U toggles that expanded view. If the bar is present but unusually tall, collapse it with that shortcut rather than turning off the entire bar.
  • Give yourself room on a small screen. Hiding the formula bar can help when viewing many rows, but it may make complex formulas less convenient to check. Consider leaving it visible while auditing or editing a workbook and hiding it only for browsing or presenting the sheet.
  • Know which interface you are changing. The control changes the Excel window’s display, not the data stored in a cell. If you work with multiple open workbooks, check the other window rather than assuming that changing one view altered workbook contents.

Troubleshooting

  • The Formula Bar option is missing. Make sure you are on the View tab and that the ribbon is expanded. On a narrow window, Excel may compress or rearrange groups; maximize the window or inspect the available View controls. In Excel for the web, check the View tab’s display options rather than the browser’s own menus.
  • You clicked the option, but the bar is still there. Look again at the checkbox. If it remains checked, click it once to clear it. If the checkmark is gone but the bar seems visible, confirm that you are looking at the formula bar and not the name box, ribbon, or a cell being edited.
  • The bar disappears, but you cannot edit a formula as before. Select the cell and edit directly in the grid, or turn the bar back on temporarily. If the sheet is protected, editing may be restricted by worksheet protection; hiding or showing the formula bar does not remove that restriction.
  • The option is unavailable or cannot be changed. Check whether Excel is still loading, a dialog box is open, or the workbook is being viewed in a restricted mode. Close or finish the active dialog and try again. If an organization manages your Office settings, an administrator may also restrict some interface options.
  • The display looks different on Mac or in a browser. Use that version’s View tab or View menu and search for the Formula Bar visibility control. Ribbon layouts can differ from Windows, and the web interface may change as Microsoft updates it. If you cannot find the option, widen the window and inspect the full View menu; do not change worksheet data to try to hide the bar.
  • You want the bar back but cannot remember what changed. Return to the View controls and select Formula Bar again. The setting is reversible, and turning it back on restores the editing area without undoing or changing any cell entries.

Frequently Asked Questions

Does hiding the formula bar delete formulas?
No. It hides the formula bar from view but leaves formulas, values, formatting, and other worksheet content unchanged. It is a display preference, not a data-editing command.

How do I close the formula bar in Excel for Microsoft 365 on Windows?
Click View > Show > Formula Bar to clear its checkmark. Click the same option later to display the bar again.

Can I hide the formula bar in Excel for Mac?
Yes. Use the Formula Bar toggle from the View tab or, in some layouts, the View menu. The exact placement can vary by Mac version, but the control switches visibility on or off.

Can I hide it in Excel for the web?
Yes. Open the workbook’s View tab and turn off the Formula Bar display option. If you do not see it, expand the ribbon or widen the browser window.

Is Ctrl+Shift+U the shortcut to close the formula bar?
Not exactly. In Windows Excel, Ctrl+Shift+U expands or collapses the formula bar’s height; it does not turn the formula bar’s visibility off. Use the View tab checkbox to hide the entire bar.

Why can I still see a formula while the bar is hidden?
A selected cell may display its contents in the worksheet grid while you edit it. The formula bar is a separate area above the grid, so editing in the cell does not mean the bar is still open.

Related

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.