Restore Disabled Commands in an Excel Worksheet
Question details
The user needs to restore commands, such as adding notes, that are disabled in one Excel worksheet.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to edit a worksheet and add notes, but some commands are unavailable.
- Observed behavior
- Commands are disabled in one worksheet, potentially because of protection or the file's read-only status.
Open the affected workbook and select the worksheet where commands are disabled. Check whether other worksheets in the same file allow the same action.
Check worksheet and workbook protection
Use this when commands are unavailable in a particular sheet or workbook structure commands are disabled.
Worksheet protection can restrict actions within a sheet, while workbook structure protection restricts actions such as adding, moving, or deleting sheets. Turning off Protected View does not remove either type of protection.
Select the affected worksheet and open the Review tab. If Unprotect Sheet is available, select it and enter the password if prompted.
On the Review tab, check Protect Workbook. If the workbook structure is protected, select the protection control to remove it and enter the password if prompted; some versions may show Unprotect Workbook.
Select a cell in the affected worksheet, then use Review > Notes > New Note, or the equivalent Notes command in your Excel version.

Check read-only status and Protected View
Use this when the workbook opens without editing permission or displays a security banner.
Work with Excel-compatible worksheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working with minimal disruption; resolving protection or permissions in Excel may still require the file owner's help.

Frequently Asked Questions
Why can I edit other sheets but not one worksheet?
The affected sheet may have its own protection settings. Select it and check Review for Unprotect Sheet; a password may be required.
Does enabling editing remove worksheet protection?
No. Enable Editing exits Protected View for a trusted file, but worksheet and workbook protection must be removed separately through the Review tab.
What does workbook structure protection restrict?
It can prevent structural changes such as adding, moving, or deleting worksheets. Check Review > Protect Workbook to see whether structure protection is enabled.
What can I do if I don't know the protection password?
Ask the workbook owner for the password, an unprotected copy, or permission to make the required changes.
How can I check whether an Excel file is read-only?
Look for Read-Only in the title bar and check File > Info for restrictions. If appropriate, use File > Save As to create a copy in a writable location.




