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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2015-06-24T17:16:18+00:00

    Hi,

    I tried this and it worked for me. I am not sure why this problem occured. If some one knows then please share.

    Cheers,

    Vinesh

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-07-06T14:17:21+00:00

    This is excellent. Thanks for the resolution. Although I'm using Excel 2010 and the file name was Excel14.xlb, I simply changed to Excel14.old  and  it worked.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2015-07-08T03:42:38+00:00

    Thanks to Mr jamestuck for giving the Solution

    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

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2015-07-10T10:51:24+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!

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments