In this tutorial, you will learn how to sort multiple columns in google sheets.
Sorting is one of the most basic tools of data manipulation that has been around for a long time, so it’s no wonder Google Sheets provides a number of different ways to sort data within a spreadsheet. You can sort an entire sheet, a single column, or even a set of columns within a sheet. This tutorial will show you how to sort certain columns of data in your spreadsheet without sorting all the data in the sheet. Here’s how:
If you just need to sort a range of columns by a single column in the range, use the quick sort method:
Select the columns you want to sort, making sure to select the column you’d like to sort by first. If your data includes headers, be sure the header row is frozen or else it may be moved by the sort. Note also that if the column to sort by is not on the edge of the range, you will need to use the advance sorting method in the next section
Open the Data menu and hover over Sort Range, then choose from the options to sort A to Z or Z to A
The selected columns will be sorted, but other columns in the sheet will remain unsorted
If you need to get more control over how the columns are sorted, use the advanced sorting method:
Select the columns you wish to sort. This time it doesn’t matter if headers are frozen or what order you select the columns in
Open the Data menu, hover over Sort Range, and choose Advanced Range Sorting Options
In the dialog that appears, check the box for Data Has Header Row if the selection includes a header row
Select the first column to sort by from the dropdown and choose sort order for that column
Add sort columns as needed by clicking Add another Sort Column and repeat Step 4 for each
Click Sort when you’re done and the selected columns will be sorted
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to sort multiple columns in google sheets. Want more? Check out all the Google Sheets Tutorials.