Sorting is putting up a number of things in a particular fashion as per the selected criteria. Sorting in GOOGLE SHEETS is one of the very basic and frequently used operation.
SORTING IN GOOGLE SHEETS IS THE PROCESS OF ARRANGING THE TEXT OR VALUES SYSTEMATICALLY AS PER THE SELECTED CRITERIA.
The UNDO OPTION is a life saver in the softwares as well as in GOOGLE SHEETS if we performed any action which didn’t result in the outcome as per expectation.
This happens many times while working.
In the case of sorting, it can happen when we need to remove all the steps and get the original data. For that, we can use UNDO OPTION.
The button location for UNDO OPTION is shown in the picture below.
IF, BY MISTAKE, WE GO BEFORE THE STEP , WHERE WE INTENDED TO STOP, WE CAN USE CTRL+Y , OR THE BUTTON NEXT TO UNDO WHICH IS KNOWN AS REDO, TO GO TO THE NEXT STEP.
This step is to be used before we start any kind of SORTING OPERATION on our data.
Let us take a sample data to learn the steps.
The data shown above is the original sequence of the data.
If we want to preserve it, or if we doubt that a situation may occur when we need to recover this data or bring the original data, follow the steps.
Let us sort the table with respect to the Days, followed by the increasing sales.
YOU CAN LEARN SORTING IN GOOGLE SHEETS HERE.
After the sorting, our data will be something like this.
In the above picture, we applied the sorting on the first column, followed by the decreasing order of sales.
[ Kindly don’t confuse the decreasing sales, as it is sub sorting under the day column, if two or more days are same, it’ll sort the sales in descending order.
TO UNSORT THE DATA
Simply sort the data in the ASCENDING ORDER by the helper column.
It’ll bring back the original sequence of the items as required.
Follow the steps to sort the data as per helper column.
Select the Table.
Go to DATA> SORT RANGE
The above shown dialog box will open.
Check DATA HAS HEADER NOW, if you have selected the Headers also for the sorting.
Now the COLUMN HEADER NAMES will replace the SORT BY DROP DOWN options as the column header names.
Choose SORT BY – HELPER COLUMN and A –> Z to get the ascending order.
The original position of the data will result.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE