Fix Disabled Sheet Insert, Delete, Rename, and Move Commands in Excel
Question details
The user needs to restore access to Excel commands for inserting, deleting, renaming, and moving worksheets.

- 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.
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.
Remove Excel Workbook Structure Protection
Check workbook structure protection first, because it can disable sheet-level commands throughout a workbook.
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.
Select Review > Protect Workbook to turn protection off. Enter the password if prompted, provided you have authorization to remove it.
Right-click a sheet tab and check whether Insert, Delete, Rename, and Move or Copy are available.

Repair the Affected Excel Workbook
Use this approach if sheet commands work in other workbooks and removing protection does not resolve the issue.
Run an Online Repair of Microsoft Office
If the same commands are disabled in multiple unprotected workbooks, repair the Office installation on Windows.
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.

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.




