How to show or hide formula bar in Excel: VBA, shortcut

How to show or hide formula bar in Excel: VBA, shortcut

Microsoft Excel allows you to control the program display in various ways, including complete personalisation of the top ribbon. If you're finding the large top ribbon to be troublesome, we'll show you an easy way to create some more space on your computer screen.

How to hide the formula bar in Excel using VBA?

  • Enter the following code to turn off the formula bar:
Sub OffFormulaBar()
    Application.DisplayFormulaBar = False
End Sub
  • To turn the formula bar on, enter this code:
Sub OnFormulaBar()
    Application.DisplayFormulaBar = True
End Sub

Is there a shortcut to hide the formula bar in Excel?

Yes, pressing ALT W , V , F will hide the formula bar.

How to display or hide the formula bar in Excel?

Open your spreadsheet and click on the File menu. Next, click on Excel Options and move to the Advanced tab. Scroll to the Display section. Uncheck the box labeled Show Formula Bar and click OK:

N.B. This manipulation can also be performed via the View menu.

Need more help with Excel? Check out our forum!