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 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. Read: How to get a list of Files in a Folder 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 cell; in this tutorial, we will discuss how to Hide and Unhide Formula Bar in Excel. 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.
