Excel 2013 Insert and Delete (column/row) grayed out for all workbook

Anonymous
2013-09-23T11:31:31+00:00

Hello -

I have an odd issue.   No matter if it is a new or existing workbook my insert and delete row/column options are greyed out.   The workbook is not protected as this happens for even brand new ones as well.  I have searched and cannot locate a solution.

Excel 2013 - Click to run

Windows 8

Any thoughts would be appreciated.

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2013-09-23T11:35:20+00:00

Just solved my own issue.

Had to delete the \Office\15.0\Excel\Options via regedit.

Problem resolved.

Was this answer helpful?

100+ people found this answer helpful.
0 comments

60 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-04-14T01:13:20+00:00

    Check your 'Table' Settings. If you click on a cell and 'Table Tools' tab pops up, click the button that says 'Convert to Range'. 

    Fixed my problem. I don't know why it was set up as a Table to begin with...

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2016-04-13T23:44:35+00:00

    i did the same in EXCEL 2010 ..thanks to jamestuck..

    and thanks to MadhuparnaC..for excel14.xlb.

    i think this problem appears for anyone who enables macros for income tax return form of india. Best is to use java version IT RETURNS . SO THIS WILL NT CHANGE EXCEL!

    It worked for me  for Excel 2010.

    Changed  Excel14.Xlb to Excel14.Old  in the folder

    C:\Users\Square K\AppData\Roaming\Microsoft\Excel

    I faced this problem after using the India income tax returns ITR2 in macro mode.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2015-09-01T07:49:59+00:00

    worked!!!!!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2015-08-10T06:01:44+00:00

    Hi,

    I had the same problem today.

    You simply need to close Excel, then navigate to "%appdata%\Microsoft\Excel" in Windows explorer and rename Excel15.xlb to Excel15.old, and finally restart Excel and the problem should be fixed.

    Cheers

    James

    Very helpful.....I have read lot of comment but not get the solution through your point it short out.....Thanks for this...

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments