How to Sort by Multiple Columns in Google Spreadsheets
Input your data in your spreadsheet., Decide what order you'd like to sort your information., Sort by the least important, smallest or most narrow grouping in your sort order., Sort by the next grouping in your sort order., Continue sorting by...
Step-by-Step Guide
-
Step 1: Input your data in your spreadsheet.
For the purposes of this example, assume we want to to have the people in the list grouped by city, then last name, then first name. , In this case, that would be the column with first names.
Click on "sort range" then choose if "A-Z" or "Z-A" and press "Sort"
In this case, that would be the column with last names. , -
Step 2: Decide what order you'd like to sort your information.
-
Step 3: Sort by the least important
-
Step 4: smallest or most narrow grouping in your sort order.
-
Step 5: Sort by the next grouping in your sort order.
-
Step 6: Continue sorting by increasingly larger or more important groups in your sort order until you have the list organized as you would like.
Detailed Guide
For the purposes of this example, assume we want to to have the people in the list grouped by city, then last name, then first name. , In this case, that would be the column with first names.
Click on "sort range" then choose if "A-Z" or "Z-A" and press "Sort"
In this case, that would be the column with last names. ,
About the Author
Janet Hernandez
Janet Hernandez has dedicated 5 years to mastering humanresources. As a content creator, Janet focuses on providing actionable tips and step-by-step guides.
Rate This Guide
How helpful was this guide? Click to rate: