How to Hide the Formula Bar in Excel 2013

You can hide the Microsoft Excel 2013 formula bar by clicking the View tab at the top of the window, then unchecking the Formula Bar box.

The navigational ribbon in Microsoft Excel 2013 provides a means for 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

Now that you know how to hide the formula bar in Excel 2013, you will be able to toggle this part of the window on and off based on whether or not you want to see the formula that you have entered into a cell.

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 you ready to start applying them to your data? Read here for a brief overview of some popular formulas and how to use them.

Summary – Hiding the Excel Formula Bar

  1. Open Excel.
  2. Select the View tab.
  3. Click the box next to Formula Bar.

Changing the setting for the Excel formula bar is something that you can do whenever and as often as you would like. Additionally, electing to hide the formula bar in your workbooks won’t prevent you from using, viewing, or editing formulas in your spreadsheet.

Join Our Free Newsletter

Featured guides and deals

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