Saturday, September 17, 2005
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.
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
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
' 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
