The 3 Easiest Ways to Sort by Number in Google Sheets

Download Article

Easy ways to sort a Google Sheets spreadsheet by number

Download Article

• Sorting by Range
|
• Sorting with a Filter
|
• Sorting with a Formula
|
• Video
|
• Tips

|Show more|Show less

This How.com.vn teaches you how to rearrange all the cells in a column numerically on any computer. You can quickly sort by number using the Sort Range feature in the Data tab, by creating a filter, or by creating a formula with the SORT function.

Things You Should Know

• To sort by number in Google Sheets, start by freezing your header row and making sure your numbers are saved as numbers (not text).
• Select the column you want to sort, then go to "Data" > "Sort range" > "Advanced range sorting options".
• Select "Data has header row," select ascending or descending order, and then click "Sort."

Steps

Method 1

Method 1 of 3:

Sorting by Range

Download Article

1. 
   1
   Freeze your header row (if you haven't already). If there's a header above the numbers you want to sort, you'll want to freeze the row before sorting. To freeze the header row:

   • Click the row number on the left side of the sheet.
   • Right-click the highlighted row.
   • Select View more row actions > Freeze 1 row.
2. 
   2
   Make sure your numbers are stored as numbers (not text). Here's how:

   • Select the numerical cells you want to sort (not including the header row—just the cells with numbers).
   • Click the Format menu at the top.
   • Select the Number menu.
   • Select a number option that best describes your data. For example, use Number for regular numbers or Currency for prices.
   Advertisement
3. 
   3
   Highlight the cells you want to sort. You can click the column letter above the numbers to select the entire column.
4. 
   4
   Click the Data tab at the top of Google Sheets. It will open a drop-down menu.
5. 
   5
   Click Sort range on the Data menu. This option will allow you to customize your sorting settings.
6. 
   6
   Select Advanced range sorting options. It's at the bottom of the menu.
7. 
   7
   Check the box next to "Data has header row." This ensures your header row won't get mixed up in the numbers when you sort.
8. 
   8
   Select a sorting order. Select A to Z to sort numbers in ascending order (lowest number at the top), or Z to A to sort in descending order.

   • Even though you're seeing "A to Z" and "Z to A," sorting with this method also works on numbers (not just letters). A is equivalent to your lowest number, and Z is the highest number.
9. 
   9
   Click Sort. Your numbers are now in the selected order.
Advertisement

Method 2

Method 2 of 3:

Sorting with a Filter

Download Article

1. 
   1
   Make sure there's a header above your numbers. To sort numbers with a filter, the cell above your number list must be a header cell.

   • For example, if you're sorting a list of prices, you may want to make the header "Prices" for that column.
2. 
   2
   Make sure your numbers are stored as numbers (not text). Here's how:

   • Select the numerical cells you want to sort (not including the header row—just the cells with numbers).
   • Click the Format menu at the top.
   • Select the Number menu.
   • Select a number option that best describes your data. For example, use Number for regular numbers or Currency for prices.
3. 
   3
   Select the column you want to sort. Click the letter above the column to select all the numbers and the header row at once.
4. 
   4
   Click the Data tab and select Create a filter. This adds a small funnel icon to the header cell, which indicates that you can now easily sort the column.
5. 
   5
   Click the filter icon and select a sorting option. Select A to Z to sort numbers in ascending order (lowest number at the top), or Z to A to sort in descending order. Once you make your selection, the numbers in the column will sort in ascending or descending order.

   • Even though you see "A to Z" and "Z to A," sorting with this method also works on numbers. A is equivalent to your lowest number, and Z is the highest number.
Advertisement

Method 3

Method 3 of 3:

Sorting with a Formula

Download Article

1. 
   1
   Store your numbers in a numerical format. If the numbers you want to sort are stored as plain text in Google Sheets, they won't sort correctly. Here's what you'll need to do:

   • Select the numerical cells you want to sort (not the header row—just the cells with numbers).
   • Click the Format menu at the top.
   • Select the Number menu.
   • Select a number option that best describes your data. For example, use Number for regular numbers or Currency for prices.
2. 
   2
   Create a formula with the SORT function. The syntax is =SORT(RANGE:RANGE, sort_column, TRUE/FALSE.

   • Replace RANGE:RANGE with the range you want to sort, e.g., E2:E40.
   • sort_column is the number of the column you want to sort by, based on how many columns you selected. If you're only sorting one column, the value is 1. If you're sorting multiple columns based on the numbers in the second selected column, you'd enter 2.
   • To sort in ascending order, with the lowest number at the top, use TRUE. For descending order, use FALSE.
   • For example, to sort only column E (in this case, cells E2: E40) in numerical order, you'd use =SORT(E2:E40, 1, TRUE).
   • To sort the data in column D as well, based on E2:E40, you'd use =SORT(E2:E40, D2:D40, 2, TRUE).
Advertisement

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Video

Tips

• You can also use the SORT function in Microsoft Excel. The only difference is that instead of using TRUE or FALSE, you'll use 1 to sort in ascending order and -1 to sort in descending order.
  Thanks

  Helpful0Not Helpful0

Submit a Tip

All tip submissions are carefully reviewed before being published

Submit

Thanks for submitting a tip for review!

Advertisement