Tom’s Tutorials For Excel: Hide the right-click Mini Toolbar
In versions 2007 and 2010, there is a mini toolbar that appears when you right-click a worksheet cell. There is an option to show that mini toolbar but not an option to hide it.
In Picture #1, I have right-clicked cell D2 in order to copy the formula.
The mini toolbar above the right-click menu appears, uninvited, unwanted, and unavoidable.
What’s an Exceler to do?
To rid yourself of this nuisance:
From your worksheet press
Alt+F11 to get into the Visual Basic Editor.
Press Ctrl+G to show the Immediate window.
As shown in Picture #2, type this into the Immediate window and then press the Enter key:
Application.ShowMenuFloaties = True
Exit the Visual Basic Editor by pressing Alt+Q.