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 |
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 |
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 |
All times are GMT +1. The time now is 12:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com