How to Hide Formula Bar in Excel (and Show)? 3 Easy Ways
(Note: This guide on how to hide formula bar in Excel is suitable for all Excel versions including Office 365)
Have you ever felt the presence of the formula bar a little inappropriate for your needs and requirements in your current worksheet? In such cases, you might want to hide them and display the formula bar again only when needed.
In this article, I will tell you 3 ways to hide formula bar in Excel and how to display the hidden formula bar in Excel.
You’ll Learn:
- What Is the Formula Bar and Why Is It Important?
- Why Hide the Formula Bar in Excel?
- How to Hide the Formula Bar in Excel?
Watch our video on how to hide the formula bar in Excel in 3 easy ways
Related Reads:
How to Merge Cells in Excel? 3 Easy Ways
How to Convert Formulas to Values in Excel? 6 Easy Methods
How to Copy Only Visible Cells in Excel? 3 Easy Ways
What Is the Formula Bar and Why Is It Important?
Excel predominantly deals with a variety of formulas and functions. Some data might be a direct result of specific formulas and others might be a connecting link that provides a resultant value to other formulas. So, how do you find which formula corresponds to the value and which formula is used to find the resultant value?
Here is where the Formula Bar comes into play.
The formula bar is one of the most important tools in Excel. Using this bar, you can write formulas, view them, and search for formulas. Even though you can enter the formulas from the cells, the Formula bar will be useful when you have to enter long formulas and refer to them. Not only does the formula bar shows the formulas, but it also displays the data of any data type present in the cell.
Parts of a Formula Bar in Excel?
The formula bar is found below the main menu ribbon. It consists of:
- Name Box: This shows the cell or cell range selected.
- Insert Function (fx): This contains the list of formulas based on category and you can refer to or use them. The X and ✔ are used to close and enter the function respectively.
- Down-arrow: the dropdown arrow to the right of the formula bar is used to extend it when the formulas are lengthy. You can also drag the formula bar to extend it.
Why Hide the Formula Bar in Excel?
We might have seen how to hide formulas from showing up in the formula bar in Excel, but in some cases, you might even need to hide the whole formula bar. By default, the formula bar shows up when you open Excel.
There might be a variety of reasons why you want to hide formula bar in Excel.
- If you are an expert and are comfortable writing the formula in the cells, you might not need the formula bar.
- Hiding the formula bar makes up more space for other rows to be visible. Only 28 rows are visible with the formula bar displayed, and 30 rows when the formula bar is hidden.
- Hide the formula bar while presenting and sharing to keep the viewers from knowing the formula used to get the value, thereby maintaining confidentiality.
But, in some cases, the formula bar might be involuntarily or accidentally hidden.
Now, let us see how to hide formula bar in Excel and how to show the formula bar if they are hidden.
Also Read:
How to Count Cells with Text in Excel? 3 Different Use Cases
How to Select Non Adjacent Cells in Excel? 5 Simple Ways
How to Add a Secondary Axis in Excel? 2 Easy Ways
How to Hide the Formula Bar in Excel?
There are multiple ways to hide formula bar in Excel and in the same way you can revert them.
From the View Main Menu
This is a direct method to hide the formula bar in Excel.
- To hide formula bar in Excel, first, open any spreadsheet and select any cell. The cell can contain formulas and data, or it can even be an empty cell.
- Navigate to View. Under the Show section, uncheck the checkbox for the Formula Bar. You can see that the instant you uncheck the checkbox, the formula bar disappears.
In the same way, you can choose to show the formula bar in Excel.
Just navigate to View, and check the box for Formula Bar. The formula bar appears with the formula of the selected cell.
From Excel Options
This is another method to hide formula bar in Excel.
- Open any Excel workbook. Navigate to File and click on Options
- This opens the Excel Options dialog box. In the dialog box, click on Advanced in the left pane. Scroll down and under the Display options, uncheck the checkbox for the Show formula bar. Click OK.
This hides the formula bar from the Excel workbook.
In case you want to display the formula bar, navigate to File and click on Options. Under Advanced, scroll down to the Display section and check the checkbox to show the formula bar. Click OK. This displays the formula bar below the main menu ribbon.
Using the Hotkeys
This is the easiest and fastest method to hide or show the formula bar in Excel. With the help of a few keyboard taps, you can easily hide or show the formula bar in Excel.
This method works on the principle that pressing certain keys in successions act as an alternative to manually navigating and selecting the options.
- Open an Excel workbook.
- Press the Alt key. Once you press the Alt key, Excel shows you a layout of shortcut keys that correspond to a specific function.
- Press the keys which are mapped to View and the ones which are mapped to the Formula Bar checkbox.
- Press W and press V and then F. This instantly hide the formula bar.
You can use the same method If the formula bar is already hidden and you want to display it. Press the keyboard shortcut key Alt and then W, V, and F one after the other to show the formula bar in Excel.
Note: Changing the visibility of the formula bar applies to the whole Excel workbook. If you hide the formula bar and open a new Excel workbook/worksheet, the changes will persist unless you change the settings to show the formula bar.
Suggested Reads:
How to Wrap Text in Excel? With 6 Simple Methods
How to Graph a Function in Excel? 2 Easy Ways
How to Create an Excel Slicer? 2 Easy Ways
Frequently Asked Questions
What is the easiest way to expand the formula bar?
Use the shortcut keys Ctrl+Shift+U to immediately expand the formula bar. If not, you can also drag and expand the formula bar in Excel.
Why is the show/hide Formula Bar checkbox grayed out in the View menu?
Select any cell in the worksheet to enable the options to show or hide the formulas in Excel. If you click on the formula bar or anywhere else, the option to hide or show the formula bar will be grayed out.
How to hide only formulas without hiding the formula bar?
You can hide the cells from showing formulas by navigating to Format Cells and by protecting and locking the sheets.
Closing Thoughts
In this article, we saw 3 methods on how to hide the formula bar in Excel and display it when needed.
Some people prefer having the formula bar displayed in their worksheet, others prefer it hidden. There are several instances where hiding the formula bar is necessary and you have to display them again after. This is where hiding the formula bar is useful.
If you need more high-quality Excel Guides, please check out our free Excel resources center. Simon Sez IT has been teaching Excel for ten years. For a low monthly fee, you can get access to 130+ IT training courses. Click here for advanced Excel courses with in-depth training modules.
Simon Calder
Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!