Excel Remove All Comments

What this does

Modern Excel splits cell annotations in two. Review ▸ New Comment creates a threaded comment built for back-and-forth discussion, with a Reply box and the author's name. Review ▸ Notes ▸ New Note creates the old yellow sticky note for a standalone remark. Both attach to a cell, mark it with a small triangle in the corner (purple for comments, red for notes), and show on hover. Shift+F2 adds one to the active cell. Review ▸ Show Comments opens the side pane to read them all at once. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. Treat “excel remove all comments” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected comments shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a data step that keeps your analysis trustworthy into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

Right-click cell B2 and choose New Comment, type "Verify this figure with finance", then click away — a purple triangle appears in the corner of B2. Hover over B2 to read it, or click the triangle to reply. To leave a plain remark instead, pick Review ▸ Notes ▸ New Note and type the note. Comments and notes let you attach context — a caveat, a source, a question for a colleague — to a specific cell without cluttering the data itself. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. Treat “excel remove all comments” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.

Common mistakes

• Confusing threaded comments with notes — converting a sheet between them loses the reply threads.
• Expecting comments to print by default — set Page Setup ▸ Sheet ▸ Comments to "At end of sheet" or "As displayed" first.
• Deleting a cell's contents and assuming the comment goes too — right-click ▸ Delete Comment to remove it.
• Looking for New Note under New Comment — in Microsoft 365 notes live under the separate Review ▸ Notes button.

Frequently asked questions