How to Add a Note to a Cell in Excel (And When to Use Comments vs. Notes)

Excel gives you two distinct ways to attach extra information to a cell: notes and comments. They look similar on the surface, but they behave differently — and knowing which one you're working with changes how you add, view, and manage them.

This guide focuses on notes specifically, with enough context on comments that you won't confuse the two.

What Is a Cell Note in Excel?

A note in Excel is a static text annotation attached to a cell. It's the feature that used to be called a "comment" in older versions of Excel (pre-2019 and pre-Microsoft 365). When you hover over a cell that has a note, a small yellow box appears with the text you wrote.

Notes are one-directional — they don't support replies or threading. Think of them as sticky notes attached to a spreadsheet cell. They're useful for:

  • Labeling the source of a data point
  • Reminding yourself (or a colleague) what a formula does
  • Flagging a value that needs to be reviewed
  • Adding context that doesn't belong in the cell itself

A small red triangle appears in the upper-right corner of a cell to signal that a note is attached.

How to Add a Note to a Cell in Excel 📝

Method 1: Using the Right-Click Menu

  1. Click the cell where you want to add a note.
  2. Right-click to open the context menu.
  3. Select "New Note" (in Microsoft 365 or Excel 2019+) or "Insert Comment" (in Excel 2016 and earlier, where the feature was still called a comment).
  4. A text box appears with your username pre-filled. You can delete that and type your note directly.
  5. Click anywhere outside the text box to close it.

Method 2: Using the Review Tab

  1. Select your target cell.
  2. Go to the Review tab in the ribbon.
  3. Click "Notes" in the Notes group (Microsoft 365) or "New Comment" in older versions.
  4. Type your note and click outside to save.

Method 3: Keyboard Shortcut

  • On Windows: Press Shift + F2 to insert or edit a note instantly.
  • On Mac: Press Fn + Shift + F2, or just Shift + F2 depending on your keyboard settings.

This is the fastest method if you're working through multiple cells and adding notes as you go.

Notes vs. Comments: What's the Difference?

FeatureNotesComments
Threading / replies❌ No✅ Yes
Appears on hover✅ Yes✅ Yes
Indicator colorRed trianglePurple triangle
Best forStatic annotationsTeam collaboration
Available inAll modern Excel versionsMicrosoft 365, Excel 2019+

If you're working in Microsoft 365, the "New Comment" option creates a threaded comment (with reply functionality), while "New Note" creates the classic static annotation. In Excel 2016 and earlier, there's only one annotation type — it's called a comment, but it behaves like what modern Excel calls a note.

This distinction matters if you're sharing files with colleagues using different Excel versions.

How to View, Edit, and Delete Notes

Viewing notes: By default, notes are hidden until you hover over the cell. To make a note always visible, right-click the cell and choose "Show/Hide Note". To show all notes at once, go to Review → Notes → Show All Notes.

Editing a note: Right-click the cell and select "Edit Note", or select the cell and press Shift + F2. The text box becomes active and editable.

Deleting a note: Right-click the cell and choose "Delete Note". Alternatively, select the cell, go to Review → Notes → Delete. Deleting a note does not affect the cell's content or formatting.

Moving between notes: Under the Review → Notes menu, you can navigate forward and backward through all notes in a worksheet using the Previous and Next options.

Formatting Notes

The default note style is plain yellow with small black text, but you can customize it:

  1. Right-click the note's border (not the text area, but the actual edge of the box).
  2. Select "Format Comment" or "Format Note".
  3. Adjust font, size, color, fill, and border style.

Note that heavy formatting can make files harder to maintain and may not carry over predictably when the file is opened in Google Sheets or other spreadsheet tools.

A Few Things Worth Knowing About Notes

Printing notes: Excel doesn't print notes by default. To include them, go to Page Layout → Page Setup → Sheet tab and change the Comments and Notes dropdown from "None" to your preferred display option.

Notes in Excel Online: The web version of Excel has more limited note support. You can view notes, but editing and adding them may depend on your Microsoft 365 plan and browser.

Compatibility: Notes created in modern Excel remain visible when the file is opened in Google Sheets, though the behavior and appearance may differ slightly. If cross-platform consistency matters for your workflow, it's worth testing how your specific notes render.

The Variables That Determine How This Works for You

How notes behave in practice depends on a few factors that vary by user:

  • Your Excel version — the labeling and menu structure differs between Excel 2016, 2019, and Microsoft 365
  • Your operating system — keyboard shortcuts and some menu options differ between Windows and Mac
  • Whether you're collaborating — if others are working in the same file, you may need comments (threaded) rather than notes
  • Your file format — .xlsx handles notes well; older .xls files and cross-platform workflows introduce edge cases

The mechanics of adding a note are straightforward once you know where to look — but whether a static note is the right tool, or whether threaded comments or an entirely different annotation approach fits your situation better, depends on how the spreadsheet is being used and who else is involved.