Restore an earlier version in Google Sheets
Restore the Current amount values in B2:B4 from the earlier version snapshot in D1:E4. Do not change the item names or the snapshot.
Verified by JosephineAbout 60 secondsRestore the Current amount values in B2:B4 from the earlier version snapshot in D1:E4. Do not change the item names or the snapshot.
Step-by-step
Open the practice sheetUse the example data shown below so the result is easy to check.
Restore an earlier versionRestore the Current amount values in B2:B4 from the earlier version snapshot in D1:E4. Do not change the item names or the snapshot.
Check the resultCompare the finished sheet with the expected result and correct the target range if needed.
Shortcut or faster method
Use the menu path shown in the video and keep the target range selected until the change is applied.
Expected result
The current amounts match the earlier version: 80, 120, and 300.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Re-select B2:B4 and repeat the final action. The current amounts match the earlier version: 80, 120, and 300.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Item | Current amount | Earlier item | Earlier amount | |
| Hosting | 80 | Hosting | 80 | |
| Software | 999 | Software | 120 | |
| Design | 300 | Design | 300 |
Video transcript
- Open the prepared Practice spreadsheet.
- Open the practice sheet. Use the example data shown below so the result is easy to check.
- Restore an earlier version. Restore the Current amount values in B2:B4 from the earlier version snapshot in D1:E4. Do not change the item names or the snapshot.
- Check the result. Compare the finished sheet with the expected result and correct the target range if needed.
- The current amounts match the earlier version: 80, 120, and 300.