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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2016-09-28T12:17:37+00:00

    This is very helpful to me thank you james

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-08-26T15:47:25+00:00

    I had the same problem - RESOLVED

    My table was as the button "format as tables" (where you can add multiple tables with unique filters in the same woorkbook)

    if you click on one cell and the "design tools" tab appears, it's formatted.

    just click to "convert to range in the design tools tab.

    Now you can add or delete.

    redo the format table button if you need it

    thats' it :)

    Was this answer helpful?

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