How to Hide the Formula Bar in Excel 2013

The formula bar above the cells in your Excel spreadsheet provides a convenient, centralized location for you to view and create formulas in your cells. But, depending on how you use Excel, you may not actually be using or need that space, as you are able to type formulas directly into your cells.

If you find the formula bar to be unnecessary and would prefer to move your spreadsheet up a little higher on the screen so that you can see more of it, then you might be looking for a way to get rid of the formula bar in Excel 2013. Our tutorial below will show you where to find and change this setting to remove Excel’s formula bar from view.


How to Remove the Formula Bar Above the Spreadsheet in Excel 2013

The steps in this article are going to show you how to hide the formula bar that appears above your cells in an Excel spreadsheet. This is a program-wide setting, so changing it once will affect the display of the formula bar for every other spreadsheet that you open in Excel 2013. Note, however, that this won’t prevent you from using or creating formulas. It just remove the formula bar.

Step 1: Open Excel 2013.


Step 2: Click the File tab at the top-left corner of the window.

how to hide the formula bar in excel 2013



Step 3: Click Options in the left column.

can i delete excel's formula bar



Step 4: Select the Advanced tab in the left column of the Excel Options window.

get rid of formula thing above spreadsheet



Step 5: Scroll down to the Display section of the menu, click the box to the left of Show formula bar to remove the check mark, then click the OK button at the bottom of the window.

excel 2013 how to remove formula bar



The formula bar should no longer be visible.


Having trouble getting your spreadsheet to print properly? Our guide will show you how to change the setting for a spreadsheet so that all of the columns automatically fit on one page when you go to print your spreadsheet.