How to annotate an Excel spreadsheet
To annotate an Excel spreadsheet, right-click any cell and choose New Comment to add a threaded note, or New Note for a simple text pop-up. For visual callouts on charts, use Insert → Text Box. To let a client annotate without Excel installed, save to OneDrive and share a link — they can comment in Excel for the Web in any browser, no Microsoft account required if you set the link to 'Anyone can edit.'
Add a threaded comment to a cell
Right-click the cell you want to annotate and choose New Comment (not New Note — they're different in modern Excel). Type your note and press Ctrl+Enter to post. A small purple triangle appears in the top-right corner of the cell to signal a comment is there. Team members with access can reply in the same thread, and you can mark the whole thread resolved once the point is addressed. This is the right tool when you want a conversation — asking a question, flagging something for the client to answer, or threading a back-and-forth on a specific figure. Comments sync in real time when the workbook is saved to OneDrive or SharePoint.
Add a note (the old-style pop-up)
Right-click the cell and choose New Note, or press Shift+F2. Notes are the legacy annotation type — they show as a yellow pop-up sticky when you hover the cell, with a red triangle indicator in the corner. They're one-way: no replies, no threading, no resolve button. Use notes when you want a reference annotation that explains the data — for example, 'Rate pulled from Q1 contract, rev. 2024-03-01' next to a number — rather than when you need a client to respond. Most people get this wrong: they use notes hoping for a conversation and then find there's nowhere for the client to reply. For feedback loops, use threaded comments instead.
Annotate a chart or layout with a text box
Go to Insert → Text Box, draw the box on the worksheet near the element you want to call out, and type. Text boxes float above the grid, so you can place them over a chart, next to a KPI block, or pointing at a specific row with a custom arrow (Insert → Shapes → Line). Format the text box via the Shape Format tab — border color, fill, font — to make it stand out without obscuring data. This approach works best for presentation-ready spreadsheets where you're annotating for the reader, not collecting feedback from them. If you need arrows and callout shapes for a proposal or pricing breakdown, Insert → Shapes has callout presets that look cleaner than raw text boxes.
Share for client feedback — what actually works
The most common failure mode: you email the .xlsx file, the client opens it in Google Sheets (which often drops Excel comments), annotates it, and saves a .xlsx back — and now you have a version with mangled or missing notes. The reliable path for client review is to save the file to OneDrive (File → Save As → OneDrive), then share a link (File → Share → Copy Link) set to 'Anyone with the link can edit' or 'can comment.' Your client opens Excel for the Web in their browser — no Microsoft 365 license, no download, no account if you use the open-access link setting. They can add threaded comments on specific cells, and you see them in real time when you reopen the file. One caveat: the free Excel for the Web tier doesn't support every Excel feature, so complex macros or pivot tables may render as read-only.
If what you actually need is a client's reaction to a pricing table, budget breakdown, or content plan — not their edits to the underlying data — a shareable doc link works better than a live spreadsheet. Drop the spreadsheet as a doc or image into Drafty, share the link, and your client clicks the exact row or cell they mean and pins a named comment right there. No Microsoft account, no version confusion, no risk they accidentally overwrite a formula. Every note lands in one thread, anchored to the spot. You reply, resolve, and share the revised version on the same link.
Open a live demoQuestions
- What is the difference between a comment and a note in Excel?
- Comments (added via right-click → New Comment) are threaded — people can reply, @mention colleagues, and mark the thread resolved. Notes (right-click → New Note or Shift+F2) are the old-style pop-up sticky: one-way, no replies, no resolve. For client feedback, use threaded comments. For reference annotations on your own data, notes are fine.
- Can I annotate an Excel spreadsheet for free online?
- Yes. Excel for the Web (available at office.com) lets you open, annotate, and comment on Excel files in a browser at no cost. You need a Microsoft account to save, but you can view and comment on a shared link without one if the owner set it to open access.
- Can someone annotate an Excel file without Microsoft Excel installed?
- Yes, if you share it via OneDrive. The recipient opens the link in their browser — Excel for the Web handles the file entirely in the browser. Google Sheets can also open .xlsx files, but it sometimes drops Excel-native comments, so OneDrive sharing is safer for round-trip feedback.
- How do I collect annotations from multiple people on the same spreadsheet?
- Save the file to OneDrive and share a single link with all reviewers. Everyone annotates the same copy using threaded cell comments. Avoid emailing the file — each recipient saves their own version and you end up reconciling separate files. A shared link means all comments appear in one place.
- How do I show or hide comments in Excel?
- Go to the Review tab → Show Comments to toggle all comment threads visible. For notes, Review → Show All Notes. You can also right-click any annotated cell and choose Show/Hide Comment or Show/Hide Note to control individual ones.
- Why can't my client see my Excel comments?
- Three common causes: they opened the file in Google Sheets (which doesn't always import Excel comments correctly); the file was saved as .csv instead of .xlsx (comments are stripped); or they have Comment display set to 'No indicators' in their Excel settings — fix this at File → Options → Advanced → Display → For cells with comments, show.
Keep exploring
Stop emailing files back and forth.
Share one link. They comment on the exact spot — no account, always the current version.