Insert key is Greyed-out/ now working in Microsoft Excel
As we have noticed, many of the customers are reporting that the Insert key is disabled/ not working in Microsoft Excel. When they try to insert something such as rows, columns and any image file in the Excel sheet. They are unable to do that because of Insert key is Grey-out.
Sometime the Row Insert or Column insert button get disabled/greyed out. Unsure of what happened. Here are 2hints to bring it back.
Follow these simple steps to enable the Insert button in Excel.
Let’s resolve in 2 ways
Method # 1
- Go to 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 combo box ‘All’ under ‘For Objects, Show’
Method # 2
If you are still facing this issue then follow the below steps to resolve this:
Step 1: Close your all Excel workbook which is currently opened.
Step 2: Go to your Windows Explorer and open “C” drive.
Step 3: Then Users > Select the user name here.
Step 4: Choose AppData here. (Sometimes it is not visible then click on View in Taskbar and then check Hidden items here).
Step 5: Then click on Roaming > Microsoft > Excel.
Step 6: Here you find a file with namely as “Excel15.xlb”.
Step 7: Right click on this file and rename its extension as “old” means which be as “Excel15.old”
These 2 options will work out.
Now again go to the Excel worksheet & check whether you are able to see the Insert button.
For any other concerns related to Office 365 plan and subscriptions. You can reach out to us by submitting a message/ on our contact page or you can directly mail us at bhavin@jayom.in. Check out our website https://www.jayom.net/shop to know about the services offered by us.
Posted on: April 7, 2021, by : Bhavin Thakkar