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:
- 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
Launch 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.
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 appear.
What is the shortcut key for Formula Bar in Excel?
There are different keyboard shortcuts depending on your action in the Formula Bar. The Ctrl+Shift+U key is used to expand or collapse the Formula Bar. You can press the Esc key to cancel the entry in the Formula Bar, whereas, on the other side, Enter key is used to complete the entry in the Formula Bar. The Ctrl + End key moves your cursor to the end in the Formula Bar, whereas, the Ctrl + Shift + End key selects all the text in the formula bar from the cursor position to the end.
What keyboard shortcut shows formulas?
If a formula is applied to a particular cell in Excel, you will see that formula in the Formula Bar when you select that cell. If you want to see the formula in the cell, you can double-click on that cell or use the Ctrl + tilde (~) keys. To hide the formula in the cell, use this keyboard shortcut again.
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.
