Hide formula bar

Home > Uncategorized > Hide formula bar

September 17th, 2005 Leave a comment Go to comments

Sometimes a formula becomes very long and it occupies lots of cells and it makes you crazy. So a better way would be
1. Record a macro, give a proper name, description and most importantly define a shortcut key, different from Excel’s shortcut keys.
2. Don’t record anything and stop the recording.
3. Press Alt + F11 to open the Visual Basic Editor , search for your macro inside “Modules” and insert this code in your macro.

‘ hideformulabar Macro
‘ Macro recorded 9/17/2005 by Ashutosh

If Application.DisplayFormulaBar Then
Application.DisplayFormulaBar = False
Else
Application.DisplayFormulaBar = True
End If

That’s it. Whenever you’re done editing the formula just press the shortcut key to bring it back press it again.

If you want to do it manually, please follow these steps:
1. Click on Tools – on the menu
2. Click on Options
3. In the View Tab uncheck Formula Bar
4. Hit ok.

OR you can press these shortcut keys in Sequence>> Alt + T, O, ALt + F, Enter