Document Editing Problems

Fix Missing or Disabled Insert Rows and Columns in Excel 365

Khadija KhanKhadija Khan Nov 18, 2026 868 views

Question details

The user needs to insert rows or columns when the right-click Insert command is missing or disabled.

Fix Missing or Disabled Insert Rows and Columns in Excel 365
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.
Before you start

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.

Solution 1Recommended

Check worksheet protection and editing permissions

Use this solution when insertion is disabled in a particular workbook or worksheet.

1
Check sheet protection

Open the affected worksheet and select Review > Unprotect Sheet if it appears. Enter the password if prompted, or ask the workbook owner for access.

2
Check editing 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.

3
Test a local copy

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.

4
Try a new workbook

Select File > New > Blank workbook, then right-click a row or column header and check whether Insert is available.

Check worksheet protection and editing permissions
Workbook structure protection: Review > Protect Workbook controls changes to the workbook's sheet structure. It does not normally prevent inserting rows or columns within a sheet.
Free Microsoft Office alternative

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.

Insert and edit spreadsheet rows and columns in WPS SpreadsheetOpen and save compatible Microsoft Excel XLSX and XLS filesUse a familiar interface for an easier transition from Microsoft OfficeWork with a free, lightweight office suite
QA img-9

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.