How to show or hide formula bar in Microsoft Excel 2016 ?

Formula bar is one of the nice feature in Excel to display the formula and helps when editing the formula in a cell. There might be situations when you want to hide the formula bar in Microsoft Excel 2016.

image

How to show or hide formula bar in Microsoft Excel 2016 ?

There are couple of ways in which you can hide the formula bar in Microsoft Excel.

Option 1 : View Tab

Just Navigate to the View Tab in the Microsoft Excel 2016 Ribbon and uncheck the checkbox “Formula Bar” in the Show section.

image

Option 2 : Excel Options

You can also hide the Formula Bar via the Excel Options dialog.

Just Navigate to File –> Options.

In the Excel Options Dialog , select “Advanced” from the left sidebar. In the content pane , uncheck the checkbox “Show Formula bar” under the Display Section.

SNAGHTML2e02ffd

To show the formula bar , just enable the checkbox back from the above options.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.