Enable Greyed Insert Button in Excel
Sometime the Row Insert or Column insert button get disabled/greyed out. Unsure of what happened. Here are few hints to bring it back.
Follow these simple steps to enable the Insert button in Excel.
- Close all Microsoft Excel Applications
- Press “Windows Key + R” & type “%appdata%\Microsoft\Excel”.
- Rename the file Excelnn.xlb to Excelnn.anything
Now, open any Excel file, right click on any cell & check whether the Insert button is enabled.
Note: This option works if the Excel file is not protected for editing. To know how to make a protected sheet to unprotected one refer this page.
Enable Insert Button from Options
If both the above options does not work, then try this alternate method.
- Goto Excel File menu -> Options -> Advanced
- Scroll to Cut,Copy, and Paste
- Enable check box for Show Insert Options button
- Scroll further down to “Display options for this Workbook”
- Check combobox ‘All’ under ‘For Objects, Show’
These 2 options will work out.
Now again go to the Excel worksheet & check whether you are able to see the Insert button.