How to show or hide formula bar in MS Excel

The Excel application allows users to organize their data in a table that can contain numeric or alphanumeric values. Not only that, users can also manipulate data by applying one or more formulas using cell numbers and predefined mathematical operations like sum, subtotal, etc.

Some users have reported that the formula bar is missing from their Excel application and they cannot find it. It may be hidden by some other users on the system who enable it in the application.

In this article, we will show you how to show or hide the formula bar in MS Excel application on Windows system.

How to show or hide the formula bar in MS Excel

Step 1: Open the Excel application on your system. To do this, first press the Windows key and type excel on your keyboard.

Step 2: Then, press the Enter key or select the Excel application from the search results as shown in the screenshot below.

Step 3: Now you need to open any existing saved Excel worksheet from your computer or just click on Blank Workbook# from the options ##,As follows.

Step 4: After opening the excel sheet, go to the top menu bar and click on the

in the far right corner to view as shown below.

Step 5: Then, in the "

Show" section, you will see the "Formula Bar" checkbox.

Note: Please make sure you click on any cell in the worksheet. Otherwise, the Formula Bar checkbox option will appear grey.

Step 6: Please click the "

Formula Bar" checkbox to make it appear below the ribbon, as shown in the figure below.

Step 7: If you don’t need the formula bar, then you can do it by

unchecking the Formula Bar checkbox Hide it to make more space for the worksheet in the Excel application as shown below.

That’s all. This way you can show/show or hide the formula bar in the Excel application on your system.

The above is the detailed content of How to show or hide formula bar in MS Excel. For more information, please follow other related articles on the PHP Chinese website!