Office Settings & Configuration

Restore Disabled Commands in an Excel Worksheet

Khadija KhanKhadija Khan Nov 18, 2026 870 views

Question details

The user needs to restore commands, such as adding notes, that are disabled in one Excel worksheet.

Restore Disabled Commands in an 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.
Before you start

Open the affected workbook and select the worksheet where commands are disabled. Check whether other worksheets in the same file allow the same action.

Solution 1Recommended

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.

1
Check sheet protection

Select the affected worksheet and open the Review tab. If Unprotect Sheet is available, select it and enter the password if prompted.

2
Check workbook protection

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.

3
Try the command again

Select a cell in the affected worksheet, then use Review > Notes > New Note, or the equivalent Notes command in your Excel version.

Check worksheet and workbook protection
Password required: If you do not know the protection password, ask the workbook owner to remove the protection or provide an editable copy.
Free Microsoft Office alternative

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.

Add and manage notes in editable spreadsheetsCompatible with Microsoft Excel formats, including XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
QA img-9

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.