How to Show Formula Bar in Excel (Formula Bar Missing)


Posted: June 28, 2022

Have you ever been working in Excel and your Formula Bar goes missing?! It can be such a pain when your Formula Bar keeps disappearing in Excel but there are ways to easily get it back.

In this blog, I cover two ways to turn on your Excel Formula Bar:

  1. How to temporarily turn on the Formula Bar in Excel
  2. How to permanently turn on the Excel Formula Bar

Temporarily turning it on will mean your Formula Bar will only be on for that session you spend in Excel but will be turned off for any other sessions you spend in Excel.

Permanently turning it on will mean your Formula Bar will be turned on in that session and any other sessions you spend in Excel.

How to temporarily turn on the formula bar in Excel

In the example below, the Excel Formula Bar is missing when opening Excel.

Excel spreadsheet with red box around missing Formula Bar

If you are wanting to show the Formula Bar in Excel, follow these steps.

Step 1: Go to the View tab.

Excel ribbon with the View tab shown in a red box

Step 2: Check the box next to Formula Bar.

In the View tab, the Formula Bar check box is shown in a red box

The Formula Bar should now be shown in Excel.

Excel spreadsheet with the Formula Bar shown in a red box

However, when only temporarily turning on the Formula Bar, when you exit out of Excel and re-open it, the Excel Formula Bar disappears again.

Excel spreadsheet with missing Formula Bar

How to permanently turn on the Excel Formula Bar

To turn on the Formula Bar permanently, follow these steps:


Step 1: Go to the File tab.

Excel spreadsheet with the File tab shown in a red box

Step 2: Select Options.

In the File tab, the bottom left of Excel there is the Options button shown in a red box

An Excel Options dialogue box should now be displayed.

Excel Options dialogue box

Step 3: Select Advanced.

Excel Options dialogue box with the option Advanced shown in a red box

Step 4: Scroll to Display and check the box next to Show formula bar.

Excel Options dialogue box with the option Show formula bar checked and shown in a red box

Step 5: Select OK.

Excel Options dialogue box with the OK options shown in a red box

Your formula bar should now be on every time you open Excel and when creating new documents.

Excel spreadsheet with the Formula Bar shown in a red box

To sum up

There are two different options to turning on your Formula Bar in Excel. It can be turned on temporarily or permanently depending on what you are wanting.

Was this post helpful? Please let us know in the Comments below.

Join our free insiders Group!

Learn how to SAVE TIME and WORK SMARTER, without the 'techie' speak!

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Join our free insiders club! 

Receive 100+ Steps to Becoming Proficient in Excel

>