Last Updated on January 2, 2024 by Jake Sheridan
There are many different ways to sort data in Google Sheets. You can sort your data by alphabetical order, by numerical value, by date, and more.
In this guide, we will show you how to sort a range by a number. This can be helpful if you want to put your data in numerical order, from smallest to largest, or vice versa.
We will also show you how to sort by multiple columns, in case you have a more complex dataset.
How To Arrange Cells By Numerical Value in Google Sheets
- How To Arrange Cells By Numerical Value in Google Sheets
Here’s how to arrange cells by numerical value in Google Sheets.
Step 1) Select the cell range to sort numerically
First, select the range you want to sort by number.
In this example, we want to arrange the IDs in the cell range A2:A15 in ascending order.
Step 2) Access the sorting options
Next, click on the options Data > Sort range > Sort range by column A (A to Z).
Step 3) Confirm the ascending order sort
The selected range should now be sorted in ascending order.
Step 4) Prepare to sort multiple columns
Next, we’ll explain how to sort a range with two or more columns by a numerical field.
Select the columns you want to sort by number.
You may choose to include or exclude the header from the selection.
Step 5) Open advanced sorting options
Next, click on the options Data > Sort range > Advanced range sorting options.
Step 6) Set the primary column and sort order
A pop-up dialog will appear asking you which of the columns to sort by. In this example, we will be sorting by ID which is located in Column A. Next, select whether you want to sort from A to Z (ascending) or from Z to A (descending).
If your selection contains a header row, click on the indicated option to exclude the first row from the sorting action. Click on the Sort button to proceed.
Step 7) Complete the sort by number
The target range should now be sorted by number.
This guide should be everything you need to sort by number in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to sort in Google Sheets:
- How To Sort
- Add Dates
- Format Dates
- Stop Google Sheets From Changing Dates
- Sort Alphabetically
- Auto Sort
- Arrange Numbers In Ascending Order
- Sort By Color
- Sort By Date
- Change Date Format
- Sort By Last Name
- Sort And Filter
- Sort Unique Values
- Sort In Google Sheets And Keep Rows Together
- SORTN Function
- Randomize A List