Other·301 discussions

How to Hide and Unhide the Formula Bar in Excel?

Locked

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?

Topic

RE:

In reply to How to Hide and Unhide the Formula Bar in Excel?

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]

Spreadsheet

In reply to How to Hide and Unhide the Formula Bar in Excel?

Open the spreadsheet and click the File menu.

Then select Excel Options and go to the Advanced tab. Then go to the Display section.

Uncheck Show Formula Bar and click OK
https://img-23.ccm2.net/qdDV9jRPL6ModGDwdpHyyozckxA=/500x/010da5bdbf8f47b9809d6d5b80e8820f/ccm-faq/hina4Txp-ex11-s-.png

Hide and Unhide the Formula Bar in Excel

In reply to How to Hide and Unhide the Formula Bar in Excel?

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.

Reply To: How to Hide and Unhide the Formula Bar in Excel?

In reply to How to Hide and Unhide the Formula Bar in Excel?

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?

Reply To: How to Hide and Unhide the Formula Bar in Excel?

In reply to How to Hide and Unhide the Formula Bar in Excel?

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

Reply To: How to Hide and Unhide the Formula Bar in Excel?

In reply to How to Hide and Unhide the Formula Bar in Excel?

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.

[Author]

Replies