Hide the Formula Bar
This tutorial shows how to hide a Formula Bar
Hiding the Formula Bar in Excel comes in useful when a user wants to maximise the workplace in Excel. If you are working with a small screen, want to present a summary of your work or just view more rows without zooming out, than hiding the Formula Bar can give you that extra space you are looking for.
View tab > Show group > Uncheck Formula Bar checkbox
| 1. Select the View tab. |  |
| 2. Click on the Formula Bar checkbox, in the Show group, to unselect the checkbox. |  |
| This image shows the result of these two steps. As you can see the Excel Formula Bar has now been hidden. This will apply to all sheets in the workbook. Note: Excel does not have the ability to hide the Formula Bar in only a specific number of sheets. |
 |
NOTES
This method shows how to hide the Formula Bar by using a checkbox from the excel ribbon, in the View tab. To hide the Formula Bar the checkbox needs to be unchecked and to show the Formula Bar the checkbox needs to be checked. By using this method you can hide the Formula bar in two steps. This example assumes that the Formula Bar is not hidden and therefore the checkbox is originally checked. From the two examples in this tutorial this is the quicker method.
This method shows how to hide the Formula Bar by using a checkbox from the excel ribbon, in the View tab. To hide the Formula Bar the checkbox needs to be unchecked and to show the Formula Bar the checkbox needs to be checked. By using this method you can hide the Formula bar in two steps. This example assumes that the Formula Bar is not hidden and therefore the checkbox is originally checked. From the two examples in this tutorial this is the quicker method.
File tab > Options > Advanced > Uncheck Show formula bar checkbox
| 1. Select the File tab. |  |
| 2. Click on Options. |  |
| 3. Select Advanced. |  |
| 4. Click on the Show formula bar checkbox, in the Display section, to unselect the checkbox. |  |
| 5. Click OK |  |
| This image shows the result of these five steps. As you can see the Excel Formula Bar has now been hidden. This will apply to all sheets in the workbook. You will also notice that the Formula Bar checkbox in the View tab has also been unchecked. Note: Excel does not have the ability to hide the Formula Bar in only a specific number of sheets. |
|
NOTES
This method shows how to hide the Formula Bar by using the Show formula bar checkbox, through an Excel Options menu. To hide the Formula Bar the checkbox needs to be unchecked and to show the Formula Bar the checkbox needs to be checked. By using this method you can hide the Formula bar in five steps. This example assumes that the Formula Bar is not hidden and therefore the checkbox is originally checked. From the two examples in this tutorial this is the longer method.
This method shows how to hide the Formula Bar by using the Show formula bar checkbox, through an Excel Options menu. To hide the Formula Bar the checkbox needs to be unchecked and to show the Formula Bar the checkbox needs to be checked. By using this method you can hide the Formula bar in five steps. This example assumes that the Formula Bar is not hidden and therefore the checkbox is originally checked. From the two examples in this tutorial this is the longer method.
VBA METHOD 1. Hide the Formula Bar using VBA
VBA
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Show the Formula Bar | How to show the Formula Bar | |
| Expand the Formula Bar | How to expand the Formula Bar | |
| Collapse the Formula Bar | How to collapse the Formula Bar | |
| What is the Formula Bar? | Explanation about the Formula Bar |