Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Hide Formula Bar in Excel (and Show)? 3 Easy Ways

How to Hide Formula Bar in Excel (and Show)? 3 Easy Ways

(Note: This guide on how to hide formula bar in Excel is suitable for all Excel versions including Office 365)

Have you ever felt the presence of the formula bar a little inappropriate for your needs and requirements in your current worksheet? In such cases, you might want to hide them and display the formula bar again only when needed.

In this article, I will tell you 3 ways to hide formula bar in Excel and how to display the hidden formula bar in Excel.

You’ll Learn:

  • What Is the Formula Bar and Why Is It Important?
    • Parts of a Formula Bar in Excel?
  • Why Hide the Formula Bar in Excel?
  • How to Hide the Formula Bar in Excel?
    • From the View Main Menu
    • From Excel Options
    • Using the Hotkeys

Watch our video on how to hide the formula bar in Excel in 3 easy ways

Related Reads:

How to Merge Cells in Excel? 3 Easy Ways

How to Convert Formulas to Values in Excel? 6 Easy Methods

How to Copy Only Visible Cells in Excel? 3 Easy Ways

What Is the Formula Bar and Why Is It Important?

Excel predominantly deals with a variety of formulas and functions. Some data might be a direct result of specific formulas and others might be a connecting link that provides a resultant value to other formulas. So, how do you find which formula corresponds to the value and which formula is used to find the resultant value? 

Here is where the Formula Bar comes into play. 

The formula bar is one of the most important tools in Excel. Using this bar, you can write formulas, view them, and search for formulas. Even though you can enter the formulas from the cells, the Formula bar will be useful when you have to enter long formulas and refer to them. Not only does the formula bar shows the formulas, but it also displays the data of any data type present in the cell.

Parts of a Formula Bar in Excel?

The formula bar is found below the main menu ribbon. It consists of:

  1. Name Box: This shows the cell or cell range selected. 
  2. Insert Function (fx): This contains the list of formulas based on category and you can refer to or use them. The X and ✔ are used to close and enter the function respectively.
  3. Down-arrow: the dropdown arrow to the right of the formula bar is used to extend it when the formulas are lengthy. You can also drag the formula bar to extend it.
The Formula Bar in Excel
The Formula Bar in Excel

Why Hide the Formula Bar in Excel?

We might have seen how to hide formulas from showing up in the formula bar in Excel, but in some cases, you might even need to hide the whole formula bar. By default, the formula bar shows up when you open Excel. 

There might be a variety of reasons why you want to hide formula bar in Excel. 

  • If you are an expert and are comfortable writing the formula in the cells, you might not need the formula bar. 
  • Hiding the formula bar makes up more space for other rows to be visible. Only 28 rows are visible with the formula bar displayed, and 30 rows when the formula bar is hidden. 
  • Hide the formula bar while presenting and sharing to keep the viewers from knowing the formula used to get the value, thereby maintaining confidentiality.

But, in some cases, the formula bar might be involuntarily or accidentally hidden.

Now, let us see how to hide formula bar in Excel and how to show the formula bar if they are hidden.

Also Read:

How to Count Cells with Text in Excel? 3 Different Use Cases

How to Select Non Adjacent Cells in Excel? 5 Simple Ways

How to Add a Secondary Axis in Excel? 2 Easy Ways

How to Hide the Formula Bar in Excel?

There are multiple ways to hide formula bar in Excel and in the same way you can revert them. 

From the View Main Menu

This is a direct method to hide the formula bar in Excel. 

  1. To hide formula bar in Excel, first, open any spreadsheet and select any cell. The cell can contain formulas and data, or it can even be an empty cell.
  1. Navigate to View. Under the Show section, uncheck the checkbox for the Formula Bar. You can see that the instant you uncheck the checkbox, the formula bar disappears.
How to hide formula bar in excel using the View main menu
How to hide formula bar in Excel using the View main menu

In the same way, you can choose to show the formula bar in Excel.

Just navigate to View, and check the box for Formula Bar. The formula bar appears with the formula of the selected cell.

Show formula bar in Excel
Show formula bar in Excel

From Excel Options

This is another method to hide formula bar in Excel. 

  1. Open any Excel workbook. Navigate to File and click on Options
Hide formula bar using the Excel options
Hide formula bar using the Excel options
  1. This opens the Excel Options dialog box. In the dialog box, click on Advanced in the left pane. Scroll down and under the Display options, uncheck the checkbox for the Show formula bar. Click OK.
Uncheck the formula bar checkbox
Uncheck the formula bar checkbox

This hides the formula bar from the Excel workbook. 

In case you want to display the formula bar, navigate to File and click on Options. Under Advanced, scroll down to the Display section and check the checkbox to show the formula bar. Click OK. This displays the formula bar below the main menu ribbon.

Using the Hotkeys

This is the easiest and fastest method to hide or show the formula bar in Excel. With the help of a few keyboard taps, you can easily hide or show the formula bar in Excel. 

This method works on the principle that pressing certain keys in successions act as an alternative to manually navigating and selecting the options.

  1. Open an Excel workbook.
  1. Press the Alt key. Once you press the Alt key, Excel shows you a layout of shortcut keys that correspond to a specific function.
Press ALT
Press ALT
  1. Press the keys which are mapped to View and the ones which are mapped to the Formula Bar checkbox.
  1. Press W and press V and then F. This instantly hide the formula bar.
Hide Formula bar in Excel using the hotkeys
Hide Formula bar in Excel using the hotkeys

You can use the same method If the formula bar is already hidden and you want to display it. Press the keyboard shortcut key Alt and then W, V, and F one after the other to show the formula bar in Excel.

Note: Changing the visibility of the formula bar applies to the whole Excel workbook. If you hide the formula bar and open a new Excel workbook/worksheet, the changes will persist unless you change the settings to show the formula bar.

Suggested Reads:

How to Wrap Text in Excel? With 6 Simple Methods

How to Graph a Function in Excel? 2 Easy Ways

How to Create an Excel Slicer? 2 Easy Ways

Frequently Asked Questions

What is the easiest way to expand the formula bar?

Use the shortcut keys Ctrl+Shift+U to immediately expand the formula bar. If not, you can also drag and expand the formula bar in Excel.

Why is the show/hide Formula Bar checkbox grayed out in the View menu?

Select any cell in the worksheet to enable the options to show or hide the formulas in Excel. If you click on the formula bar or anywhere else, the option to hide or show the formula bar will be grayed out.

How to hide only formulas without hiding the formula bar?

You can hide the cells from showing formulas by navigating to Format Cells and by protecting and locking the sheets.

Closing Thoughts

In this article, we saw 3 methods on how to hide the formula bar in Excel and display it when needed. 

Some people prefer having the formula bar displayed in their worksheet, others prefer it hidden. There are several instances where hiding the formula bar is necessary and you have to display them again after. This is where hiding the formula bar is useful.

If you need more high-quality Excel Guides, please check out our free Excel resources center. Simon Sez IT has been teaching Excel for ten years. For a low monthly fee, you can get access to 130+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Add Error Bars in Excel? 7 Best Methods

How to Use Flash Fill With Microsoft Excel 2013

How to Crop a Photo and Images in Adobe Photoshop Elements 2019

How to Use the Selection Brush in Photoshop Elements 15

How to Create an Asana Gantt Chart in 5 Simple Steps

Workbook Views and Using the Zoom Feature in Microsoft Excel 2016

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)