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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2014-04-17T18:19:14+00:00

    Tried this.  Didn't work for me, either.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-05-13T18:17:43+00:00

    Not sure if you've sorted this or not, but my insert cells right or down shade out if my work book is part of a network, as other people in the office use the work book it has to be shared and via our network, but as soon as I take it off the network the options are available again?? I don't know yet how to get around this.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-07-11T13:31:23+00:00

    This was my workaround.  Originally, I had copied a column from another workbook.  Some sort of code from this grayed out the insert cell options.

    I simply copied the columns I wanted to compare into another blank workbook and the insert cells was offered again.

    Once I manage my data, I'll copy back into the original.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-09-10T14:31:08+00:00

    lol. It was just soooo much easier to do it this way:

    1. Go to Quick Access Toolbar/right click the button which is creating problem/Remove from quick Access toolbar
    2. Now go to HOME | CELLS | click drop down of INSERT/right click on Insert Sheet Rows/Add to quick access toolbar
    3. Same way include other buttons in Quick Access Toolbar.

    The complete thread can be found here:

    http://answers.microsoft.com/en-us/office/forum/office\_2010-excel/insert-rowscolumns-button-grayed-out/949fef7b-df69-4e64-a12f-ee78286d5ece

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments