How to Hide the Formula Bar in Excel on Windows and Mac

To hide the formula bar in Excel for Microsoft 365, open the View tab, then in the Show group clear the Formula Bar checkbox. The worksheet grid will have more room, but your data and formulas will remain unchanged. You can turn the bar back on from the same checkbox whenever you need it.

The formula bar is the area above the worksheet that displays the contents of the selected cell. Hiding it is useful when you want a less cluttered view, need more vertical space, or are presenting a workbook on screen. The steps below cover Excel on Windows first, followed by the corresponding options on Mac and in a web browser.

What You’ll Need

Excel for Microsoft 365 on Windows, Excel for Mac, or Excel for the web. The ribbon layout can vary slightly by platform, but the control is normally on the View tab.
A workbook open in Excel. You do not need to select a particular cell or change any worksheet settings.
Access to the Excel ribbon. If the ribbon is collapsed, select a tab such as View to display its commands. You do not need administrator access or a special add-in.

Hiding the formula bar is a display change, not a way to conceal or secure workbook contents. On desktop Excel, the setting is an Excel interface preference rather than a property saved with an individual worksheet. Other people who open the workbook may still see the formula bar according to their own Excel settings.

Step-by-Step

Open the workbook. Start Excel and open the workbook whose screen you want to simplify. If you have several workbooks open, first activate the window you want to work in by clicking it. This makes it easy to confirm the display change, although the formula bar setting in desktop Excel is not limited to the active sheet.
Go to the View tab. On the Excel ribbon, select View. Do not look under Formulas: that tab contains formula-related tools, but not the display checkbox for the formula bar. If you cannot see the ribbon commands, click the View tab to expand the ribbon or use the ribbon display options to show it.
Find the Show group. In the View tab, locate the group named Show. It contains checkboxes for worksheet interface elements. Depending on your window width and ribbon layout, the group or its commands may be compact, so maximize the Excel window or widen it if the checkbox is not immediately visible.
Clear Formula Bar. Click the checkbox next to Formula Bar so that it is no longer checked. Excel hides the strip above the worksheet grid. You should see the worksheet move up into the space the bar occupied. This does not delete the selected cell’s content or alter any formulas.
Check that the change is what you wanted. Click a cell containing a value or formula. The cell remains visible in the grid, but its contents will not appear in the hidden formula bar. You can still edit a selected cell in the worksheet itself, so avoid entering text or pressing keys if you only meant to check the display.
On a Mac, use the same display control. In Excel for Mac, select View on the ribbon and clear Formula Bar in the display or Show controls. The exact grouping can look different from Windows, especially if the Excel window is narrow, but the checkbox has the same purpose. Select it again to restore the bar.
In Excel for the web, check the View ribbon. Open the workbook in your browser, choose View, and look for the Formula Bar option in the Show controls. Clear it if the option is available in your current web layout. If you do not see it, expand the ribbon or open the workbook in the desktop app, where the View tab checkbox is available.
Restore the formula bar when needed. Return to View and select Formula Bar again. A checkmark indicates that the bar is visible. Re-enabling it does not undo or change any work done while it was hidden; it simply brings the display area back.

There is no need to save the workbook just to preserve the desktop formula bar setting as a workbook feature: the display preference is not stored as sheet content. You should still save normally if you made other changes to the workbook. If the file is shared, explain that hiding the bar only changes the view on your computer; it does not force the same interface setting on another person’s Excel installation.

Common Mistakes

Looking in the wrong tab. The Formulas tab is a natural place to search, but it is not where the visibility toggle lives. Use View > Show > Formula Bar in Windows Excel. On Mac and web, use the View ribbon and look for the same named control. The formula bar can also be confused with the ribbon itself, which is a separate interface area.

Expecting hidden formulas to be protected. Turning off the formula bar only hides a part of the interface. A person can still select cells and inspect or edit their contents in the grid, and may be able to see formulas in other ways. If your goal is to prevent formulas from being displayed in the formula bar for particular cells, use cell protection instead: mark the cells as Hidden in Format Cells, then protect the sheet. That is a separate workflow and should be tested with the permissions you intend to allow.

Assuming the setting follows the workbook. On desktop Excel, the formula bar preference is generally part of the local Excel interface. Clearing it does not make every recipient’s copy open without a formula bar, and saving the workbook is not a reliable way to impose that view on other users. If another person reports that the bar is visible, they can change the setting in their own View tab.

