Turn off the mini toolbar in Excel 2007

Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today

Have you ever noticed if you select some text in Microsoft Excel 2007 you get a little pop-up menu.  You know the one, it lets you change the font, the font size, the font colour and a lot more.

Some people think it is great.  Some people think it is annoying.

I think it is great, but as a service to you, I will let you know how to turn it off, and stop it from popping up!

  1. Click on the menu – the “Office Orb” (that circle in the top left hand corner which used to be the file menu!)
  2. Click on “Excel Options”
  3. Look in the “Popular section”, under “Top options for working with Excel
  4. Untick the “Show Mini Toolbar on selection” checkbox
  5. Hit ok

There you go – no more annoying (not) popup mini menu in Excel 2007

’till next time!



Technorati Tags: ,

4 thoughts on “Turn off the mini toolbar in Excel 2007

  1. This is the method that disable a Mini toolbar that dispays when you click right button of mouse without selecting a text.


    Right-click in the right-hand panel, select New and DWORD Value – name it AllowMenuFloaties and leave the value set to 0.

    The entry for Word under Toolbars might not exist unless you’ve already de-selected the option to ‘Show Mini Toolbar on selection’ as per the main article above (this writes a DWORD called AllowSelectionFloaties and sets the value to 0).

    This also works for Excel as well.

Leave a Reply

Your email address will not be published. Required fields are marked *