Productivity & Extras · ~2 min read

Excel Collaboration: Share, Comments and Notes

Share workbooks, co-author and use comments and notes.

Video link coming soon
What you will learn

Step by step

1. Notes and comments

A number looks wrong, and you want to tell the owner without changing it. Excel gives you two tools for that: notes and comments.

You will add a note, read and edit it, show every note at once, and learn when a comment is the better choice.

Excel Collaboration: Share, Comments and Notes: Notes and comments
Notes and comments

2. Add a note

Click C4, the travel budget, and press Shift and F2. A yellow note box opens, signed with your name.

Type: This looks too high, please check the hotel costs. Then press Escape twice to leave the note.

Excel Collaboration: Share, Comments and Notes: Add a note
Add a note

3. Read and edit

C4 now has a small red triangle in its corner. Move the mouse over it, and the note appears.

To change it, select the cell and press Shift and F2 again. Add: Thanks.

Add a second note on C6: Is this the final number? Shift F2, type, Escape twice.

Quick pause: if your team leaves notes in files, a like really helps the channel. Now, how to see them all.

Excel Collaboration: Share, Comments and Notes: Read and edit
Read and edit

4. Show all notes

Review, Notes, Show All Notes: Alt, R, T, N, S. Every note stays open, so you can read them in one pass. The same keys hide them again.

When the question is answered, delete the note: select C6 and press Alt, R, D.

Excel Collaboration: Share, Comments and Notes: Show all notes
Show all notes

5. Comments and sharing

Comments are the other tool. A comment is a conversation: people reply in a thread, and when you mention a colleague with the at sign, they get an email.

To work on the same file at the same time, save it to OneDrive and use the Share button at the top right. Everyone edits one copy, no more versions by email.

Excel Collaboration: Share, Comments and Notes: Comments and sharing
Comments and sharing

6. The silent note trap

Here is the trap. A note is silent. Nobody is told it exists. A question in a note can sit there for weeks.

So use notes for labels and explanations that stay, and comments with a mention for questions that need an answer.

Excel Collaboration: Share, Comments and Notes: The silent note trap
The silent note trap

7. Recap

Recap: Shift F2 adds or edits a note, Alt R T N S shows them all, Alt R D deletes one, and comments with a mention start a conversation.

In the next lesson, you will clean messy data automatically with Power Query.

Does your team use notes, comments, or email for questions about a file? Tell me in the comments.

Excel Collaboration: Share, Comments and Notes: Recap
Recap
What do you want to learn next? Tell us in the comments on YouTube: your requests decide the next tutorials.

← Previous tutorial: Protect Excel Sheets and Workbooks (Passwords and Locking)
Next tutorial: Power Query Intro in Excel (Clean and Combine Data) →