Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete on right click menu disabled
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!)? -- cheers pamb |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete on right click menu disabled
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 "PamB" wrote in message ... 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!)? -- cheers pamb |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete on right click menu disabled
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 "Ron de Bruin" wrote: 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 "PamB" wrote in message ... 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!)? -- cheers pamb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Right click disabled | Excel Discussion (Misc queries) | |||
Right Click Pop Up Menus Disabled | Excel Discussion (Misc queries) | |||
How to delete item on right click menu? | Excel Discussion (Misc queries) | |||
Lost Toolbar / Right click disabled | Excel Discussion (Misc queries) | |||
Right Click disabled for Chart only | Charts and Charting in Excel |