How to Hide the Formula Bar in Excel 2013

The navigational ribbon in Microsoft Excel 2013 provides a means fro you to access the various tools and settings that are available for your spreadsheet. We have recently written about how to hide the ribbon if you want, which can be a welcome change for individuals that feel like too much of their spreadsheet is lost from view.

But there is another section of your spreadsheet that is taking up space and, fortunately, you can also elect to hide the formula bar as well. This is the large horizontal bar between the ribbon and the spreadsheet, identified in the image below.

the excel 2013 formula bar



Hiding the Formula Bar in Microsoft Excel 2013

The steps below will hide the formula bar from view in every spreadsheet that you open in Microsoft Excel 2013. If you want to see the formula bar again, then you will need to follow the steps below again in order to show it.


Step 1: Open Microsoft Excel 2013.


Step 2: Click the View tab at the top of the window.

click the view tab



Step 3: Uncheck the box to the left of Formula Bar in the Show section of the navigational ribbon.

uncheck the formula bar option



As mentioned earlier, this setting will persist even after you have closed Excel. You will need to re-enable this option to get the formula bar back above your spreadsheet.


Are you just getting started with Excel formulas and are ready to start applying them to your data? Read here for a brief overview on some popular formulas and how to use them.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides