Office Settings & Configuration

Restore Missing Insert and Delete Options in Excel 2016

Phi Hung VoPhi Hung Vo Nov 22, 2026 868 views

Question details

The user needs to restore the Insert and Delete commands in Excel's row and column right-click menus.

Restore Missing Insert and Delete Options in Excel 2016
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.
Before you start

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.

Solution 1Recommended

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.

1
Close Excel

Save your open work and close all Excel windows.

2
Open the Excel settings folder

Press Windows+R, enter %appdata%\Microsoft\Excel, and select OK.

3
Move the folder contents

Move the contents to a separate temporary folder so you can restore them later. This may include custom settings, templates, or startup workbooks.

4
Restart and test Excel

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.

Reset Excel's user startup files
Keep your custom files: Do not permanently delete the moved files. Restoring a problematic file may bring the issue back.
Free Microsoft Office alternative

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.

Insert and delete spreadsheet rows and columnsOpen and edit Microsoft Excel XLS and XLSX filesWork in a familiar, easy-to-use interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

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.