How do i enable right click on excel? Mine doesn't work.

R

Right Click Excel

Very odd but when I right click on a cell in Excel i don't get the formatting
options.
 
G

Gord Dibben

Do you mean right-click>Format Cells does not appear at all or is grayed out?

If grayed out, your sheet may be protected.

If not appearing at all, 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").Reset

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

Sub reset()
Application.CommandBars("Cell").Reset
End Sub


Gord Dibben MS Excel MVP

On Thu, 19 Apr 2007 10:38:06 -0700, Right Click Excel <Right Click
 
Top