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.
If you want to RANDOMIZE YOUR DATA Click here.
The UNDO OPTION is a life saver in the software or applications 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.
STEPS TO USE UNDO OPTION:
IF, BY MISTAKE, WE REACH THE PREVIOUS STEP OF THE ONE 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.
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.