Where is the Formula Bar in Excel 2013?

When reading tutorials online for Microsoft Excel 2013, you may occasionally some steps that ask you to do something with the Formula Bar. This is a horizontal field above your spreadsheet that displays the data contained within a cell. You can use this location to enter or edit data in your cells.

The Formula Bar is not completely necessary when using Excel 2013, and it can be hidden by users that wish to minimize the amount of clutter in the Excel window. So if you are looking for the Formula Bar but do not see it on the screen, then you can follow the steps below to display it.

 

Display a Hidden Formula Bar in Excel 2013

The steps below will assume that your Formula Bar is currently hidden from view, and that you wish to re-enable it so that you can use it to enter formulas. For the purposes of clarification, the Formula Bar is the horizontal field above the spreadsheet. It is the bar that is identified in the image below.

the formula bar in excel 2013

 

So if this is the bar that is currently hidden in your Excel 2013 version, then you can follow the steps below to show it.

 

  1. Open Microsoft Excel 2013. The Formula Bar display is not a setting that is specifically associated with a single spreadsheet, so you can just launch the Excel program to adjust the setting.
  2.  

  3. Click the View tab at the top of the window.
  4. click the excel 2013 view tab

     

     

  5. Check the box to the left of Formula Bar in the Show section of the ribbon at the top of the window. The Formula Bar should now be visible, as in the image below.

show the formula bar in excel 2013

 

 

Are your formulas visible in your spreadsheet cells, instead of the results of those formulas? You can change that behavior so that the formulas are hidden and you are instead looking at the calculations of those formulas instead.

Have you updated a value that is part of a formula, but the formula result is not changing? You may need to enable automatic calculation in Excel 2013 so that formulas are continuously updating as data is edited.

Recent Articles