Track Changes and Comments

In Excel track changes is a useful feature. Track changes in Excel and use the comments feature when proofreading workbooks.

Challenge!

  1. Open our practice workbook.
  2. Turn on Track Changes.
  3. Replace the value in cell D14 with Rope Bridge Activity.
  4. Change cell E15 to say Julia.
  5. Save your workbook.
  6. List changes on a new sheet. After you do this, the worksheet should look like this:
    Changes on Separate Sheet
  7. Return to the Agenda Planner tab.
  8. Add a comment to cell E16 that says snacks will be provided by the exec team.
  9. When you're finished, your workbook should look like this:
    Track Changes Challenge
  10. Accept All Changes, then turn off Track Changes.