This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Just solved my own issue.
Had to delete the \Office\15.0\Excel\Options via regedit.
Problem resolved.
For me, turning off any filtering on columns brought the Home - Insert - Insert Cells option back.
This is what finally worked for me. Rest of the solutions didn't work !
YIkes!
Anyone try un-sorting all their columns? I tried all solutions on 10 different websites and then realized that I had 'Sort & Filter' on within my sheet. Unsorted every column back to 'Select All' and boom. There is my Insert option when I right click in a cell. Done. Dusted.
Glad to know you fixed the issue. Thank you for sharing the resolution, as this would help other members of the community facing the same issue.