Comment in Excel Formula

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. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. Treat “comment in excel formula” 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 calculation you can defend to a CFO or an auditor 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. One habit worth forming early: name the cells that hold your inputs, so the formula reads in plain language instead of a string of cell addresses. A reviewer — or you in three months — can then follow the logic without decoding what B7 and D2 were supposed to mean, which is most of what makes a sheet maintainable.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Here is the takeaway for “comment in excel formula”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.

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