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
    2015-04-02T09:42:48+00:00

    Hi,

    I had similar problem and in my case solution was quite simple.

    I've converted a range of my data to Table format. When I defined the table as range of columns ($A:$E) then I couldn't insert a new row ('Insert' was frozen). I've deleted one row and after that 'Insert' was enabled again. When I inserted new row, 'Insert' changed to frozen state.

    I've redefined a range of Table to -for example- $A1:$E10 and 'Insert' problem dissapeared.

    Conclusion: do not define Table as range of Columns ;)

    (Excel 2013)

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2015-03-12T15:38:58+00:00

    This method worked for me;

    If you can't insert rows, delete all rows below the active area of your worksheet.

    From the first empty row select a cell then hold CTRL+SHIFT and DOWN ARROW, right click highlighted cells and Delete

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    2015-01-01T17:06:51+00:00

    The Quick tool bar access item does not work. Ever since I upgraded and the system applied patches my MS office tools have all become challenges to use for all; docs and spreadsheets. Constantly have to fix the applications through control panel.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-11-11T16:40:33+00:00

    Good one - thanks James :-)

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments