Google Sheets keeps a history of every change that's made to a sheet. In this video, learn how to access the version history as well as restore each version.
- [Instructor] You can see previous revisions … to your Google Sheet, … whether it was made by you or somebody else … who's editing the document. … To the right of the Help menu, … you can click to open the version history. … You'll be able to see all the previous editors … of a document, with a color beside their name. … The change in the sheet will correspond … to the color of that user. … You can click on the down triangle … next to the date to expand a detailed version … of any change that was made. … Anywhere you see a time and a date, … you can click to get that particular version of the file. … You can click to restore that version … and you can click the three dots to name that version … or make a copy of the doc that contains those changes. … When you're done, click the arrow on the top left-hand side … to get back to the current version of your file. … …
- Wrapping text
- Collaborating with others on a spreadsheet
- Freezing and locking panes
- Auto-filling data quickly
- Rotating cell data
- Formatting spreadsheets
- Protecting sheets
- Inserting links
- Filtering views
- Undoing unwanted changes
Skill Level Intermediate
1. Google Sheets Quick Tips
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.