Excel Insert Rows or Columns Command Is Disabled: How to Fix It
Question details
The user needs to restore the disabled Insert rows and columns command in Excel 365, which stops working when row or column headers are selected across multiple workbooks.
- Product
- Microsoft Excel 365
- Device & OS
- Windows
- Scenario
- While editing Excel 365 workbooks on Windows, the user tries to insert rows or columns by selecting a row or column header, but the Insert command is unavailable.
- Observed behavior
- Excel 365 disables the Insert command when a row or column header is selected, although inserting from the Ribbon or from a cell still works. The issue appears in multiple workbooks.
Close all Excel windows before renaming or deleting the Excel settings file. If you plan to use WPS Spreadsheets as an alternative, save and close the workbook in Excel first so it can be opened cleanly.
Reset the Excel .xlb Settings File
Use this first when the Insert command is disabled in Excel 365 across multiple workbooks, because a corrupted .xlb settings file is the most common cause.
Excel stores toolbar, command bar, and editing settings in an .xlb file. When this file becomes corrupted or conflicts with Excel 365, certain commands such as Insert can be disabled even though the underlying workbook is fine.
Save any open workbooks and exit all Excel 365 windows completely before changing the settings file.
Open File Explorer, paste %AppData%\Microsoft\Excel into the address bar, and press Enter.
Locate the .xlb file, right-click it, choose Rename, and change the extension to .old. Alternatively, delete the file.
Launch Excel 365, open a workbook, select a row or column header, and try Insert again. Excel creates a fresh settings file automatically.
Check for Workbook Protection, Macros, or Active Content Restrictions
Use this if resetting the .xlb file does not restore Insert, to determine whether the restriction is workbook-specific rather than Excel-wide.
Open the Workbook in WPS Spreadsheets and Insert Rows or Columns
Use this when you need to continue working immediately without being blocked by Excel's disabled Insert command.
Use WPS Spreadsheets as a Free Alternative When Excel Blocks Insert Commands
If Excel 365 continues to disable the Insert command because of a corrupted .xlb file or workbook restrictions, WPS Office is a free, lightweight Microsoft Office alternative. It opens and saves Excel .xlsx files with familiar ribbon tools, so you can insert or delete rows and columns and keep working without complex Excel setting resets.
Frequently Asked Questions
Why is the Insert command disabled only when I select a row or column header in Excel 365?
This often indicates a corrupted Excel settings file (.xlb). Because inserting from the Ribbon or from a cell still works, the header selection may trigger a conflicting command bar setting. Reset the .xlb file from %AppData%\Microsoft\Excel and test in a blank workbook.
Where do I find the .xlb file in Windows?
Close Excel, open File Explorer, and paste %AppData%\Microsoft\Excel into the address bar. Rename the .xlb file to .old or delete it; Excel recreates it automatically on next start.
Will deleting the .xlb file delete my Excel workbooks or data?
No. The .xlb file contains Excel command bar and setting customizations only. Your workbooks, data, formulas, and saved files remain untouched.
What should I do if Insert is still disabled after resetting the .xlb file?
Open a blank workbook to check whether the issue is workbook-specific. Then inspect the affected workbook for sheet protection, macros, active content restrictions, or forms under the Review tab and Trust Center.
Can WPS Office open my Excel file and insert rows or columns if Excel blocks the command?
Yes. WPS Spreadsheets supports .xlsx, .xls, and .csv files. Open the workbook in WPS Spreadsheets, select a row or column header, then right-click and choose Insert or use Home > Cells > Insert.
