Hide formula bar

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

About the Author

The author of Tableau Data Visualization Cookbook and an award winning keynote speaker, Ashutosh R. Nandeshwar is one of the few analytics professionals in the higher education industry who has developed analytical solutions for all stages of the student life cycle (from recruitment to giving). He enjoys speaking about the power of data, as well as ranting about data professionals who chase after “interesting” things. He earned his PhD/MS from West Virginia University and his BEng from Nagpur University, all in industrial engineering. Currently, he is leading the data science, reporting, and prospect development efforts at the University of Southern California.

  • Anonymous says:

    Thanks for the macro. Who woulda thunk it… : )

  • >