Right mouse Clicking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help
Using Excel 2003. Yesterday when I was in any cell and did a right mouse
click I would get all sorts of options (Cut, Paste, Format, Column width,
etcc). Now I only get cut and paste. Where can I reset this.
Thanks
 
Are the other menu items there but just not available as in "grayed out"?

Your worksheet may be protected.

Tools>Protection>Unprotect Sheet.

Are the items missing completely?

You can try to reset the right-click menu.

Hit ALT + F11 to go to the VBEditor.

Then View>Immediate Window.

Copy/paste this line into the window and hit <enter>

Application.CommandBars("Cell").Enabled = True

OR copy/paste this sub to a module and run it.

Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub


Gord Dibben MS Excel MVP


Help
Using Excel 2003. Yesterday when I was in any cell and did a right mouse
click I would get all sorts of options (Cut, Paste, Format, Column width,
etcc). Now I only get cut and paste. Where can I reset this.
Thanks
Click to expand...

Gord Dibben MS Excel MVP
 
Thanks for the correction Ron.

These canned responses can lead to some interesting "typos".


Gord
 
Back
Top