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

Related posts:

1. True blanks
2. Change the creation date of a workbook