Note: The other languages of the website are Google-translated. Back to English

How to show or hide formula bar in Excel?

To maximize workspace, we may hide Formula Bar in Excel. However, Formula Bar is necessary and helpful when we edit formulas in cells. Here are some tips to switch two screen settings in Excel: showing Formula Bar and hiding Formula Bar.


Show or hide the Formula Bar with checking or unchecking Formula Bar option

We can display or hide the Formula Bar under View tab in Excel Ribbon with Formula Bar option in the Show group.

If you want to show the Formula Bar, check the Formula Bar option; if you want to hide the Formula Bar, uncheck it.

Note: You can also get this Show Formula bar option by clicking the File (or Office button) > Options > Advanced > Display > Show Formula bar.


Show or hide the Formula Bar with Kutools for Excel

Kutools for Excel's View Options tool is designed to show or hide spreadsheet settings, such as Grid Lines, Page Break, etc. With it, we can easily display or hide the Formula Bar in Excel:

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Free Trial Now!

1. Click Kutools > Show / Hide > View Options, see screenshot:

2. In the View Options dialog box, check or uncheck the Formula Bar option under the Application Settings section. See screenshot:

3. Click Ok to apply the setting.(Note: If you want to apply this option to all the worksheets, please click Apply to all sheets.)

The View Options makes it possible to show or hide most of Microsoft Excel settings quickly, such as Inner Tabs, Formula Bar, Status Bar, Windows in Taskbar, Gridlines, Page Breaks, Display Zeros, Vertical Scrollbar, Horizontal Scrollbar, Sheet Tab, … etc. It will save your time in looking for these setting when you need to show or hide them.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now


Hide or Show Status Bar/Formula bar/Ribbon with just one click

If you have Kutools for Excel installed, its Work Area utility can help you quickly hide Status Bar, Formula Bar, or Ribbon easily in Excel, and also enables you to restore the default Excel view immediately.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

Click the Kutools > Work Area, it will automatically maximize the Excel window by hiding the Status Bar, Formula Bar, and Ribbon.

And you can also adjust the view by buttons in the Work Area Size window. See screen shot below:
doc show hide formula bar 0

If you need to restore the default Excel window, just click the first button in the Work Area Size window.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now


Demo: Show or hide formula bar in Excel window


Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Related articles:


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Comments (23)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Thank you, it helped.
Venu
This comment was minimized by the moderator on the site
Thank you its working.....
tahira
This comment was minimized by the moderator on the site
Thanks a lot, this is very helpful.
Srinivas
This comment was minimized by the moderator on the site
Thank you!! This is very helpful.
Srinivas
This comment was minimized by the moderator on the site
Yes really it helped to find out what i was looking for Thank u
Rajesh
This comment was minimized by the moderator on the site
Extremely helpful,simple when you know how!! thank you
Gill
This comment was minimized by the moderator on the site
:-) YES YES YES.. FINALY.. Thanks.....
Kristian
This comment was minimized by the moderator on the site
The excel options setting for formulas. For e.g: When linking my summary sheet to sheet 1 total it is not going to sheet 1 total cell but showing the command as follows: ='Sheet 1'!A65 Could you please advise upon the settings. Thanks in advance.
Ani
This comment was minimized by the moderator on the site
I have the "show formula bar" box checked but it still does not show. It does appear to be at the very top of my screen (just a tiny sliver) that does not get any bigger if I attempt to click on it). I have tried to turn it of, then back on but nothing changes. Suggestions? I am on a MacBook Pro, if that makes a difference
Dan
This comment was minimized by the moderator on the site
Not sure if my last post got posted, I have verified that the "show formula bar" is checked and it still does not show. I have tried checking it off, then back on but still doesn't show. It might possibly be visible at the very top of my screen (just a tiny sliver) but I can't get that to enlarge so that I can see it. HELP!
Dan
This comment was minimized by the moderator on the site
Helps a lot. I have been clicking and looking at the screen for the past 6 hours. And I couldn't find the slightest clue. Till I have found this. Thanks a lot. You are the best!!!!!
Daniel
This comment was minimized by the moderator on the site
thank u sooo much..... :-)
oshadi
This comment was minimized by the moderator on the site
Thank you so much..........................
Prem
This comment was minimized by the moderator on the site
Thank you!! Just spent 10 minutes on a Friday evening wondering where the heck my Formula Bar had gone. And now it's back, happy days, have a goood weekend :-)
Mary
This comment was minimized by the moderator on the site
Thank you for the solutions. My formula bar was missing and i find it very difficult to retrieve it. With the help of this forum this is really good.
TNUDF
This comment was minimized by the moderator on the site
Very Good, Thanks you
Mustakinur
This comment was minimized by the moderator on the site
thanks you...........................[quote]+5[/quote]
Surajit
This comment was minimized by the moderator on the site
Very Helpful Information, Thank you
Vishal
This comment was minimized by the moderator on the site
Thanks to God who gave you this wisdom, it was surely helpful to me.
silas
This comment was minimized by the moderator on the site
Thank you for the solutions. My formula bar was missing and i find it very difficult to retrieve it. With the help of this forum this is really good.
vikas
There are no comments posted here yet
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0  Characters
Suggested Locations