Inserting Comment in Excel

If you just need to inserting comment in excel and move on, the boxed answer at the top is all you need. The rest of this page is for when you want to understand why it works in Excel, adapt it to a trickier version, or make it robust enough to hand to a colleague. We keep the opening short on purpose — the depth is here when you want it, not in your way when you don’t.

Exact answer

In Excel: right-click a cell and choose New Comment for a threaded discussion comment, or Review ▸ Notes ▸ New Note for a classic yellow sticky note — Shift+F2 inserts one on the active cell, and a small marker triangle appears in the corner.

Annotated stepsExcel
1

Click the cell you want to annotate.

2

For a discussion, right-click ▸ New Comment (or Review ▸ New Comment); type your text and click away to post.

3

For a plain sticky note, use Review ▸ Notes ▸ New Note, or press Shift+F2.

4

Hover the cell to read the annotation; click the marker triangle to reply to a comment.

5

Use Review ▸ Show Comments to read every comment in the side pane.

Ctrl+CthenCtrl+Shift+V+Cthen+Ctrl+VPaste values · WindowsMac

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. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “inserting comment in excel”. Start on a copy or a tiny sample, keep the affected comments visible, and compare the result with the tool above before you touch the real workbook. 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. The point is a layout choice that keeps the sheet readable and sortable, but the practical win is that someone else can open the file and understand what happened without asking you.

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. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.

In Google Sheets

Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. The short version of “inserting comment in excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.

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

What is the difference between a comment and a note?

A comment is a threaded discussion with replies and an author; a note is a plain yellow sticky annotation. Review ▸ New Comment makes the first, Review ▸ Notes ▸ New Note makes the second.

What is the keyboard shortcut to insert one?

Shift+F2 adds a comment or note to the active cell. In Google Sheets it is Ctrl+Alt+M.

How do I show all comments at once?

Review ▸ Show Comments opens the side pane listing every threaded comment in the sheet.

How do I print the comments?

Open Page Setup ▸ Sheet, set the Comments box to "At end of sheet" or "As displayed on sheet", then print.