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

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).

Hint



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 includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Read More      Free Download 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


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 includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.

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:

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. Click to know more about this feature.


arrow blue right bubbleRelated articles:


Is your problem solved?

Recommended Productivity Tools

The following tools will greatly save your time and effort, which one do you prefer?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: 120 powerful new functions for Excel, Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

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

gold star1 More than 120 powerful advanced functions which designed for Excel:

  • 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

Add comment


Security code
Refresh