Turn On Formula Bar – Turn Off Formula Bar

September 17th, 2004 | Categories: General | Tags:

When creating an Excel template you may want to turn off the formula bar to limit unwanted user actions.

If you are using a spreadsheet and the formula bar is missing you may want to turn it back on.

To toggle the formula bar On or Off:

On the main menu bar
1. Click Tools
2. Select Options
3. Select the View tab
4. Removing a checkmark next to the Formula bar option will remove the formula bar. Placing a checkmark next to the Formula bar option will add the formula bar. Click OK.

FormulaBarToggle

To do this from VBA take a look at Excel VBA: Turn On Formula Bar – Turn Off Formula Bar


Leave a comment | Trackback
  1. MichaelW
    January 19th, 2009 at 11:49
    Reply | Quote | #1

    What about when that doesn’t work? Formula bar stays gone, regardless of checkmark status…

  2. Nicole
    September 3rd, 2009 at 22:41
    Reply | Quote | #2

    Thank you!

  3. JasonW
    February 8th, 2010 at 18:46
    Reply | Quote | #3

    I though I was loosing my mind, thanks for the FYI, exactly what I needed!