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
    2017-02-12T09:40:58+00:00

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-10-07T09:03:16+00:00

    Thanks issue resolved :)

    Prashant C Upadhye

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-09-28T12:17:37+00:00

    This is very helpful to me thank you james

    Was this answer helpful?

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