Office Settings & Configuration

Fix Disabled Sheet Insert, Delete, Rename, and Move Commands in Excel

Chanuka GeekiyanageChanuka Geekiyanage Nov 20, 2026 870 views

Question details

The user needs to restore access to Excel commands for inserting, deleting, renaming, and moving worksheets.

Fix Disabled Sheet Insert, Delete, Rename, and Move Commands in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Managing worksheet tabs in an Excel workbook.
Observed behavior
Insert, Delete, Rename, and Move or Copy commands are unavailable across the workbook.
Before you start

Open another workbook and check its sheet-tab commands to see whether the issue affects one file or multiple files. If the affected workbook is confidential, avoid sharing it when requesting help.

Solution 1Recommended

Remove Excel Workbook Structure Protection

Check workbook structure protection first, because it can disable sheet-level commands throughout a workbook.

1
Check workbook protection

Open the affected workbook and select Review > Protect Workbook. If workbook structure is protected, the command will be highlighted or indicate that protection is active.

2
Remove protection

Select Review > Protect Workbook to turn protection off. Enter the password if prompted, provided you have authorization to remove it.

3
Test the sheet commands

Right-click a sheet tab and check whether Insert, Delete, Rename, and Move or Copy are available.

Remove Excel Workbook Structure Protection
Password required: If you do not know the workbook protection password, ask the workbook owner or administrator for help.
Free Microsoft Office alternative

Manage Spreadsheet Sheets with WPS Office

WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and Microsoft Office format support make it easy to move between your existing files and WPS Spreadsheets.

Manage worksheet tabs in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why are Rename and Move or Copy grayed out in Excel?

Workbook structure protection can disable these commands across the workbook. Check Review > Protect Workbook and remove protection if you have the password and authorization.

Is workbook protection the same as sheet protection?

No. Workbook structure protection restricts actions such as renaming or moving sheets, while sheet protection restricts changes within a worksheet. Check Review > Protect Workbook for structure protection.

What should I do if I do not know the workbook protection password?

Contact the workbook owner or administrator for the password or an authorized unprotected copy. Excel may require the password when you select Review > Protect Workbook to turn protection off.

How can I tell whether the problem is with Excel or one workbook?

Open another workbook and right-click a sheet tab to test the same commands. If only one file is affected, try File > Open > Browse > Open and Repair. If multiple unprotected files are affected, consider repairing Office.