Have you ever been working in Excel, and your Formula Bar goes missing?!
It can be a pain when your Formula Bar keeps disappearing in Excel, especially when trying to check or create formulas and functions in the worksheet.
Thankfully, there are ways to get the Formula Bar back easily.
Turning it on temporarily will mean your formula bar will only be on for your current session in Excel. The Formula Bar will disappear and be turned off the next time you log into Excel.
Permanently turning it on will mean your Formula Bar will be turned on in your current session and any other sessions you spend in Excel.
Show Formula Bar in Excel temporarily
In the example below, the Excel Formula Bar is missing when Excel is opened.
To show the Formula Bar in Excel, follow these steps.
Step 1: Go to the View tab.
Step 2: Check the box next to Formula Bar.
The Formula Bar should now be shown in Excel.
However, this only temporarily turns on the Formula Bar. When you exit out of Excel and re-open it, the Excel Formula Bar disappears again.
Show Formula Bar in Excel permanently
To turn on the Formula Bar permanently, follow these steps:
Step 1: Go to the File tab.
Step 2: Select Options.
An Excel Options dialogue box should now be displayed.
Step 3: Select Advanced.
Step 4: Scroll to Display and check the box next to Show formula bar.
Step 5: Select OK.
Your formula bar should now be displayed every time you open Excel.
To Sum Up
There are two different options for showing the Formula Bar in Excel. It can be turned on temporarily or permanently, depending on your preference.
Was this post helpful? Please let me know in the comments below.
Certified Microsoft Office Specialist
Was this blog helpful? I’m here to empower your journey with Excel, aiming to make your daily tasks more efficient and boost your potential.
Share your thoughts in the Comments below – your insights not only enrich others, they also help me tailor future content to your needs.
And if you’re looking to take a step further, join our exclusive ‘Insider Group‘. As a member, you’ll receive Weekly Super-Tips, and early access to in-depth tutorials. Sign up Today!”
Happy Excel-ling!!
Suggestion does not work. Formula bar is checked but bar does not stay on. Keep having to select ‘home’ to display then cancels each time an input function is selected
Hi Tony. How annoying. Did you work through the steps for ‘Show Formula Bar in Excel permanently’?