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 Excel Options

Show or hide the Formula Bar with VBA code

Show or hide the Formula Bar with Kutools for Excel

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.
With formula bar
Without formula bar

arrow blue right bubble Show or hide the Formula Bar with checking or unchecking Formula Bar option

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

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.


arrow blue right bubble Show or hide the Formula Bar with Excel Options

You can also show or hide by checking the Formula Bar option in Excel Options with following steps:

1. Click the File tab in Excel 2010/2013, or Office button in Excel 2007.

2. Then click the Options button.

3. Now it displays the Excel Options dialog box, click the Advanced category at left pane.

4. Go to the Display section, check or uncheck the Show formula bar option.

5. Click OK button to save setting.


arrow blue right bubble Show or hide the Formula Bar with VBA code

The following short VBA code also can help you show or hide the formula bar as you need.

1. Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

2. Then click Insert > Module, and paste the following macro in the Module Window.

VBA for displaying formula bar in Microsoft Excel

Private Sub Workbook_Activate()
Application.DisplayFormulaBar = True
End Sub

VBA for hiding formula bar in Microsoft Excel

Private Sub Workbook_Activate()
Application.DisplayFormulaBar = False
End Sub

3. Press the F5 key to run this code. And you will get the result that you want.


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.


Related articles:


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Add comment


Security code
Refresh