For sharing a spreadsheet with complex formulas
Instead of writing a separate document to explain a complex formula or dataset, you can leave a comment directly on the cell, so anyone you share the file with immediately understands your intent.
Comments are not the same as the older Notes feature
Modern Excel actually has two separate features that look similar: threaded Comments, which support back-and-forth replies for real collaboration, and the older, simpler Notes, which are plain text with no reply option -- worth knowing which one you're actually using.
Frequently Asked Questions
Are Comments the same as the older Notes feature?
Comments support replies and real-time collaboration in a threaded format, while Notes are the older, simpler feature that only holds plain text with no reply option.
How can I tell which cells have a comment?
A cell with a comment shows a small colored indicator in its top-right corner, so you can spot it at a glance.