Fix Grayed-Out Insert Rows and Columns in Microsoft Excel
Question details
The user needs to restore the Insert Rows and Insert Columns commands in Microsoft Excel when they are unavailable during normal use.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to add worksheet rows and columns. The commands are available in Excel Safe Mode but disabled when Excel starts normally.
- Observed behavior
- Insert Rows and Insert Columns are grayed out during normal startup. The user reports that disabling COM add-ins did not resolve the issue, so an add-in cause has not been confirmed.
Check whether the commands are disabled in one workbook or also in a new blank workbook, and press Esc to leave cell-editing mode before testing. The Safe Mode and COM add-in instructions below apply to desktop Excel on Windows.
Test Excel Safe Mode and isolate conflicting add-ins
Use this method when inserting rows and columns works in Safe Mode but not during normal Excel startup.
Safe Mode bypasses add-ins and other startup customizations. A successful Safe Mode test suggests a startup-related conflict, but it does not prove that a COM add-in is responsible.
Close all Excel windows. On Windows, press Windows+R, type excel /safe, and press Enter. Open the affected workbook, select a cell, and check Home > Insert > Insert Sheet Rows or Insert Sheet Columns.
Restart Excel normally, then select File > Options > Add-ins. In the Manage list, choose COM Add-ins and click Go.
Clear the checkbox beside one enabled add-in and click OK. Close all Excel windows, restart Excel normally, and test the Insert commands again.
If the commands remain disabled, return to File > Options > Add-ins > Manage: COM Add-ins > Go and disable the next add-in. Restart and retest after each change. Record which change restores the commands.
If disabling COM add-ins does not help, select File > Options > Add-ins, choose Excel Add-ins in the Manage list, and click Go. Clear enabled add-ins one at a time, restarting Excel normally and testing after each change.
Check worksheet protection and workbook-specific restrictions
Use these checks if the problem occurs only in a particular workbook or worksheet.
Repair Microsoft Office if the issue affects all workbooks
Consider an Office repair when add-in testing does not help and insertion is unavailable even in a new, unprotected workbook.
Continue Editing Rows and Columns with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making migration straightforward. You can use WPS Spreadsheet for everyday row and column editing while troubleshooting Excel, but it does not repair Excel’s disabled commands or bypass worksheet protection.
Frequently Asked Questions
Why do Insert Rows and Insert Columns work in Excel Safe Mode?
Safe Mode bypasses add-ins and some startup customizations. On Windows, launch it with Windows+R > excel /safe. If insertion works there, test add-ins through File > Options > Add-ins, but do not assume a COM add-in is the only possible cause.
What should I check if disabling COM add-ins does not help?
Check File > Options > Add-ins > Manage: Excel Add-ins > Go and test those add-ins individually. Also compare the affected workbook with File > New > Blank workbook and check Review > Unprotect Sheet for worksheet protection.
Can a protected worksheet allow users to insert rows and columns?
Yes. An authorized owner can unprotect the worksheet, select Review > Protect Sheet, and enable Insert rows and Insert columns in the permissions list. If those permissions are not allowed, insertion can remain unavailable.
Do I have to uninstall an add-in to test it?
No. Go to File > Options > Add-ins, select COM Add-ins or Excel Add-ins in the Manage list, click Go, and clear the add-in’s checkbox. Restart Excel normally to test the change.
Will WPS Office fix the grayed-out commands in Microsoft Excel?
No. WPS Office is a separate application, not an Excel repair tool. You can open a supported Excel file in WPS Spreadsheet and use its row and column insertion controls, provided the worksheet’s permissions allow editing.
