How to use sort range option in Google Spreadsheet?
Data can be sorted within a range using the following steps.
Step 1: Select the range of cells to be sorted.
Step 2: Click Data and select "Sort range.." as shown below,
Step 1: Select the range of cells and right-click.
Step 2: Click "Sort range.."
Option 3: You can also select "Sort range" option by right-clicking the empty cell above Row 1 and before Column A.
Step 3: A popup dialog box opens up.
Step 4: In Sort by, select the column name to sort.
Step 5: Select the sorting order which is present right to the "sort by" option A-Z (ascending) or Z-A (descending) and click "Sort" option.
Step 6: Data will be sorted within the selected range based on the above given conditions.
Sort range based on header row:
Data in a range can be sorted based on the header title using the following steps.
Step 1: Use the above given steps from (Step 1- Step 3) to select sort range.
Step 2: In popup box, tick the check box "Data has header row".
Step 3: In sort by field, select the header row name to sort based on it.
Step 4: Select the sorting order A-Z (ascending) or Z-A (descending). Here, we have selected "Date" header to be sorted in A-Z order.
Step 5: Click Sort button.
Data sorted with the given conditions.
Multiple Sort Conditions:
Step 1: Follow the above steps from (Step 1-Step 3)
Step 2: Click "Add another sort column"
Step 3: Select the column name to sort with the second condition in "then by" field and choose the sort type A-Z or Z-A. Here, we have chosen Designation to sort the selected range of cells first by "Date" and then by "Designation".
Data sorted will be replaced with the selected cells.