Do you mean right-clickFormat 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 ViewImmediate 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
wrote:

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