Fix Missing or Disabled Insert Rows and Columns in Excel 365
Question details
The user needs to insert rows or columns when the right-click Insert command is missing or disabled.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Editing a worksheet and attempting to insert rows or columns from the right-click menu.
- Observed behavior
- The Insert command is missing or unavailable in the right-click menu.
Select a row or column header and check whether Insert is available on the right-click menu. Confirm that you have permission to edit the workbook and, if needed, access to the sheet protection password.
Check worksheet protection and editing permissions
Use this solution when insertion is disabled in a particular workbook or worksheet.
Open the affected worksheet and select Review > Unprotect Sheet if it appears. Enter the password if prompted, or ask the workbook owner for access.
If the file opens in Protected View, select Enable Editing when you trust the file. For a shared file, ask the owner to confirm that you have edit permission.
Select File > Save As and save a copy locally, then try inserting a row or column. A copy of a protected sheet may still require the password.
Select File > New > Blank workbook, then right-click a row or column header and check whether Insert is available.

Use the Excel ribbon to insert rows or columns
Use the ribbon as a workaround while investigating the right-click menu.
Test Excel add-ins in Safe Mode on Windows
Use this solution when the right-click command is also missing in a new workbook on the same Windows installation.
Edit Spreadsheet Rows and Columns with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet to continue editing as you move between office suites; it does not repair Excel's right-click menu.

Frequently Asked Questions
Why is Insert disabled when I right-click a row in Excel?
The sheet may be protected or the file may not allow editing. Check Review > Unprotect Sheet and confirm your editing permissions with the file owner.
Can I insert a column without using the right-click menu?
Yes. Select a column header, then choose Home > Insert > Insert Sheet Columns. This requires permission to edit the sheet.
How do I know whether an add-in is affecting the menu?
On Windows, close Excel and run excel.exe /safe from Windows+R. If Insert works in Safe Mode, check add-ins under File > Options > Add-ins.
Will saving a shared workbook locally remove sheet protection?
Not necessarily. File > Save As can help you test a local copy, but a protected sheet may still require its password before you can insert rows or columns.




