View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Delete Columns/Row not working

This is the strangest darn thing.

Try re-setting the Worksheet Menu.

ToolsCustomizeToolbars.

Select Worksheet Bar and "reset".


Gord

On Mon, 7 May 2007 13:19:02 -0700, PGWU wrote:

This occurs with all the cases I have tried: existing workbooks with all
worksheets and a new workbook with all sheets. There are no disabled Add-in
items. I also tried Detect and Repair under Help with no sucess. -PG

"Gord Dibben" wrote:

This occurs with all existing workbooks on all worksheets?

Also all new workbooks?

Just one workbook?

Just one worksheet in that one workbook?

If the last, check to see if you have sheet protection enabled with the "Delete
Rows" enabled and "Delete Columns" disabled.


Gord Dibben MS Excel MVP

On Mon, 7 May 2007 09:56:01 -0700, PGWU wrote:

Hi All,

I have Excel 2003 and for some unknown reason, the Delete columns and rows
functions are not working properly. If I select a row or a column header, the
Delete in Edit is still greyed out. I can right-click and select Delete for a
row header, but not for a column header. Any suggestions? Thanks in advance.

P.G.