How to Delete a Comment in Excel: A Complete Guide

Excel's comment and note features are genuinely useful — until they clutter your spreadsheet or become outdated. Whether you're cleaning up a shared workbook or removing annotations before sending a file to a client, knowing exactly how to delete comments (and understanding the difference between comment types) saves time and prevents confusion.

Comments vs. Notes: Why the Distinction Matters

Before diving into deletion methods, it helps to understand what you're actually removing. Excel has two distinct annotation types, and they behave differently:

In Microsoft 365 and Excel 2019+, what was historically called a "comment" is now labeled a Note, while the newer threaded annotation type is the official Comment. This labeling shift trips people up constantly, especially when menus reference both.

Knowing which type you're dealing with determines which menu option you'll use — and why the "Delete Comment" option sometimes appears grayed out.

How to Delete a Single Comment or Note

Using the Right-Click Context Menu

The fastest method for removing one annotation at a time:

1. Right-click the cell containing the comment or note
2. Look for "Delete Comment" or "Delete Note" in the context menu
3. Click it — the annotation is removed immediately

The label you see (Delete Comment vs. Delete Note) depends on your Excel version and which annotation type is attached to that cell.

Using the Review Tab on the Ribbon

The Review tab is your central hub for annotation management:

1. Select the cell containing the comment or note
2. Navigate to the Review tab in the ribbon
3. In the Comments group, click Delete

In Microsoft 365, you'll also see separate Notes and Comments sections within the Review tab, which makes it clearer which type you're targeting.

Keyboard Shortcut Approach

Excel doesn't have a single dedicated keyboard shortcut for deleting comments, but you can move quickly by:

• Selecting the target cell
• Pressing Alt → R → D (sequential key presses, not simultaneous) to trigger Delete via the Review tab in Windows

This is useful when you're working through a long list of annotated cells and want to keep your hands on the keyboard.

How to Delete Multiple Comments at Once 🗑️

Removing comments one by one across a large spreadsheet isn't practical. Here are faster approaches.

Select All Comments, Then Delete

1. Press Ctrl + A to select all cells, or manually select a range
2. Go to Home → Find & Select → Comments (or Notes, depending on version)
3. This highlights every cell containing an annotation
4. Right-click any highlighted cell → Delete Comment (or Delete Note)

All selected annotations are removed in one action.

Using Go To Special

1. Press F5 or Ctrl + G to open the Go To dialog
2. Click Special
3. Select Comments or Notes from the options
4. Click OK — Excel selects all annotated cells in the sheet
5. Right-click → Delete Comment/Note

This method is particularly reliable across older Excel versions where menu labels vary.

Deleting Comments in a Specific Range

If you only want to clear annotations within a defined area:

1. Highlight just that range (e.g., columns A through D)
2. Use Find & Select → Comments — this will only select annotated cells within your highlighted area
3. Right-click → Delete

This is useful in shared workbooks where you want to preserve comments in one section while clearing another.

Deleting Threaded Comments in Microsoft 365

Threaded comments work slightly differently because they can contain multiple replies. Deleting the parent comment removes the entire thread — including all replies from collaborators. This is worth considering before you delete in a team environment.

To delete just a single reply within a thread:

1. Open the comment thread by clicking the purple-triangle cell
2. Hover over the specific reply
3. Click the three-dot menu (⋯) that appears
4. Select Delete

To delete the entire thread:

1. Select the cell
2. Review tab → Delete in the Comments group
3. Or right-click the cell → Delete Comment

Common Reasons Delete Doesn't Work ⚠️

A few situations prevent comment deletion:

• Sheet is protected — comment deletion is blocked on protected sheets. You'll need to unprotect the sheet first via Review → Unprotect Sheet (requires the password if one is set)
• Workbook is shared in legacy mode — certain sharing configurations restrict editing permissions
• You're targeting the wrong annotation type — if you right-click and only see "Delete Note" but you're looking for a threaded comment (or vice versa), check which corner triangle color the cell displays

Variables That Shape Your Experience

How comment deletion actually works in practice depends on several factors that differ by user:

• Excel version — Microsoft 365 subscribers see updated menus and the Notes/Comments split; Excel 2013 users work with a unified "Comments" system
• Operating system — Mac Excel has slightly different menu layouts and lacks some ribbon keyboard shortcuts
• File format — working in .xls (older format) vs. .xlsx affects which comment types are supported
• Collaboration context — shared workbooks and cloud-based files (Excel Online) have permission layers that affect what you can delete and when
• Sheet protection settings — whether an admin or colleague locked the sheet determines whether deletion is available without additional steps

Excel Online (the browser version) also handles this differently from the desktop app — the interface is simplified, and some bulk-deletion options available in desktop Excel aren't present in the web version.

What works cleanly in a solo local spreadsheet may behave differently in a heavily formatted, protected, or multi-user file — and that's where your specific setup becomes the deciding factor.