How to Hide and Unhide the Formula Bar in Excel

In Microsoft Excel, the Formula Bar is the toolbar at the top of the spreadsheet that lets you enter or view the information in a cell; instead of calculating a long formula in your cell, it can be calculated on the Formula Bar because of its wide width. The Formula Bar is visible in Excel by default and will allow users to view and enter formulas in an active cell in the spreadsheet; the Formula Bar also consists of the fx button, which consists of various formulas in Excel, an enter button, a cancel button, and a name box. If the user does not wish to see the formula bar on the top of the spreadsheet, there is a feature available in Excel to hide and unhide the Formula Bar.

How to Hide and Unhide the Formula Bar in Excel

Follow the steps below to Hide and UnHide formula bar in Microsoft Excel:

  1. Launch Excel
  2. Click the View tab
  3. Uncheck the checkbox for the Formula Bar in the Show group.
  4. The Formula Bar will disappear
  5. Check the checkbox to unhide the Formula Bar

Launch Excel.

How to Hide and Unhide the Formula Bar in Excel

Click the View tab and uncheck the checkbox for the Formula Bar in the Show group.

The Formula Bar will disappear.

Check the checkbox again to unhide the Formula Bar.

There is a second method you can use to hide the Formula Bar:

Click the File tab.

Click Options on the Backstage View.

An Excel Options dialog box will open.

Click Advanced on the left pane.

In the Display section, uncheck the checkbox for the Show formula bar option.

Then click OK.

To unhide the Formula Bar open the Excel Options dialog box again.

In the Display section, check the checkbox for the Show formula bar option.

Then click OK.

The Formula Bar will appear.

Read: How to get a list of Files in a Folder into Excel.

How do I unhide the formula bar in Excel?

The Formula is on the top of the Excel spreadsheet, which showcases formulas or other data you input into an active cell; in this tutorial, we will discuss how to Hide and Unhide Formula Bar in Excel.

We hope this tutorial helps you understand how to hide and unhide the Formula Bar in Excel; if you have questions about the tutorial, let us know in the comments.

How to Hide and Unhide the Formula Bar in Excel

Source link

Alice AUSTIN

Alice AUSTIN is studying Cisco Systems Engineering. He has passion with both hardware and software and writes articles and reviews for many IT websites.

Leave a Reply