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

182.9K views
February 8, 2016
by
LearnFree
YouTube video player
Excel 2016: Track Changes and Comments

TL;DR

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

Install to Summarize YouTube Videos and Get Transcripts

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.

Share This Summary 📚

Summarize YouTube Videos and Get Video Transcripts with 1-Click

Download browser extensions on:

Explore More Summaries from LearnFree 📚

Summarize YouTube Videos and Get Video Transcripts with 1-Click

Download browser extensions on: