If you need to sort numerically in Google Sheets, the fastest fix is to make sure your numbers are treated as numbers, then sort the column in ascending or descending order. If text formatting is hiding the real values, Sheets will arrange them wrong, so a quick cleanup first saves time. Once the data is numeric, you can put numbers in order in just a few clicks.
Sort numbers in order with the built-in sort tools
The simplest way to order by number in Google Sheets is to use the sort range or sort sheet options. This works for one column of numbers or a full table with headers.
Sort a single column
- Select the cells in the number column.
- Click Data, then choose Sort range.
- Check Data has header row if the first cell is a label.
- Choose the column you want to sort by.
- Select A to Z for smallest to largest, or Z to A for largest to smallest.
This is the right choice when you want to put numbers in order on Google Sheets without changing the rest of the sheet.
Sort a whole table by one number column
If your data has names, dates, and numbers together, sort the full table instead of only one column. That keeps each row matched to the right record. Select the full range, open Data, then Sort range, and sort by the numeric column. Do not sort only the number cells if the rows contain related data.
Fix numbers that sort like text
If your list refuses to go in numerical order, the values are probably stored as text. In that case, 1, 10, and 2 can appear in the wrong order because Sheets is reading them as strings, not numbers.
Signs your numbers are text
- The numbers align to the left instead of the right.
- Sorting puts 100 before 20 or 3 after 30.
- Imported data from CSV, forms, or copied tables behaves oddly.
Convert text to numbers
- Select the affected cells.
- Click Format, then Number, and choose Number.
- If that does not fix it, click an empty cell, type 1, copy it, then select the text numbers.
- Open Edit, choose Paste special, then Multiply.
That last step forces text values into real numbers. After that, sorting works as expected when you organize Google Sheets by number.
Use formulas to create sequential numbers
If your goal is not sorting existing data but numbering rows, use a formula. This is the cleanest way to number columns in Google Sheets when you want a running list that updates as rows change.
Simple sequential number formula
For a basic numbered column starting in row 2, enter this in A2:
=ROW()-1
Then fill the formula downward. Row 2 becomes 1, row 3 becomes 2, and so on. If your header starts in a different row, subtract the header row number instead.
Sequential numbers that skip blank rows
Use this formula in A2 if you want numbering only when another column has data:
=IF(B2=””,””,COUNTA($B$2:B2))
This is useful for Google Sheets sequential numbers in a column that grows over time. Blank rows stay blank, and filled rows get the next number automatically.
Auto fill sequential numbers without a formula
If you only need a quick list, Google Sheets auto fill sequential numbers with two starting values. Type 1 in the first cell and 2 in the next cell, select both, then drag the fill handle down. Sheets extends the pattern as 3, 4, 5, and so on.
Fill a full row or column fast
To number rows in Google Sheets across a long sheet, enter the first two numbers, highlight both, and double-click the fill handle. Sheets fills down alongside the adjacent data until it reaches the last filled row in the neighboring column.
Use SEQUENCE for dynamic numbering
The formula for numbering in Google Sheets can also be dynamic. Enter this in a blank cell:
=SEQUENCE(10)
That creates 10 sequential numbers vertically. For a horizontal list, use =SEQUENCE(1,10). If you need a longer list, change the 10 to the number of rows you want.
Sort by number after filtering or importing data
Imported spreadsheets often need one extra cleanup step before sorting. If you paste data from a website, export tool, or database, hidden spaces, currency symbols, or apostrophes can block numeric sorting. Clean the column first, then sort it.
Remove common import problems
- Delete leading apostrophes from numbers.
- Remove spaces before or after the number.
- Strip currency symbols if the cells are plain values, not formatted currency.
- Make sure decimal separators match your locale settings.
Sort filtered data safely
If a filter is active, use the filter dropdown in the header row and choose Sort A to Z or Sort Z to A for the numeric column. This keeps the visible rows in the right order without disturbing the filter setup.
Number rows, columns, and items in a sheet
People searching for how to number Google Sheets usually need one of three things, a row index, a column index, or item numbers beside a list. The method depends on whether the numbering should stay fixed or update with the data.
Number rows in a table
Use a formula in the first data row, then copy it down. If you want the numbering to ignore the header, start in row 2. For a fixed list, you can also type 1 and 2, select both, and drag down to continue the sequence.
Number items in a filtered list
If rows can be hidden or removed, use a formula tied to the visible data instead of hard typing numbers. This keeps the numbering aligned with the current sheet and avoids manual renumbering after edits.
Frequently Asked Questions
How do you put numbers in order in Google Sheets?
Select the range, go to Data, then Sort range, and choose ascending or descending order by the numeric column. If the numbers sort incorrectly, convert text values to real numbers first.
How do you make Google Sheets numerical order instead of alphabetical order?
Make sure the cells are formatted as numbers, not plain text. Then sort the column with A to Z for low to high or Z to A for high to low. Alphabetical sorting treats 10 as if it comes before 2, which is the wrong result for numeric data.
How do you fill sequential numbers in Google Sheets?
Type 1 and 2 in the first two cells, select them, and drag the fill handle down. For a formula-based option, use =ROW()-1 or =SEQUENCE(n), where n is the number of rows you want.
How do you number columns or rows automatically?
Use a formula in the first cell of the numbering column. =ROW()-1 works for a simple running index, and =IF(B2=””,””,COUNTA($B$2:B2)) works when you want numbering only when adjacent data exists.
Why does Google Sheets sort numbers wrong?
The most common cause is text formatting. Numbers stored as text are sorted like words, not values. Convert them to real numbers, then sort again.
Related Posts:
Google Sheets
- How to Freeze Rows and Columns in Google Sheets
- How to Calculate Totals in Google Sheets
- How to Merge Cells in Google Sheets
- How to Edit a Pivot Table in Google Sheets
- How to Round Numbers in Google Sheets
- How to Delete or Remove a Filter View in Google Sheets
- How to Lock a Formula or Cell in Google Sheets
- How to Use VLOOKUP and XLOOKUP in Google Sheets
- How to Insert Multiple Rows in Google Sheets
- How to Protect Cells and Sheets in Google Sheets
- How to Link Google Sheets to Google Calendar
- How to Calculate Days Between Dates in Google Sheets
- How to Remove a Drop-Down in Google Sheets
- How to Subtract in Google Sheets
- How to Change Cell Color With a Formula in Google Sheets
- How to Change Cell Width in Google Sheets
- How to View Hidden Sheets and Rows in Google Sheets
- How to Add Cells and Columns in Google Sheets (SUM)
- How to Search in Google Sheets
- How to Insert a Hyperlink in Google Sheets
- How to Convert Google Sheets to Excel
- How to Hide Formulas in Google Sheets
- How to Insert an Image Into a Cell in Google Sheets
- How to Sort in Google Sheets (A to Z, by Column)
- How to Make a Graph in Google Sheets
- How to Alphabetize in Google Sheets
- How to Remove Duplicates in Google Sheets
- How to Resize Cells to Fit Text in Google Sheets
- Google Sheets Formulas: The Essentials With Examples
- How to Insert a Checkbox in Google Sheets