Question Locked

How to Hide and Unhide the Formula Bar in Excel?

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

I do not wish to see the formula bar on the top of the spreadsheet, how can i take it off?

6 replies

by jibrinbitrus1

carry out the following actions below in order, 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
6.Launch Excel.

[i]Spam link removed by moderator.[/i]

by wilsonhenry13463 edited

Click Options to activate the Excel Options
In the Excel Options dialog, activate the Advanced option.
Scroll down to Display
Check or uncheck the Show Formula bar option depending on your preferences.
Click the OK button to apply your changes.

by ready.09whippet

Often when doing ctrl alt v quickly I miss a key and it causes my formula bar to disappear. It’s got to the stage where it happens a few times a day and is really annoying to go and get it back.

Is there a specific short cut that I’m doing to hide it and is there a way to disable this?

by pumper05sanity

Hide Formulas In Protected Worksheet

I am sure that there are some projects where we did lots of research to create complex formulas, calculation and we do not want to show those amazing tricks which we created by ourselves but people can read your formulas in “Formula Bar” even if you have protected the sheet

Though you can hide Formula Bar but still you can hide formulas without hiding the Formula Bar:

Select the Cells, Range which is formula driven cells/range.

Right Click on the Selected Ranges and click on Format Cells

Go to Protect Tab and Check the box “Hidden” and click “Ok”. It will hide the formulas

Now when you protect the worksheet, it will hide all the formulas where you have ticked this box

by Ada James

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

This discussion is closed to new replies.