How to Hide and Unhide the Formula Bar in Excel

Download PC Repair Tool to quickly find & gear up Windows errors automatically

In Microsoft Excel, the Formula Bar is the toolbar at the top of the spreadsheet that lets you lot enter or view the information in a cell; instead of computing 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 past default and will allow users to view and enter formulas in an active jail cell in the spreadsheet; the Formula Bar too consists of the fx push, which consists of various formulas in Excel, an enter button, a abolish button, and a proper noun box. If the user does non wish to run across the formula bar on the top of the spreadsheet, there is a feature bachelor in Excel to hide and unhide the Formula Bar.

How to Hide and Unhide the Formula Bar in Excel

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

Launch Excel
Click the View tab
Uncheck the checkbox for the Formula Bar in the Evidence group.
The Formula Bar will disappear
Cheque the checkbox to unhide the Formula Bar

Launch Excel.

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

The Formula Bar will disappear.

Check the checkbox again to unhide the Formula Bar.

There is a second method you tin utilise 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 Brandish department, uncheck the checkbox for the Show formula bar option.

And so click OK.

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

Click Advanced on the left pane.

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

Then click OK.

The Formula Bar will announced.

Read: How to become a listing of Files in a Binder 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 jail cell; in this tutorial, we will hash out how to Hide and Unhide Formula Bar in Excel.

Nosotros hope this tutorial helps y'all sympathise how to hide and unhide the Formula Bar in Excel; if y'all have questions nigh the tutorial, let united states of america know in the comments.

Shantel is a university student studying for Bachelor of Scientific discipline in Information technology. Her goal is to become a Database Ambassador or a Arrangement Administrator. She enjoys reading and watching historical documentaries and dramas.