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

Show or hide the Formula Bar with Kutools for Excel

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

One click to show/hide formula bar, Ribbon, or Status bar with Kutools for Excel!


arrow blue right bubble 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.


arrow blue right bubble 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 - Combines More Than 120 Advanced Functions and Tools for Microsoft Excel

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.

Free Trial Kutools for Excel Now


arrow blue right bubble 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 - Combines More Than 120 Advanced Functions and Tools for Microsoft Excel

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.

Free Trial Kutools for Excel Now


arrow blue right bubbleDemo: Show or hide formula bar in Excel window

Tip: In this Video, Kutools tab and Enterprise tab are added by Kutools for Excel. If you need it, please click here to have a 60-day free trial without limitation!


arrow blue right bubbleRelated articles:

 

Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more btn download btn purchase

Comments  

Permalink +5 Venu
Thank you, it helped.
2013-12-18 10:57 Reply Reply with quote Quote
Permalink +4 tahira
Thank you its working.....
2014-02-28 08:26 Reply Reply with quote Quote
Permalink +2 Srinivas
Thanks a lot, this is very helpful.
2014-04-04 16:33 Reply Reply with quote Quote
Permalink -1 Srinivas
Thank you!! This is very helpful.
2014-04-04 16:34 Reply Reply with quote Quote
Permalink 0 Rajesh
Yes really it helped to find out what i was looking for

Thank u
2014-04-29 21:15 Reply Reply with quote Quote
Permalink -2 Gill
Extremely helpful,simple when you know how!! thank you
2014-05-23 15:18 Reply Reply with quote Quote
Permalink +2 Kristian
:-) YES YES YES.. FINALY.. Thanks.....
2014-06-28 07:56 Reply Reply with quote Quote
Permalink -2 Ani
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.
2014-08-15 13:09 Reply Reply with quote Quote
Permalink -2 Dan
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
2014-09-02 15:11 Reply Reply with quote Quote
Permalink -2 Dan
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!
2014-09-02 16:01 Reply Reply with quote Quote
Permalink -2 Daniel
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!!!!!
2014-09-06 07:14 Reply Reply with quote Quote
Permalink -2 oshadi
thank u sooo much..... :-)
2014-10-31 05:00 Reply Reply with quote Quote
Permalink -3 Prem
Thank you so much........... ...............
2015-03-05 17:39 Reply Reply with quote Quote
Permalink -2 Mary
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 :-)
2015-04-24 16:09 Reply Reply with quote Quote
Permalink -1 TNUDF
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.
2015-07-06 06:31 Reply Reply with quote Quote
Permalink 0 Mustakinur
Very Good, Thanks you
2015-12-06 02:18 Reply Reply with quote Quote
Permalink 0 Surajit
thanks you............ ...............Quote:
+5
2015-12-30 09:14 Reply Reply with quote Quote
Permalink 0 Vishal
Very Helpful Information, Thank you
2016-05-05 05:26 Reply Reply with quote Quote
Permalink 0 silas
Thanks to God who gave you this wisdom, it was surely helpful to me.
2016-05-21 05:14 Reply Reply with quote Quote
Permalink 0 vikas
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.
2016-09-01 13:53 Reply Reply with quote Quote
Permalink 0 Joe
Worked for me as well. Thank you!
2017-01-09 20:35 Reply Reply with quote Quote

Add comment


Security code
Refresh