Revisions and history allow you to see where changes have been made in your spreadsheet. You can copy content from a previous revision and paste into any current spreadsheet, allowing you to re-use historical content.
View Spreadsheet History
To open the History panel, select the History icon from the right toolbar. You’ll see a list of revisions for your spreadsheet grouped by date, as well as any revisions you have marked as a milestone.
Creating a spreadsheet automatically creates the first revision. The name of the author is visible on the card in the History panel, as well as a small swatch with an assigned color for the author. Click a revision to see the state of the document at the time of the revision.
Click the arrow to the left of a group of revisions to see more details, like who made the edits and when.
When you hover over a revision, the entry is highlighted and you can click on the arrow on the right to access a menu of action including Create Milestone and Create Blackline.
Create and Star Milestones
If you need to mark a revision as important, you can create a milestone . Milestones automatically appear in the list of revisions when you open the History panel, even if it was originally grouped with other revisions from that date.
To create a milestone:
- Hover over a revision and click the arrow.
- Select Create Milestone from the menu.
- Enter a name for your milestone and add remarks.
- Click Create.
When you create a milestone, an empty star appears next to that revision in the History panel. You can click the star to add a yellow fill and mark that milestone as significant.
You can filter revisions in the History panel by milestones, starred revisions, time period, and author. This allows you to quickly find important revisions of your spreadsheet.
To filter your revisions:
- Click on the Show Filters icon in the top right corner of the History panel.
- To filter by milestones, check the box to Show Milestones or Show Starred. You can check both boxes to show only starred milestones.
- Use the Updated dropdown to filter by time period.
- Enter the name of an author to filter by Author.
To remove filters, choose the Reset link in the upper right-hand corner. Then click the Filter icon again to close the filter portion of the History panel.
To view a cell’s history in the History panel, select Cell History from the dropdown in the upper right corner.
From your sheet, select the cell you want to view. The History panel now shows any changes that have taken place in that cell.
When the Authorship overlay is on, you can hover over a cell in the table to see who made the last change.