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 No 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 No comments

60 additional answers

Sort by: Newest
  1. Anonymous
    2016-03-06T16:31:00+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

    thanks a lot for same, worked perfectly. you guys are genius.........

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2015-12-23T10:04:38+00:00

    looks Indian Income Tax Return is the culprit. I too faced this issue while I tried upload the returns. I found difficult to find Excel15.xlb in %appdata%\Microsoft\Excel with my OS windows 10. But I did find and changed it. In effect, Excel15.xlb was disabled. 

    I agree & aspire to remove the Indian Income Tax Act from statutes as suggested by Sri Subramaniam Swamy.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2015-12-04T10:41:06+00:00

    I am facing same issue with MS Office excel 2010. please advice the solution

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2015-11-02T02:50:51+00:00

    It really worked for me, thank you. I appreciate your post!

    Was this answer helpful?

    0 comments No comments