ThisCalculator

Everyday

Select Cells with Comments in Excel: 3 Ways

Updated · Standard formula, shown below

To select all cells with comments in an Excel worksheet, use the Go To Special feature (Ctrl+G, then Alt+S, then C) or the Find and Replace dialog (Ctrl+F, then Options, then select “Comments” in the “Look in” dropdown). Both methods instantly highlight every commented cell, letting you review, format, or delete them in one action.

Why You Need to Select Commented Cells

Comments (now called “Notes” in newer Excel versions) are often scattered across a spreadsheet. Manually clicking each red triangle is slow and error-prone, especially when comments hide in large datasets or merged cells. Selecting them all at once lets you:

  • Review or edit multiple comments in one pass
  • Apply consistent formatting to commented cells
  • Delete all comments before sharing a workbook
  • Copy or move commented cells to another sheet

Both methods work in Excel 2010 through Microsoft 365, and the keyboard shortcuts are the same across Windows and Mac (with slight differences noted below).

Method 1: Go To Special (Fastest)

The Go To Special dialog is the most direct way. Here’s how:

  1. Press Ctrl+G (or F5) to open the Go To dialog.
  2. Click the Special button in the bottom-left corner.
  3. In the Go To Special dialog, select Comments and click OK.

Excel will immediately select all cells that contain comments. You’ll see them highlighted as a group (usually a white selection box with a border). If you have multiple non-adjacent commented cells, they’ll all be selected at once, ready for your next action.

Keyboard-only shortcut: After pressing Ctrl+G, press Alt+S to jump to the Special button, then press C to select Comments, then Enter. This works in all recent versions.

Method 2: Find and Replace

The Find dialog also has a hidden option to search for comments. This method is slightly slower but works the same way:

  1. Press Ctrl+F to open the Find and Replace dialog.
  2. Click Options to expand the dialog.
  3. In the Look in dropdown, select Comments (instead of “Formulas” or “Values”).
  4. Leave the Find what box empty.
  5. Click Find All.

This will list all commented cells at the bottom of the dialog. Click any item in the list, then press Ctrl+A to select all listed cells. Close the dialog, and all commented cells are selected.

Note: The Find All list shows the cell address and the comment text. If you want to select only cells with specific text in the comment, type that text in the Find what box first.

Method 3: VBA for Advanced Selection

If you need to select commented cells frequently, a simple VBA macro can automate it. Press Alt+F11 to open the VBA editor, insert a new module, and paste this code:

Sub SelectCommentedCells()
    Dim cell As Range
    Dim target As Range
    For Each cell In ActiveSheet.UsedRange
        If Not cell.Comment Is Nothing Then
            If target Is Nothing Then
                Set target = cell
            Else
                Set target = Union(target, cell)
            End If
        End If
    Next cell
    If Not target Is Nothing Then target.Select
End Sub

Run the macro (F5) and it will select all commented cells on the active sheet. This is especially useful when you need to run this repeatedly or combine it with other actions like deleting all comments.

Common Problems and Solutions

Here are a few issues you might encounter:

  • Go To Special doesn’t show Comments? This happens if your worksheet is in Grouped mode or if you have a filter active. Exit grouping (right-click a sheet tab and choose Ungroup) and clear any filters.
  • Comments vs. Notes: In Excel 365, “Comments” are the new threaded comments (with a reply box), while “Notes” are the old-style yellow sticky notes. The Go To Special method selects both types. If you want only one type, use the Review tab and filter by “Comments” or “Notes” in the Show Comments pane.
  • Selecting comments on multiple sheets: The methods above work on the active sheet only. To select commented cells across all sheets, you’ll need to repeat the process on each sheet or use a VBA loop that iterates through all worksheets.
  • Merged cells: If a comment is attached to a merged cell, Go To Special will select the entire merged range. That’s usually what you want.

How to Delete All Comments at Once

Once you’ve selected all commented cells, deleting them is easy:

  1. Right-click any selected cell.
  2. Choose Delete Comment (or Delete Note in newer versions).

Alternatively, go to the Review tab, click the Delete dropdown, and choose Delete All Comments on Sheet. That works without selecting cells first.

Frequently Asked Questions

Does Go To Special select comments in hidden rows or columns?

Yes, it selects all commented cells, including those in hidden rows or columns. If you want to exclude hidden cells, you’ll need to manually unhide them first or use a VBA approach that checks the Hidden property.

Can I select cells with comments using a formula?

No, there is no built-in worksheet function that returns whether a cell has a comment. You can use a User-Defined Function (UDF) in VBA, but that requires programming. The Go To Special method is the simplest no-code solution.

Why does Find and Replace not find comments?

Make sure you set the Look in dropdown to Comments. By default it’s set to “Formulas”, which searches cell values, not comments. Also, ensure the Match entire cell contents checkbox is unchecked if you’re searching for a partial text.

How do I select only comments that contain a specific word?

Use the Find and Replace method, type the word in Find what, and set Look in to Comments. Then Find All, select all results with Ctrl+A, and close the dialog.

Does this work in Google Sheets?

No, Google Sheets doesn’t have a direct “select all cells with comments” feature. You can use the Find and Replace (Ctrl+H) with the search in “Notes” but it only finds text within notes, not the presence of a note. A Google Apps Script would be needed for a full selection.

What’s the difference between Comments and Notes in Excel 365?

Comments are the newer threaded discussions that allow replies and are visible in a pane. Notes are the classic yellow sticky notes that appear on hover. Both are considered “comments” for Go To Special, so the selection includes both types.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.