In this video, staff author Jess Stratton shows users how to use Activity revision control, how to turn on Track Changes, and how to add a comment in an Excel spreadsheet.
- [Instructor] If your file has been saved to One Drive…Excel will log the activity of the workbook for you.…If it's on One Drive you'll notice a new icon…to the right of the Share button.…It's an activity log…and clicking on it will bring back…all the revisions of the document.…You can click on a particular version…it's going to open as Read Only.…If you want to make this version the latest version…click the Restore button in the middle of the screen.…Otherwise you can close out of your sheet.…Don't save the changes.…Then you'll be brought right back to the one…that you were previously looking at.…
You can click the X to close out of the activity log.…You can also turn on Change Tracking.…In Excel, change to the Review ribbon tab.…Click Track Changes…and then choose Highlight Changes.…You can turn on Track Changes while editing…if it's not already turned on.…You can then choose which changes you want saved.…Since you last saved the document…you can even highlight changes made…by just a particular person.…And also, where the changes have been made in the sheet.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Converting Google Sheets to Excel format
- Working anywhere with Excel Online
- Working with sheets
- Creating an Excel table
- Applying conditional formatting
- Working with formulas
- Working with charts and sparklines
- Sharing files and collaborating with others
- Reviewing and tracking changes