Track Changes allows document owners to view any additions, changes, or removals made by collaborators. Owners can approve or reject changes for a streamlined workflow and review process.
Enable Tracked Changes
Track Changes allows you to follow changes to a spreadsheet by showing how the document has changed. If you or another document owner would like to view changes made to your spreadsheet, you can enable Track Changes.
Note: Only Document Owners can enable Track Changes.
To enable Track Changes:
- Navigate to the Review toolbar.
- Toggle Track Changes on.
View Tracked Changes
After you enable track changes, you’ll see changes marked accordingly.
- Removals are marked with a red indicator.
- Changes (locations where text has been both added and removed) are noted with a purple indicator.
- Additions are in blue with an underline and a blue teardrop indicator.
You can jump between changes by clicking the Previous or Next buttons in the Review toolbar, or by opening Track Changes in the right panel.
In the Track Changes panel, you can see a list of all tracked changes in your current sheet and preview those changes in the document. Clicking a change in the panel highlights the change in the spreadsheet.
Note: Changes to the outline, links, text formatting, and deleted rows/columns are not tracked.
If you’d like to see your spreadsheet with changes accepted, you can hide the change markers using the Hide Changes option in the Review toolbar. You can view the changes again by clicking Show Changes.
A blue highlight bar to the left of a sheet in the Document Outline indicates that sheet contains tracked changes.
Accept or Reject Individual Changes
Document owners can accept or reject individual tracked changes.
To accept or reject an individual change:
- Open the Track Changes panel.
- Select a change.
- Click the Approve or Reject buttons.
You can also accept or reject changes by right-clicking a change in the document and choosing Approve or Reject from the menu. Once accepted or rejected, the change indicators disappear.
Accept or Reject All Changes
You can accept or reject changes at the section or document level via the Approval icon in the toolbar. When you accept or reject tracked changes en mass, you can’t undo this action.
Exporting documents with track changes to .XLSX or .CSV display as if all track changes are accepted. This does not accept all changes in your document.