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!
- Click on the menu – the “Office Orb” (that circle in the top left hand corner which used to be the file menu!)
- Click on “Excel Options”
- Look in the “Popular section”, under “Top options for working with Excel
- Untick the “Show Mini Toolbar on selection” checkbox
- Hit ok
There you go – no more annoying (not) popup mini menu in Excel 2007
’till next time!
TNP
Thanks!
it did not work. still shows the mini tool bar
This is the method that disable a Mini toolbar that dispays when you click right button of mouse without selecting a text.
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Toolbars\Word
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.