Adding a note to a cell takes seconds and keeps your reasoning visible

A note in a spreadsheet is a small comment attached to a single cell that stays hidden until someone clicks on it. Most spreadsheet programs — Google Sheets, Microsoft Excel, LibreOffice Calc — let you add notes the same way: right-click the cell, choose "Insert note" or "Add comment", type what you need to remember, then click outside the cell. A tiny indicator (usually a small triangle or dot in the corner) shows that a note exists there. When you or someone else opens the file later, hovering over or clicking that indicator reveals what you wrote.

Notes are useful when a number or entry needs context that won't fit in the cell itself. You might note why you chose a particular figure, flag a cell that needs updating, or explain a formula to someone else reading the sheet. Unlike the cell content itself, notes don't affect calculations or sorting — they're purely informational.

Key Takeaways

  • Right-click any cell, select "Insert note" (Google Sheets) or "New comment" (Excel), type your message, and click outside the cell to save it.
  • A small indicator appears in the cell corner to show a note exists; hover over or click it to read the note without opening an edit window.
  • Notes are visible only to people who open the file and interact with that specific cell — they don't print or appear in the main spreadsheet view.
  • You can edit or delete a note by right-clicking the cell again and choosing the appropriate option from the menu.
  • Notes work the same way across Google Sheets, Excel, and LibreOffice, though the menu labels differ slightly between programs.

How to add a note in Google Sheets

Open your spreadsheet and click the cell where you want to add a note. Right-click (or on a Mac, Control-click) that cell. A menu appears with several options. Select "Insert note" near the top of the menu. A small text box opens to the right of the cell where you can type. Write whatever you need — an explanation, a reminder, a source, or a flag for later review. When you're done typing, click anywhere outside the note box or press Escape. The note closes, and a small orange triangle appears in the top-right corner of the cell.

To read the note later, hover your cursor over that orange triangle. The note text appears in a small popup. If you want to edit the note, right-click the cell again and select "Edit note". To remove it entirely, right-click and choose "Delete note". You can also mention someone in a note by typing @ followed by their email address, which sends them a notification that they've been tagged.

How to add a note in Microsoft Excel

Click the cell you want to annotate. Right-click and select "Insert Comment" (in newer versions of Excel) or "New Comment" (in older versions). A colored box opens next to the cell with your username already filled in. Delete the username if you prefer, then type your note. Click outside the comment box when you're finished. A small red triangle appears in the top-right corner of the cell to indicate a comment exists.

Hover over the red triangle to see the comment without opening it for editing. To change the comment, right-click the cell and select "Edit Comment". To remove it, right-click and choose "Delete Comment". In Excel, comments allow some basic formatting like bold and italics, which can help you emphasize important parts of your note. In Excel, comments are sometimes called "notes" and sometimes "comments" depending on your version — they function identically.

How to add a note in LibreOffice Calc

Click the cell where you want to add a note. Right-click and select "Insert Comment" from the menu. A yellow box appears next to the cell. Type your note text. Click outside the box to save it. A small red square appears in the top-right corner of the cell. Hover over that square to read the note, or right-click the cell and select "Edit Comment" to change it. To delete a note, right-click the cell and choose "Delete Comment".

LibreOffice comments also support basic text formatting like bold and italics. When you add a comment, your username appears automatically at the top, and you can delete it if you prefer. Comments in LibreOffice stay attached to their cells when you sort, copy, or move data, just as they do in other spreadsheet programs.

What notes can and cannot do

Notes are purely informational — they don't change how your spreadsheet calculates or sorts. If you sort a column, the notes stay attached to their original cells and move along with them. If you copy a cell with a note, the note copies too. If you delete a cell, the note deletes with it.

Notes don't print when you print the spreadsheet unless you specifically change the print settings to include them. In Google Sheets, you can choose to print notes by going to File > Print, then clicking "More settings" and selecting "Comments" under the "Sheets" section. In Excel, go to File > Print, click "Print Options", and check "Print comments and notes". In LibreOffice, go to File > Print, click "Options", and select "Comments" under "Other options". Most of the time, you'll leave notes off the printed version.

When to use notes instead of putting text in a cell

Use a note when the information is explanatory rather than data. If a cell contains a number and you want to explain where it came from or why it might change, a note keeps the cell clean and the number visible. If you're flagging something for yourself or a colleague to revisit, a note is less disruptive than adding a separate column of flags. If you're documenting a formula or a decision, a note preserves that reasoning without cluttering the sheet.

Don't use a note for information that needs to be visible at a glance or that affects how someone reads the data. If a column header needs explanation, put that in the cell or in a separate header row — don't hide it in a note. If a number is conditional or has special meaning, consider adding that context in an adjacent column or in a separate legend on the sheet.

Sharing spreadsheets with notes

When you share a spreadsheet with others, your notes come along. In Google Sheets, anyone with access to the file can see your notes and add their own. You can mention someone in a note by typing @ followed by their email address, which sends them a notification. In Excel and LibreOffice, notes are visible to anyone who opens the file, but they don't generate notifications unless you set up a separate alert system.

If you're collaborating on a spreadsheet and want to have a back-and-forth conversation about a specific cell, notes work well for that — each person can add a note or edit the existing one. If you want to keep notes private, remember that anyone with edit access to the spreadsheet can read them. For truly confidential information, use a separate document or communication channel.

Frequently Asked Questions

Can I format text inside a note?

Google Sheets notes don't support bold, italics, or other formatting — they're plain text only. Excel and LibreOffice comments allow some basic formatting like bold and italics. If you need rich formatting, consider using a separate document linked from the spreadsheet instead.

What happens to notes when I share the file with someone who uses a different program?

Notes usually transfer between programs, but formatting and appearance may change slightly. A note created in Excel will be readable in Google Sheets, but the display style differs. Test with a small file first if you're moving spreadsheets between programs regularly.

Can I search for text inside notes?

Google Sheets has a search function that can find text in notes — use Ctrl+F (or Cmd+F on Mac) and check the "Include notes" option. Excel and LibreOffice don't have built-in search for note content, so you'll need to manually check cells if you're looking for a specific note.

Is there a limit to how many notes I can add?

No. You can add as many notes as you need, one per cell. Very large numbers of notes may slow down file performance slightly, but for typical use this isn't a concern.

Can I see all the notes in my spreadsheet at once?

Google Sheets doesn't have a built-in way to view all notes in one place. Excel has a "Show All Comments" option under the Review tab that displays every comment at once. LibreOffice has a similar feature under Tools > Track Changes > Show. Otherwise, you'll need to click through cells individually.