Microsoft Excel · Sharing, output and safety · Beginner

Comments, Sharing & Collaboration in Microsoft Excel

Share a cloud workbook and coauthor safely; Review threaded comments and change history in Excel with a complete practice example, expected results and recovery checks.

Official documentation reviewed; example logic independently checked; native Excel execution not performed · Editorial standards

Quick answer: Use a threaded Comment for a discussion and a Note for a static annotation. Co-authoring additionally requires a shared cloud workbook and suitable access; writing a comment does not itself grant permission to the file.

Version and platform: Microsoft 365 Excel for Windows desktop; Mac, Excel for the web and Excel 2013 interfaces not covered. Use a disposable workbook for the exercise.

Scope and practice workbook

This walkthrough uses Microsoft 365 Excel for Windows. It does not describe Excel 2013’s old comments or legacy Shared Workbook controls. Start with a synthetic workbook containing Item and Amount in A1:B1, then Draft estimate and 120 in A2:B2. Save an XLSX practice copy. No private business data or real invitation is needed for the local annotation exercise.

If your organization restricts comments, cloud storage or sharing, follow that policy rather than trying an alternate account. The collaboration portion below is an optional workflow for an owner who already has an approved OneDrive location and an authorized test collaborator; it is not needed to verify local notes.

Add the right kind of annotation

Select B2, right-click and choose New Comment (also available on Review).
Enter “Does this include delivery?” and post it. Microsoft documents Ctrl+Enter as the posting shortcut for a comment.
Inspect the thread’s Reply box. Use it to add “Delivery is separate” in the practice file, rather than creating another unrelated annotation.
Select A2, right-click and choose New Note. Type “Synthetic example; not a purchase request.” Click away or press Esc to leave the note.
Use Review → Show Comments to inspect the comment pane, then Review → Notes → Show All Notes to inspect notes. The note should not have a Reply box.

The expected result is one discussion attached to B2 and one static annotation attached to A2. Neither should replace the cell value. B2 must remain 120, and A2 must still read Draft estimate. Avoid putting secrets in annotations: they are part of the workbook, not a private conversation hidden from other editors.

Optional authorized co-authoring check

For a workbook that is explicitly approved to share, select Share. If it is not already on OneDrive, Excel offers an upload step. Before proceeding, verify the intended location and exact recipients. Set permissions and select Apply; Microsoft’s quick-start notes that Allow editing is selected by default, so review it rather than accepting it accidentally. Add the approved person’s name and an optional message, then select Send only when you intend to invite them.

Ask the authorized collaborator to open the same cloud file, not a downloaded copy. The initials at the upper right identify other participants and their locations. A participant changing B2 from 120 to 135 gives you a concrete synchronization check: both views should show 135. A comment saying “updated” is not evidence that the numeric cell changed.

Review actual change history

In the approved cloud practice workbook after the 120-to-135 edit, choose Review → Show Changes. Find the B2 entry and inspect who changed it, where, when, and its previous/current values. Select B2, right-click and choose Show Changes to narrow the view to that cell. If the pane was already open, select See New Changes to refresh it.

For a second check, change B2 from 135 to 140 in the same supported co-authoring workbook. Refresh the pane and confirm the newer entry appears above the earlier edit. The final cell value should be 140. A comment thread about B2 is not a substitute for this cell-edit history.

Show Changes is not a complete audit of every workbook action: chart edits, PivotTable operations, formatting, hiding and filtering are not shown. Older or one-time-purchase Excel editors can clear or leave gaps in the pane, and saving/uploading a replacement copy can also clear it. Require supported co-authoring apps for this exercise. If an expected entry is missing, check these limitations rather than asserting no edit happened. For older saved versions, Microsoft’s help points to File → Info → Version History; preview only, without restoring over current work.

Finish and troubleshoot

If you skipped the optional cloud exercise, set B2 to 135 yourself for a local changed-input test and confirm the original comment remains a discussion about that cell; it does not recalculate or certify the new amount. Save, reopen under the same signed-in profile, and inspect both annotations. Microsoft notes that local comment editing depends on that profile.

If you see an old-style box without replies, check whether you created a Note. If another person’s original comment has no Edit button, reply instead. Once a discussion is finished, mark it Resolved; it remains viewable and can be reopened by someone with write access. If live changes do not appear, check that both people opened the same approved OneDrive workbook with appropriate access, rather than changing permissions blindly. This tutorial does not claim an actual invitation or multi-user session was performed.

Official references

Documentation snapshots retrieved 20 October 2026. These instructions and example checks are documentation-based; no native Excel run or application screenshot is claimed.