I have Excel 2013 on Windows 7. When I right click on a row the Context Menu appears. However the strange thing I notice is that the Insert option is simply disabled by Excel on the Context Menu. See the screenshot.

There are no merged cells or anything like that just plain numbers in a column and that’s it. There’s nothing to the right of the sheet or anything else that would prevent Excel from allowing to Insert, just in case.

The Insert option on the ribbon works fine as expected though. It’s disabled only on the Context Menu. I have no clue what causes Excel to disable Insert on Context Menu and is there any setting or way to get it working again or is this the default behavior?

Insert Disabled on context menu


Do the following:

  1. Close all open Excel workbooks
  2. In Windows Explorer, go to directory "C:\Users\<user>\AppData\Roaming\Microsoft\Excel"
  3. Find the file Excel15.xlb
  4. Rename this file to: Excel15.old
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.