Office Settings & Configuration

Fix Excel Comment and Note Commands That Are Disabled

Jason MillerJason Miller Nov 12, 2026 869 views

Question details

The user needs to restore the ability to add comments or notes to cells in an Excel workbook.

Fix Excel Comment and Note Commands That Are Disabled
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user is editing a workbook and wants to use the Review tab to add cell comments or notes.
Observed behavior
The comment or note command may be unavailable or may not work when sheets are grouped or the workbook is shared and edited online.
Before you start

Check whether the workbook is currently shared with collaborators and whether it is open in Excel for the web. In the desktop app, look at the sheet tabs to see whether more than one worksheet is selected.

Solution 1Recommended

Ungroup selected worksheets before adding a comment or note

Use this solution when Excel commands are disabled because multiple worksheet tabs are selected as a group.

Excel restricts some commands while worksheets are grouped. A grouped workbook may show multiple highlighted sheet tabs, even if you intended to work on only one sheet.

1
Check the worksheet tabs

At the bottom of the Excel window, check whether multiple sheet tabs are highlighted or selected.

2
Ungroup the worksheets

Right-click any selected worksheet tab and choose Ungroup Sheets. You can also click a single unselected sheet tab to leave the group.

3
Add the comment or note

Select the target cell, open the Review tab, then choose New Comment or Notes > New Note.

Ungroup selected worksheets before adding a comment or note
Commands should be available again: After the sheets are ungrouped, Excel should allow comment and note commands for the active worksheet.
Free Microsoft Office alternative

Add Cell Comments and Notes with WPS Spreadsheet

If Microsoft Excel comment controls remain unavailable because of account, sharing, or organization restrictions, WPS Office provides a free, lightweight spreadsheet alternative with a familiar ribbon interface. Open your workbook in WPS Spreadsheet to review cell annotations and continue editing in a compatible desktop workspace.

Use spreadsheet review tools to add and manage cell comments and notes.Open and edit Microsoft Excel .xlsx and .xls workbooks with format compatibility.Work in a lightweight office suite with a familiar spreadsheet interface.Move existing files to WPS Office without complex conversion steps.
microsoft office alternative - wps office

Frequently Asked Questions

Why is New Comment grayed out in Excel?

New Comment can be unavailable when multiple worksheets are grouped, the workbook is read-only, or document permissions restrict editing. Right-click a selected sheet tab and choose Ungroup Sheets, then verify that Enable Editing is available.

What is the difference between a comment and a note in Excel?

A comment is a threaded conversation that can include replies and mentions. A note is a legacy-style cell annotation. In desktop Excel, go to Review > New Comment for a conversation or Review > Notes > New Note for a note.

Can Excel for the web affect comments and notes?

Yes. Browser-based sharing and coauthoring can change how comments and legacy notes are handled. If annotation features do not work as expected, pause web editing, open the workbook in desktop Excel, and save it there.

How do I tell whether worksheets are grouped in Excel?

Look at the sheet tabs along the bottom of the workbook. If several tabs are highlighted, they are grouped. Right-click one of the selected tabs and choose Ungroup Sheets.

Can organization settings prevent me from adding Excel comments?

Yes. Microsoft 365 administrators can apply policies, permissions, sensitivity labels, or protection settings that limit workbook editing. Ask your IT administrator to confirm whether comments are restricted for the file or account.