How to view, edit, and delete version history in Google Sheets

0 0
Read Time:59 Second
How to view, edit, and  delete version history in Google Sheets

Excel sheets can be accessed either through the Microsoft app (which comes built-in) or Google Sheets. The benefit of working on Google Sheets is that it allows users to edit the Excel sheet directly in the web browser without any such special software. Multiple people can work on the same spreadsheet in real-time simultaneously. Users can also see the changes made by other users. All you need is a Google Workspace account to access these features.

Why use Version History in Google Sheets?

It is possible to commit mistakes due to miscommunication or other factors when a lot of users work on the same spreadsheet. In such situations, it is important to have backups that you can refer to and return to.

1.

Navigate to Files in the Menu bar

2.

Scroll down and find the Version history

3.

Click on the small arrow beside the Version history and select See version history (You can also use the keyboard shortcut– Ctrl+Alt+Shift+H)

4.

Click on the three dots beside the name of the version

5.

To view the older version, click on Restore this version. You will be redirected to the older version of the sheet

FacebookTwitterLinkedin


Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %
Previous post Barack and Michelle Obama ink deal with Amazon’s Audible
Next post Why Did Matthew Coleman Murder His Children? Meet His Wife Abby Coleman