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
    2015-09-02T00:53:42+00:00

    Your solution (changing xlb to old worked -- after unsuccessful other attempts

    Thank you

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-08-31T14:40:34+00:00

    worked for me , perfect Thanks a lot

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-08-16T13:39:25+00:00

    Yes, this worked for me as well. And you are probably right this might be due to IT return excel file macro. Thanks

    Was this answer helpful?

    0 comments
  4. Anonymous
    2015-08-06T15:02:57+00:00

    I noticed that it only occurs with a specific spreadsheet.

    I can insert and delete rows but not cells.

    I do not have any protection enabled and my other spreadsheets is working. Any idea why insert cells is greyed out and not an option when I right click? I can delete and add rows and columns.

    Was this answer helpful?

    0 comments