When we work with multiple data cells in Google tables we need to keep them in order so as not to lose ourselves in all those numbers and names. Google sheets offer you several ways to range your data. When you share your sheets and other files with your colleagues you may lose your data as they can erase it. How to sort data in Google Sheets and how to backup Google Drive, that’s what we will review in this article.
Select the cells that you want to sort out, click the right button and select the “Sort range” option.
In the pop-up window if you want to leave the top cell untouched and set it as a header row check the “Data has header row” option:
Click “Sort” and enjoy the result:
Another way to sort data is to switch on the filter icon at the instruments panel.
After you turn it on in the header of the table arrows for additional filter conditions will appear:
Click on that arrow and set up any conditions you need. You can filter by specific words contained in the cells, or by data, or by numbers. The nice thing about it is that you can narrow the search and see all the cell that would meet your conditions.
You can create several types of filters and then switch back to the usual mode. And you will always be able to get back to them with one click of a mouse:
This function works in a similar way to the first one described above. It only allows you to sort the whole table column instead of a selected range.
Click on the arrow in the header of the table and choose “Sort A-Z” option:
How to backup Google Drive
As I have mentioned in the beginning of this article, when you share your Google sheets with others they may delete your files.
To enhance your corporate Google Drive security use third-party allications like Upsafe to backup Google Drive. You will always have a reserve copy of your files in another cloud and be able to restore them at any time.