In this tutorial, you will learn how to sort in google sheets.
If your data is out of order in Google Sheets, it can be difficult to find the information you’re looking for and compare values. Fortunately, Google Sheets makes it easy to sort data in just a few clicks. Read on to learn how.
Quick Sorting A Range
Quick Navigation
If you want to sort a range by a single column, you can typically use the quick sorting menu option which takes only a few clicks to use:
Step 1
Select the range you want to sort, then open the Data menu and hover over the Sort Range submenu and choose between the A-Z and Z-A sort order options
Step 2
Your data will be sorted. Note that the column you select first is the column Google Sheets will use to sort by, so if you want to sort columns A and B by column B, start by selecting column B and then hold down shift and select column A
Step 3
Note also that if you have frozen rows at the top of the sheet, they will be treated as headers and not sorted
Quick Sorting the Entire Sheet
Quick sorting the entire sheet works much the same as quick sorting a range:
Step 1
Instead of selecting the range to sort, select the column you wish to sort by
Step 2
Then open the Data menu and simply hover over the Sort Sheet submenu instead of the Sort Range submenu and choose a sort order
Advanced Sorting
If you need to sort by more than one column or get more control over the sorting, you can use advanced sorting.
Here’s how:
Step 1
Select the range you want to sort by. Open the Data menu, hover over Sort Range and choose Advanced Range Sorting Options
Step 2
If your data contains headers, check the box labeled Data Has a Header Row
Step 3
Choose the first column to sort by from the dropdown and select the desired sort order
Step 4
If you would like to sort by additional columns, click the Add Another Sort Column button and repeat Step 3 for this column
Step 5
Click the green Sort button and your data will be sorted
Summary
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to sort in google sheets. Want more? Check out all the Google Sheets Tutorials.