Excel Sort by Highest Number: A Clear Step-by-Step Guide

Formulas & functions · Updated November 19, 2026

To sort numbers from highest to lowest in Excel, select a cell in the number column and choose Data > Sort Largest to Smallest. If Excel asks whether to expand the selection, choose Expand the selection so each number stays with the rest of its row.

What sorting by highest number does

A descending sort puts the largest value at the top and the smallest at the bottom. For example, sorting sales values of 18, 42, 27, 42, and 9 from largest to smallest puts the two 42s first, followed by 27, 18, and 9. Excel moves the associated records along with those values when you sort a complete table or range.

This is different from filtering. Sorting changes the order of the rows; filtering hides rows that do not meet a condition. It is also different from using a formula to calculate the maximum: sorting displays all the records in order, while a maximum formula returns only the highest value.

Sort a column in a regular range

For a simple list with related information in neighboring columns, use the sort command on a cell in the number column rather than selecting just that column. In Excel for Microsoft 365 on Windows:

  1. Check that every record has its information on the same row and that the data range has no completely blank rows or columns dividing it.
  2. Click a cell containing a number in the column you want to rank.
  3. Open the Data tab and choose Sort Largest to Smallest in the Sort & Filter group.
  4. If Excel displays a Sort Warning, choose Expand the selection, then select Sort.

For instance, if column A contains employee names and column B contains scores, click a score in column B and sort descending. Expanding the selection moves each employee name with the corresponding score. Sorting only column B could leave the names in their old positions and make the results incorrect.

If the range has a header, Excel will often recognize it. For more control, choose Data > Sort to open the Sort dialog. Check My data has headers, set Sort by to the number column, set Sort On to Cell Values, and set Order to Largest to Smallest. Then select OK. The dialog is especially useful when Excel guesses the wrong header or when you need more than one sort level.

Sort an Excel table

When your data is formatted as an Excel table, each column has a filter arrow in its header. Select the arrow on the number column and choose Sort Largest to Smallest. Excel sorts the table records together, so values in the other table columns remain on their matching rows. You can create a table by selecting the range and using Insert > Table; confirm whether the range has headers.

Tables are useful for lists that grow over time because new records become part of the table, and the header controls stay available. A table sort applies to the table, however, not necessarily to separate notes or totals placed beside it. Keep any columns that belong to a record inside the table, or select the full related range when sorting an ordinary range.

In Excel for Mac, use the sort controls on the Data tab or open Data > Sort and choose the descending order. Ribbon placement and keyboard access can vary by Mac version, but the sort options have the same purpose. Excel for the web also provides descending sort commands from the Data tab and table header menus.

Sort by highest number, then break ties

If two or more records have the same highest number, Excel places them together at the top, but the order between equal values may not be meaningful. For a consistent ranking, add a second sort level. Open Data > Sort, set the first level to the score or amount with Largest to Smallest, then choose Add Level. Set the second level to another useful column, such as name, date, or region, and choose its order.

For example, a competition results list could sort first by points from largest to smallest, then by completion time from smallest to largest. A sales report could sort first by revenue descending and then by salesperson name alphabetically. The first level determines the main ranking; the next level only orders records that tie on the preceding level.

You can add more levels if necessary, such as region after revenue and then customer name. Use the Sort dialog rather than repeatedly applying one-click sorts: a later one-click sort can replace the previous ordering instead of creating a deliberate hierarchy.

Use a formula to show a sorted copy

If you want the original list to remain in place while a separate area displays a live descending copy, the SORT function is an option in Microsoft 365 and Excel 2021 or later. With names in A2:A6 and numbers in B2:B6, enter this formula in an empty cell:

=SORT(A2:B6,2,-1)

The formula sorts the two-column range by its second column; -1 requests descending order. For the example values Cedar 18, Maple 42, Birch 27, Ash 42, and Pine 9, the output has the two 42 records first, then Birch 27, Cedar 18, and Pine 9. The two tied records appear together, but use a multi-level Sort dialog if their order must follow a defined tie-breaker.

SORT returns a dynamic array that spills into the cells below and to the right. Leave that output area clear, and do not include a header row in the formula range unless you intend to sort the header as data. The formula displays a sorted result without rearranging the source records. For a one-time reorder, the regular sort command is usually simpler; for a view that should update as source values change, a formula can be more convenient.

Why the largest number may not sort correctly

If values appear in an unexpected order, Excel may be treating some entries as text rather than numbers. A column that looks numeric can contain text values after an import, copy and paste, or inconsistent data entry. Signs include numbers aligning differently from the rest of the column, a warning indicator, or an order such as 100, 20, 3 that looks alphabetical rather than numeric.

  • Check the cell values: Select a suspicious cell and look for a warning indicator such as Number Stored as Text. If Excel offers Convert to Number, use it where appropriate.
  • Check the source format: Imported values may contain spaces, apostrophes, or characters such as a currency symbol entered as part of the text. Clean or convert the data consistently before sorting.
  • Check the full range: A blank row can split a list, and an incorrectly selected range can omit records. Use the Sort dialog to verify the range and sort column.
  • Check for formulas and errors: A formula result can be sorted as a value, but error values or formulas returning text may not behave like ordinary numbers.

Number formatting alone does not normally turn a number into text. For example, applying a currency format changes how a numeric value is displayed, not the value Excel sorts. Similarly, decimals and negative numbers are sorted by their actual numeric values: -2 is greater than -10, even though its absolute value is smaller. If the display is rounded, two values that look identical may still differ underneath; increase the displayed decimal places to inspect them.

Choose the right approach and avoid mistakes

Use a one-click descending sort for a quick ranking, the Sort dialog for headers or tie-breakers, and a table header menu when your records are already in an Excel table. Use SORT when you need a separate, updating output and have a supported Excel version. The best option depends on whether you want to change the source order or create another view.

Before sorting important data, consider making a copy or confirming that the entire record set is included. A sort is easy to undo immediately with Ctrl+Z on Windows or Command+Z on Mac, but later edits can make undoing less convenient. Do not sort a single field independently if the other columns describe the same records. If the data is part of a larger worksheet, make sure the sort range includes all columns that need to move together.

One related question is how to show only the top values rather than reorder every row. Sort descending to put the leaders first, then read the first few records, or apply a filter if you need to hide records outside a condition. Sorting itself does not remove or hide the lower values.

Frequently Asked Questions

How do I sort numbers from largest to smallest in Excel?
Click a number in the column, then choose Data > Sort Largest to Smallest. If Excel asks, expand the selection so related columns move with the number.

How do I sort an entire table by one column?
Use the sort arrow in that table column’s header and choose Sort Largest to Smallest. Excel reorders the table rows, keeping each record’s fields together.

Why is Excel sorting my numbers alphabetically?
Some entries may be stored as text. Convert those entries to numeric values consistently, then sort again. Check for imported spaces or other characters if conversion is not offered.

Can I sort from highest to lowest without changing my original data?
Yes. In Microsoft 365 or Excel 2021 and later, use SORT in a clear output area, for example =SORT(A2:B6,2,-1) when the values to sort are in the second column of A2:B6.

How do I decide the order when two numbers are tied?
Open Data > Sort, sort the number column first, choose Add Level, and select another column as the tie-breaker.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.