Delete Columns/Row not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Do you have any merged columns or rows on the sheet perhaps? sometimes that
can prevent you from doing certain things.
 
No. This happens for any new/old workbook. P.G.

tim m said:
Do you have any merged columns or rows on the sheet perhaps? sometimes that
can prevent you from doing certain things.
Click to expand...
 
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
 
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
 
This is the strangest darn thing.

Try re-setting the Worksheet Menu.

Tools>Customize>Toolbars.

Select Worksheet Bar and "reset".


Gord
 
I agree. Resetting the Worksheet Menu does not solve the problem. Searching
Google under 'Excel Delete Greyed', I found that someone else had a similar
problem. He mentioned something about IT guy installing ADO and Visual Office
Studio ( I think it is VSTO). I did have VSTO runtime installed. But I do not
think VSTO itself is the problem as I have the Delete function working in a
Virtual PC instance with Excel 2003.

Without re-install, I tried customizing the Edit menu by adding Delete
Columns command. It is working fine in Edit ( but not by right-clicking).
-PG
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Find values across a row and return a text value from the same column 2
Showing Letters For Column Headers Rather Thann Numbers ? 1
Deleting Rows - only deletes content 2
Insert Row formatting 1
Locking rows and columns 2
I can only delete an entire row not a cell in excel 2013? 1
Quick way to expand all columns to show all data? 4

Back
Top