How To Sort Multiple Columns In Google Sheets

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:

Quick Sort

If you just need to sort a range of columns by a single column in the range, use the quick sort method:

Step 1

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

Step 2

Open the Data menu and hover over Sort Range, then choose from the options to sort A to Z or Z to A

Step 3

The selected columns will be sorted, but other columns in the sheet will remain unsorted

Advanced Sorting

If you need to get more control over how the columns are sorted, use the advanced sorting method:

Step 1

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

Step 2

Open the Data menu, hover over Sort Range, and choose Advanced Range Sorting Options

Step 3

In the dialog that appears, check the box for Data Has Header Row if the selection includes a header row

Step 4

Select the first column to sort by from the dropdown and choose sort order for that column

Step 5

Add sort columns as needed by clicking Add another Sort Column and repeat Step 4 for each

Step 6

Click Sort when you’re done and the selected columns will be sorted

Summary

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.