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-08-04T11:05:56+00:00

    Close all Excel files

    Go to C:\Users<user>\AppData\Roaming\Microsoft\Excel

    Rename Excel15.xlb to Excel15.xlb.old

    Restart your Excel.

    .

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-07-27T09:18:55+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 alot.

    Issue has been resolved successfully.

    Nikhil

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-07-11T15:14:42+00:00

    Worked like a charm for me. Thanks, James.

    You probably should not have assumed that everyone knows how to navigate to appdata directory. I, for one, didn't. And it cost me another google search.

    Was this answer helpful?

    0 comments
  4. 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