Hiding more than the formula bar. The View tab has controls for other worksheet elements, including headings and gridlines. Make sure you clear only Formula Bar if you want to keep row and column labels and gridlines visible. Clicking the wrong checkbox can make the sheet look substantially different even though no content has been removed.

Tips

Use it for presentation, not privacy. A hidden formula bar can make a dashboard, report, or small laptop display look cleaner. It is not a security measure. If a workbook contains sensitive information, control access to the file and protect the relevant data appropriately rather than relying on a hidden interface element.

Keep a way to edit cells comfortably. With the bar hidden, longer text and formulas are less convenient to inspect. You can still select a cell and edit in the cell itself, but long entries may be difficult to review in a narrow column. Consider turning the bar back on while building or checking a workbook, then hiding it for a presentation.

Remember the difference between the cell and the bar. The formula bar displays the active cell’s content; it does not store that content. Hiding the bar does not change the value shown in the cell, recalculate a formula, or remove the ability to use Excel’s calculation features. If a number changes or a formula result looks wrong, hiding or showing the bar is not a calculation fix.

Make the screen view fit the task. If your real goal is to display more worksheet rows, also consider reducing unnecessary ribbon space or adjusting zoom. Those are separate display changes. Use one change at a time so you can tell which setting made the worksheet easier to read.

Tell collaborators what changed. When sharing instructions or a screen capture, mention that the formula bar is hidden if viewers may wonder why it is missing. Since the change is a local interface preference in desktop Excel, they can choose their own view without changing the workbook data.

Troubleshooting

The Formula Bar checkbox is missing. Confirm that you are on the View tab, not Home or Formulas. Expand the ribbon if it is collapsed, and make the Excel window wider if commands have been condensed. On Mac, inspect the View ribbon’s display controls. In the browser, the web ribbon may have a different layout; if the control is not offered, open the workbook in desktop Excel and use its View tab.

The bar does not disappear after clicking. Look at the checkbox state and click it once more if it is still checked. If the ribbon is narrow, be sure you clicked the label or checkbox itself rather than a neighboring option. Switching to another workbook window can also make it seem as if the change did not apply; return to the window where you made the change and check the View setting there.

The formula bar is hidden, but I can still see or edit cell contents. That is expected. The cell grid remains available, and the display toggle only removes the separate formula bar. To hide formulas from the formula bar for protected cells, select those cells, open Format Cells, choose the Protection tab, select Hidden, and then protect the worksheet from Review > Protect Sheet. The Hidden setting takes effect only after sheet protection is applied. Make a backup and test the protection behavior before distributing a workbook.

The setting changes back or differs on another computer. Desktop Excel’s formula bar visibility is a local display preference, so another installation can have a different setting. Check the View tab on the computer where the bar is visible. If you are using Excel for the web and do not see the same control, try the desktop app; the available web commands can depend on the current interface.

The ribbon itself is gone. You may have collapsed the ribbon rather than hidden the formula bar. Click a ribbon tab such as View to reveal its commands, or use Excel’s ribbon display control to show the tabs and commands. Then locate the Formula Bar checkbox. Do not reset the workbook or delete cells to fix a missing display area.

Frequently Asked Questions

Does hiding the formula bar delete formulas?
No. It changes only whether the formula bar is displayed. Formulas, values, formatting, and worksheet calculations remain as they were.

Can I hide the formula bar for just one worksheet?
On desktop Excel, the normal View checkbox controls the Excel interface rather than an individual worksheet. It is not a per-sheet setting saved with the workbook. For hiding selected formulas from view, use the Hidden cell protection setting and protect the sheet.

Is there a keyboard shortcut to hide the formula bar?
Excel does not provide a standard dedicated keyboard shortcut for this toggle. Use View > Show > Formula Bar. Ribbon key tips can vary with Excel version and configuration, so the visible checkbox is the dependable route.

Can other people still see the formula bar?
Yes. Hiding it on your computer does not generally change the setting for people who open the workbook on their own computers. They can show or hide it independently from the View tab.

How do I show the formula bar again?
Go to View and select the Formula Bar checkbox. When it is checked, the bar should appear above the worksheet grid.

Does hiding the formula bar protect sensitive formulas?
No. It is only a screen-layout choice. Use worksheet protection and the Hidden cell property if you need formulas not to appear in the formula bar for protected cells, and remember that sheet protection is not a substitute for controlling access to sensitive files.

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.