Restore Missing Insert and Delete Options in Excel 2016
Question details
The user needs to restore the Insert and Delete commands in Excel's row and column right-click menus.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- The user wants to insert or delete rows or columns from the context menu.
- Observed behavior
- The Insert and Delete commands are missing from the row or column context menu.
Right-click a row number or column letter to check the correct context menu, and test a new blank workbook to see whether the issue affects more than one file. The troubleshooting paths below apply to Excel 2016 on Windows.
Reset Excel's user startup files
Use this method to test whether files in Excel's user settings or startup folder are causing the missing commands.
Save your open work and close all Excel windows.
Press Windows+R, enter %appdata%\Microsoft\Excel, and select OK.
Move the contents to a separate temporary folder so you can restore them later. This may include custom settings, templates, or startup workbooks.
Open Excel and right-click a row number or column letter. If the commands return, restore your files one at a time, restarting Excel after each, to identify the cause.

Test Excel in Safe Mode and disable add-ins
Use Safe Mode to check whether an add-in or startup customization is involved.
Repair the Office 2016 installation
Use Office repair if resetting startup files or testing add-ins does not restore the commands.
Manage Spreadsheet Rows and Columns with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets to continue working with rows and columns as you migrate between office suites.

Frequently Asked Questions
Why do Insert and Delete return in Excel Safe Mode?
Safe Mode bypasses some add-ins and startup customizations. If the commands return, restart Excel normally and test add-ins under File > Options > Add-ins, then inspect startup files if necessary.
What if removing an add-in does not restore the menu?
Other add-ins or startup customizations may still be involved. Check both COM Add-ins and Excel Add-ins under File > Options > Add-ins, and test the files in %appdata%\Microsoft\Excel.
Can worksheet protection prevent inserting or deleting rows?
Yes. Protection can restrict these actions. Check Review > Unprotect Sheet; you may need the sheet password. This is different from commands being missing in every workbook.
Will moving Excel's startup files remove my custom settings?
Moving the files can temporarily remove custom settings, templates, or startup workbooks. Keep the files in a separate folder and restore them one at a time after testing.




