To sort numbers in Excel from low to high, click a cell in the number column, open the Data tab, and choose Sort Smallest to Largest. If Excel asks whether to expand the selection, choose Expand the selection so each number stays with the rest of its row. Before sorting, check that your data has a clear header and that numbers are stored as numbers.
This ascending sort puts the lowest value first and the highest value last. It works for a standalone list or a larger table, but selecting the correct range matters: sorting only one column can scramble the relationship between values and names, dates, or other details in neighboring columns.
What You’ll Need
- An Excel workbook containing the numbers you want to sort.
- A clear idea of whether you are sorting one independent list or complete rows of related information.
- If the numbers belong with other data, a header row is helpful. It makes the range easier to identify and reduces the chance of sorting a heading as if it were a value.
Step-by-Step
- Check how the data is arranged. Find the column containing the numbers. If each number belongs to a record—for example, a product price beside a product name—treat the whole set of columns as one table. Look for a header such as “Score” or “Price” in the first row. If you have a title above the table, keep it separated by a blank row so Excel can recognize the table range more reliably.
- Click a number in the column you want to sort. In a continuous table, you usually do not need to highlight every cell. Click one data cell in the target column, not the header. Excel can detect the connected range around that cell. If the worksheet has blank rows or columns splitting the data, select the complete table range yourself, from its first header or data cell to its last cell.
- Open the ascending sort command. In Excel for Microsoft 365 on Windows, select Data on the ribbon, then click Sort Smallest to Largest in the Sort & Filter group. The command may show an A-to-Z style icon with a downward arrow; the wording identifies the ascending sort. You can also use Home > Sort & Filter > Sort Smallest to Largest.
- Choose how to handle neighboring columns if prompted. When Excel detects adjacent data, it may warn that the selected column is next to other data. Choose Expand the selection, then click Sort. This moves each entire row together. Choose Continue with the current selection only when the selected numbers are genuinely independent and should be rearranged without the adjacent cells.
- Check the result. The smallest numeric value should now be at the top of the sorted range, followed by increasingly large values. The highest value should be at the bottom. If your table has headers, confirm that the header stayed at the top and that the names or other details on each row still match their original numbers.
- Use the Sort dialog for more control. If you want to verify the range or header setting, click inside the table and choose Data > Sort. In the dialog, select the number column under Sort by. Set Sort On to Cell Values and Order to Smallest to Largest. If your first row contains headings, make sure My data has headers is selected; otherwise, leave it unchecked. Click OK to sort.
- Sort a formatted Excel table when appropriate. If the data is already an Excel table, click the filter arrow in the number column’s header and choose Sort Smallest to Largest. Excel sorts the table’s rows together, so the associated fields stay aligned. This is often the simplest method for a regularly updated list.
The ribbon labels and general process are similar in Excel for Mac and Excel for the web, though the ribbon layout or prompt can look slightly different. Use the Data tab and select the ascending, smallest-to-largest option. On a Mac, the Sort dialog may be arranged differently, but its controls still let you choose the column, values, and ascending order. If you do not see the command, widen the Excel window or look for the sort options in the ribbon’s overflow area.
Common Mistakes
- Sorting only the number column in a table. This can leave names, descriptions, or dates in their old positions, so the records no longer make sense. When Excel asks, choose Expand the selection. If no prompt appears, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, select the full table, and sort again.
- Including the header as a number. If Excel treats a heading such as “Score” as data, it may move into the sorted list. In the Sort dialog, set the header option correctly. A clear header row and a single, uninterrupted range help Excel identify it.
- Assuming number-looking text is numeric. Values stored as text can sort unexpectedly, especially in a column containing a mixture of text and real numbers. For instance, text values may be ordered by character rather than by numeric value. Check for a warning marker, inconsistent alignment, or a green triangle in the cell corner.
- Sorting a partial range. Selecting only some of the rows can separate sorted values from records that were meant to be included. Confirm that the selection begins at the first relevant row and ends at the last one, including all related columns.
- Forgetting that blanks and other values are present. Empty cells, errors, and text labels can affect what the finished list looks like. Review the whole column before sorting rather than assuming every cell contains a number.
Tips
- Make a copy before a major rearrangement. Sorting can be undone, but a saved copy is useful when the workbook is important or when several people edit it.
- Convert a frequently used range to a table. Select the data and choose Insert > Table, confirming whether the table has headers. Table sorting keeps complete records together and makes it easier to include new rows later.
- Use the Sort dialog for multiple keys. To sort by score and then by date, open Data > Sort, set the first level to the score column and Smallest to Largest, then use Add Level to set the next column. The secondary rule orders records that tie on the first key.
- Keep data types consistent. Enter numeric values as numbers throughout the column, rather than mixing numbers with labels such as “about 10.” Put units in a separate column or use number formatting to display them.
- Remember that dates are numbers to Excel. Sorting a date column from smallest to largest puts earlier dates first. A date may display in a familiar date format while Excel stores its underlying value numerically.
Troubleshooting
The values do not appear in numeric order. One or more cells may be numbers stored as text. Select the affected cells and look for Excel’s error indicator or the small warning icon. If Excel offers Convert to Number, use it after checking that the cells should be numeric. You can also re-enter a value as a number or use Data > Text to Columns to convert a consistently formatted text column: select the cells, open that command, and finish the wizard without changing the delimiter settings if none are needed. Then sort again.
Names no longer match their numbers. Undo the sort straight away with Ctrl+Z on Windows or Command+Z on Mac. Select the entire data range, including all related columns, and repeat the sort. If you saved or performed other edits after sorting, undo may not restore the intended arrangement; use a backup or compare with the original data before proceeding.
The header moved into the list. Undo the operation, open Data > Sort, and set My data has headers correctly. If there is no header, make sure the first numeric row is not mistakenly excluded. A table created with Insert > Table can also make header handling clearer.
Some rows were not sorted. Look for blank rows, blank columns, or cells outside the selected range that split the data into separate blocks. Select the complete intended range manually, including all related columns, and sort from the dialog. If the data is a table, use its header filter arrow to sort that table.
You cannot find the sort option or the command is unavailable. Click inside the worksheet range and check the Data tab again. A protected sheet may prevent sorting; ask the workbook owner to allow sorting or unprotect the sheet if you have permission. In Excel for the web, confirm that you are in editing mode rather than viewing mode. Ribbon placement can vary by window size, so maximize the window or expand the ribbon.
Frequently Asked Questions
How do I sort a single list of numbers from lowest to highest?
Click a number in the list and choose Data > Sort Smallest to Largest. If there is other data alongside the list, expand the selection so those cells move with the numbers.
Will Excel sort negative numbers correctly?
Yes, when the cells contain numeric values. Negative numbers come before zero and positive numbers; for example, -12 comes before -3, then 0, then 4. If the order looks wrong, check whether some entries are stored as text.
Can I sort numbers without moving the other columns?
Yes, but only do so when the numbers are independent and have no row-by-row connection to neighboring cells. If the values belong to records, sort the full table so each record stays intact.
What happens to blank cells when I sort ascending?
Blanks are generally placed after numeric values in an ascending sort. Their exact position can depend on the type of sort and the data in the range, so inspect the results if blank rows have a special meaning in your worksheet.
How do I sort numbers from low to high when some values are repeated?
Excel keeps equal values together in the ascending order. If you need a specific order within ties, open Data > Sort and add a second sort level, such as a name or date column.
Can I sort numbers in Excel for Mac or the web?
Yes. Excel for Mac and Excel for the web both provide ascending sort commands. Look under the Data tab, or use a table column’s sort menu; the wording and screen layout may vary slightly.
Related
- How to Rank in Excel with RANK.EQ
- How to Randomize in Excel: Shuffle Lists and Numbers
- How to Rank in Excel When There Is a Tie: Two Methods
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Match in Excel Without Duplicates: Formulas That WorkTo return values that appear in both Excel lists without repeating them, use =UNIQUE(FILTER(A2:A100,(A2:A100<>"")*ISNUMBER(XMATCH(A2:A100,B2:B100)),"")). With the first list…
- Align Left Shortcut Key in Excel for Windows and MacIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, H, A, L,…
- Excel FILTER Function: Multiple Criteria and ExamplesYes. In Microsoft Excel for Microsoft 365, use the FILTER function with multiplication (*) to require multiple conditions…
- Sort Excel by Color: Cells, Font Colors, and IconsTo sort Excel rows by color in Microsoft 365 for Windows, select your data, choose Data > Sort,…
- How to Insert a Filter in Excel: Quick StepsTo insert a filter in Excel, click a cell in your data, then select Data > Filter. Excel…
- SUMIF Formula for Dates: Examples and Common FixesUse Excel’s SUMIF with a date as the criterion to add values for a specific date; use comparison…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.