Fix the Disabled Insert Rows Option in an Excel Table
Question details
The user needs to enable row insertion in an Excel table.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Editing an Excel table and trying to insert rows.
- Observed behavior
- The Insert Rows command is disabled, although inserting columns remains available.
Click a cell inside the table to confirm that the Table Design tab appears. Identify the last row and column containing table data so you can check the table range.
Resize the Excel table to match its data
Use this when the table range extends beyond the data, especially if the entire worksheet was selected when the table was created.
Select any cell inside the table, then click the Table Design tab.
Click Resize Table and enter or select the range from the table headers through the final row and column containing table data. Click OK.
Right-click a cell in the table and choose Insert > Table Rows Above. Check whether the row can now be inserted.

Check whether the Excel worksheet is protected
Use this if row insertion is still unavailable after correcting the table range.
Test Excel add-ins if the problem affects multiple workbooks
On Windows, use Safe Mode to check whether an add-in is interfering with Excel.
Edit Excel Workbooks with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for working on spreadsheets. Open compatible Excel files and continue editing without changing your existing file format.

Frequently Asked Questions
Why is Insert Rows disabled when Insert Columns works?
The table range may extend to the bottom of the worksheet, leaving no room to expand downward. Select a table cell and check Table Design > Resize Table.
How do I find the Resize Table command?
Click any cell inside the table, then open Table Design > Resize Table. Set the range to include the headers and the rows and columns containing table data.
Can worksheet protection prevent me from inserting rows?
Yes. Open Review and look for Unprotect Sheet. You may need the sheet password or permission from the workbook owner.
What if the row command is disabled in every workbook?
On Windows, start Excel with excel /safe from the Run dialog and test again. If the command works in Safe Mode, check COM add-ins under File > Options > Add-ins.




