Excel 2016: Track Changes and Comments | Summary and Q&A

TL;DR

Excel provides features like track changes and comments to facilitate collaboration and revision tracking in workbooks.

Key Insights

• 👣 Excel's track changes feature allows users to track and review modifications made by collaborators, making it easy to manage revisions.
• 👂 By utilizing the option to list changes on a separate worksheet, users can have a clearer overview of all the modifications made in a workbook.
• 🤑 Accepting or rejecting changes selectively enables users to retain the relevant modifications and discard the ones they don't want to keep.
• 💨 Comments in Excel provide a way to add notes or questions without modifying the content of a cell, aiding in collaboration and communication.
• 👻 The ability to view, edit, and delete comments allows for seamless collaboration and updating of information.
• 👣 Turning off track changes removes the markup, ensuring a clean and final version of the workbook.

Transcript

Read and summarize the transcript of this video on Glasp Reader (beta).

Questions & Answers

Q: How can I enable the track changes feature in Excel?

To enable track changes, go to the Review tab, click on "Track Changes," choose "Highlight Changes," and check the box for "Track changes while editing."

Q: How does the track changes feature help with collaboration?

The track changes feature highlights modifications made by collaborators, including the specific changes and the person who made them, making it easy to keep track of edits.

Q: How can I view all the changes made in a workbook?

You can view all the changes made in a workbook by saving your workbook, clicking on the Track Changes command, choosing "Highlight Changes," checking the option for "List the changes on a new sheet," and clicking OK.

Q: How can I accept or reject changes made in a workbook?

To accept or reject changes made in a workbook, go to Track Changes, choose "Accept or reject," review each change individually, and choose whether to accept or reject them.

Summary & Key Takeaways

• Excel offers track changes and comments features to facilitate collaboration and revision tracking in workbooks.

• Track changes highlights modifications made by collaborators and allows users to review and accept or reject them.

• Comments allow users to leave notes or questions without changing the content of a cell, and they can be easily viewed and edited.