delete on right click menu disabled

[PamB]

The delete command on the right click menu in excel 07 is disabled but only
when I'm trying to delete an entire row. It works fine for a single or
multiple columns, also fine for individual cells or cell selections, but I
have to use the ribbon command button to delete rows.
This occurs in every workbook, old and new. I'm running 07, SP1.

Does anyone know how to enable this functionality (which should be enabled
by default anyway!)?

 

[Ron de Bruin]

Try this

Alt F11
Ctrl g to open the Immediate window
Enter this line in this window and press enter
Application.CommandBars("Row").Reset


You can also use

Ctrl + to add a row and Ctrl - to delete a row when you select it
(Use the + and - on numeric keyboard)

 

[PamB]

Thank you SO much, it worked perfectly. I know it's not a crucial option, but
when things don't work properly it's frustrating. That's wonderful - thanks
again!
--
cheers
pamb

Try this

Alt F11
Ctrl g to open the Immediate window
Enter this line in this window and press enter
Application.CommandBars("Row").Reset


You can also use

Ctrl + to add a row and Ctrl - to delete a row when you select it
(Use the + and - on numeric keyboard)

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm