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.…
- Identify which option allows you to download all of your Google files at once.
- Explain what happens when you double-click the border on the right side of a column.
- List the formula that will copy the contents of one cell into the current cell.
- Identify the location where an excel file needs to be stored to work on it simultaneously with another user.