How to hide or show Excel Formula bar

Excel Formula Bar is shown in below image.

Sometimes you may need to hide Excel Formula Bar to make more room for your Excel worksheet or make the missing Formula Bar visible. You can hide Excel Formula Bar or show your missing hidden Excel Formula Bar, by following any of below methods.

Method 1 - Hide/Show Excel Formula bar from Excel Ribbon

To hide Excel Formula Bar or to show your missing hidden Excel Formula Bar from Excel Ribbon, follow these steps

Step 1 - Click on "View" Tab on Excel Ribbon.

Step 2 - Go to "Show" Group in Ribbon's "View" Tab.

Step 3 - Uncheck "Formula Bar" checkbox to hide Formula Bar

Or

Check "Formula Bar" checkbox to show missing hidden Formula Bar, as explained in below image.

As you can see from the below image, Excel Formula Bar is hidden now.

Method 2 - Hide/Show Excel Formula bar from "Excel Options" window

Click the following link if you are not familiar with Excel Options Dialog Box Window.

You can achieve the same results explained in above method, using "Excel Options" Window. Follow below steps to hide Excel Formula Bar or to show missing hidden Formula Bar.

Step 1 - Open "Excel Options" window from Excel Backstage View.

Step 2 - Open "Advanced" Panel in "Excel Options" window by clicking on it.

Step 3 - Scroll down to "Display".

Step 4 - Uncheck "Show formula bar" Checkbox to hide Formula Bar

Or

Check "Show formula bar" Checkbox to show hidden Formula Bar, as explained in below image.

Step 5 - Click "OK" button in Excel Options window.