Document Editing Problems

How to Fix Missing New Note and Comment Options in Excel

Amos Gikunda Sep 30, 2026 868 views

Question details

The user is unable to add new notes or comments in an Excel workbook because the options are grayed out or missing, although existing comments can still be deleted.

How to Fix Missing New Note and Comment Options in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to add a new note or a threaded comment to a cell in a specific Excel workbook.
Observed behavior: The 'New Note' and 'New Comment' commands are disabled or missing from the context menu and Review tab in a specific workbook.

Before you start

Check the bottom of your Excel window to ensure you haven't grouped multiple sheet tabs together, and verify in the Review tab that worksheet protection is completely disabled, as both states will temporarily lock the comment features.

Solution 1Recommended

Use Keyboard Shortcuts and Test a Blank Workbook

Quickly bypass interface glitches using Excel's built-in keyboard shortcuts, and isolate the issue by testing a completely fresh workbook.

Sometimes the Excel graphical interface encounters temporary display glitches while the underlying features continue to work. Keyboard shortcuts can force the command to trigger.

Testing a fresh workbook helps determine if the issue is isolated to your current file or if your entire Excel application is corrupted.

Try note and comment shortcuts

Select the target cell in your affected workbook. Press 'Ctrl+Alt+M' to insert a new threaded comment, or 'Shift+F2' to insert a standard note.

Open a new blank workbook

Go to File > New and select 'Blank workbook'. Select any cell and attempt to add a comment or note using the right-click context menu.

Compare the results

If the shortcuts work in the blank workbook but fail in the original one, the issue is specific to that corrupted or restricted workbook.

Use Keyboard Shortcuts and Test a Blank Workbook

Shortcut Confirmation: If the keyboard shortcuts bypass the issue in your original document, you can continue working without needing advanced troubleshooting.

Solution 2

Process the File Through Excel for the Web

Uploading and editing the corrupted workbook through Excel's web version can often clear underlying desktop file glitches.

Solution 3

Launch Excel in Safe Mode

Starting Excel in Safe Mode disables third-party add-ins, helping you identify if an extension is interfering with your comment options.

Free Spreadsheet Software

Seamlessly Add Notes and Comments Using WPS Spreadsheet

If Excel continues to disable essential features due to workbook errors, open your file in WPS Spreadsheet. It provides a stable, user-friendly environment for reviewing, commenting, and annotating data without restrictive glitches.

1. Download WPS Office: Download and install the free WPS Office suite from the official website.
2. Open your workbook: Launch WPS Spreadsheet and open your affected .xlsx or .xls Excel workbook.
3. Select a cell: Click on the specific cell where you want to add a new annotation.
4. Insert the comment: Right-click the cell and select 'Insert Comment' from the context menu to type your text and save.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Easily insert, edit, and manage cell comments and notes without glitches.Lightweight software that runs smoothly without freezing.Familiar user interface with zero learning curve for Excel users.

Frequently Asked Questions

Why are the New Note and New Comment options disabled in my Excel workbook?

This typically occurs due to active worksheet protection, grouped worksheets (multiple sheet tabs selected simultaneously), or a workbook-specific file glitch. It rarely indicates a problem with the global Excel application.

What is the difference between a Note and a Comment in modern Excel?

Notes are used to leave simple, static text annotations or reminders in a cell, indicated by a yellow background. Comments are designed for collaboration, allowing for threaded conversations where multiple users can reply and mention each other.

Does protecting an Excel worksheet automatically disable comments and notes?

Yes, if a worksheet is protected and the option to 'Edit objects' is left unchecked during the protection setup, you will be unable to add or edit comments and notes. You must unprotect the sheet from the Review tab to restore this functionality.

Document & File Issues