To show the largest values first in Excel, open the filter arrow on the column you want to rank and choose Sort Largest to Smallest. Excel sorts the entire row of data with each value, so names, dates, and other related details stay together. Strictly speaking, this is a descending sort; filtering usually means hiding rows that do not meet a condition. Excel puts both controls in the same column dropdown, which is why the terms are often used together.
The instructions below are for Microsoft Excel for Microsoft 365 on Windows. They work for a normal data range or an Excel table. Before sorting, check that your data has a header row and that the rows belong together as one continuous block.
What You’ll Need
- An Excel workbook with the data you want to arrange.
- A column containing sortable values, such as sales, scores, quantities, or dates.
- A clear header row, with one distinct heading for each column. This helps Excel identify the fields and put filter arrows in the correct place.
You do not need a formula or a separate sorting tool. If your data is spread across several unrelated blocks, decide which rows and columns belong together before you begin; sorting one block without the others can separate records that should remain linked.
Step-by-Step
- Check the data layout. Look across the heading row and confirm that every column has a label, such as Product, Region, and Revenue. Check that each record occupies one row and that there are no completely blank rows or columns inside the list. For example, if a sales record has a product name in column A and its sales amount in column D, those details need to move together when you sort by column D. If the sheet has a title above the actual headings, do not treat that title as part of the data range.
- Select a cell in the data. Click any cell inside the range you want to sort, rather than selecting just the values in the ranking column. Excel can usually detect the connected block automatically. If you have an Excel table, click inside it; tables already have filter arrows in their header row. If the sheet contains nearby data that should not be included, select the exact range, including its headers, before turning on filtering.
- Turn on the filter arrows if they are not visible. On Windows, use Data > Filter on the ribbon, or press Ctrl+Shift+L with a cell in the data range selected. Excel adds a dropdown arrow to each header. If the range is already an Excel table, the arrows are normally present and you can move to the next step. To make a range into a table, select it and choose Insert > Table, then confirm that My table has headers is checked when appropriate.
- Open the dropdown for the column you want to rank. Click the arrow beside the relevant heading, not the arrow beside a different field. For a column named Revenue, for instance, open the Revenue arrow. The menu includes sorting choices and, depending on the type of data, filter options. If you see checkboxes listing individual values, those are for showing or hiding records; the sort command is usually near the top of the menu.
- Choose the descending sort command. For numbers, select Sort Largest to Smallest. For text, the equivalent is usually Sort Z to A; for dates, choose Sort Newest to Oldest. Excel rearranges the rows so the greatest value, latest date, or last alphabetical entry appears first. The exact wording depends on the data type and Excel interface. If Excel asks whether to expand the selection, choose Expand the selection so the other columns remain attached to their records, then click Sort.
- Check that the result makes sense. Read the first few values in the sorted column and compare them with the original records. For a number column, the values should generally stay the same or decrease as you move down. Make sure the names or other details beside them still match. If you wanted only certain rows to remain visible, open the filter arrow again and select the values or conditions to keep; sorting alone changes the order but does not hide rows.
- Save or undo if needed. If the order is wrong, press Ctrl+Z promptly to undo the sort, then check the selected column and data range before trying again. When the result is correct, save the workbook. Excel remembers the new row order, so saving preserves the arrangement for the next time the file is opened.
On a Mac, the basic method is the same: use the Data tab and its Filter control, then use the dropdown in the desired header. Ribbon labels and shortcuts can differ by Excel version and keyboard settings, so use the ribbon if the Windows shortcut does not work. Excel for the web also supports filter dropdown sorting; open the relevant header menu and choose the descending option shown for that column.
Common Mistakes
- Sorting only one column. Selecting a column of amounts and sorting it alone can leave the amounts beside the wrong names. Use the header dropdown within the full list, or choose to expand the selection if Excel prompts you. When a prompt appears, do not choose to continue with the current selection unless you intentionally want to rearrange that one column independently.
- Choosing a filter instead of a sort. Checking or clearing items in the dropdown hides or reveals rows; it does not put the remaining values in descending order. Use the explicit largest-to-smallest, Z-to-A, or newest-to-oldest command for ranking. You can sort first and then apply a filter if you need both.
- Including a title row or missing the actual headers. A decorative title above the list can confuse Excel about where the data starts. Start the range at the real header row. Also avoid blank header cells: a blank heading can make the filter controls harder to identify and may cause Excel to interpret the range unexpectedly.
- Expecting numbers stored as text to sort numerically. Values that look like numbers may be stored as text, particularly when pasted from a website or imported from another system. Excel may sort those entries alphabetically rather than by numeric value. Check for warning indicators, inconsistent alignment, or unexpected ordering before assuming the sort is broken.
- Ignoring existing filters or hidden rows. A filtered list may show only some records, and hidden rows can make the visible result look incomplete. Clear filters or inspect the row numbers before drawing conclusions about the full data set.
Tips
- Use a table for frequently updated lists. Select the data and choose Insert > Table. Tables provide filter arrows, expand when new rows are added, and help keep the sort range aligned with the records. Confirm the header setting during table creation so the first data row is not accidentally treated as a heading.
- Sort on a secondary field when values tie. If several rows have the same top score, use Data > Sort to add levels. In the Sort dialog, choose the main column first and set Order to Largest to Smallest; then add a level for a tie-breaker, such as name or date. This keeps the primary ranking while making ties easier to read.
- Keep a copy of the original order when it matters. Before sorting, add an index column with 1, 2, 3, and so on, or duplicate the worksheet. Sorting by the index later restores the original sequence. This is useful when the initial row order represents a meaningful timeline or source order.
- Know what happens to blanks. Blank cells may appear at the bottom of a descending numeric sort, while text and mixed values can behave differently. If blanks should not be included, use the filter menu to exclude blanks after sorting, or fill missing values only when you know what those blanks should mean.
- Distinguish sorting from filtering. A descending sort changes the order of records. A filter narrows which records are displayed based on criteria, such as a region or a range of dates. Both can be active at once, so a sorted list may still contain only the currently visible subset.
Troubleshooting
The sort option is missing or disabled: Click inside the data range, confirm that filtering is on, and open a header dropdown. If the worksheet is protected, sorting may be restricted; check Review > Unprotect Sheet if you are authorized to change the sheet. Also check whether the workbook is in a mode or format that limits editing.
Rows do not stay together: Undo immediately with Ctrl+Z. Select the whole data range and repeat the sort, or use the header dropdown so Excel recognizes the complete list. If prompted to expand the selection, choose that option. For separate blocks with blank columns between them, select the full intended range explicitly or convert the data into one table before sorting.
Numbers appear in an unexpected order: Check whether the entries are stored as text or contain inconsistent symbols, spaces, or decimal separators. If there is a warning icon, use its conversion option when appropriate, or clean the imported data consistently before sorting again. Do not remove currency symbols or punctuation blindly if they are meaningful parts of the data.
Some records seem to be missing: Look for active filter indicators in the header arrows and choose Clear Filter From the relevant column, or use Data > Clear to clear filters across the range. Check for manually hidden rows as well. A sort does not delete records, but an active filter can hide them from view.
The order changes when new rows are added: A normal range may not automatically include rows typed below it. Convert the list to a table, or select the expanded range and sort again. A table is often easier to maintain because its structure and filter controls extend as the list grows.
Frequently Asked Questions
Is filtering highest to lowest the same as sorting?
Not exactly. Sorting rearranges rows by value; filtering hides rows that do not meet chosen criteria. Excel places sort commands inside filter dropdowns, so you can use the same menu for either task.
How do I sort highest to lowest without mixing up the rows?
Use the dropdown on the target column while the data is arranged as one continuous range or table. If Excel asks whether to expand the selection, choose that option. Check a few records afterward to confirm that the other fields moved with their values.
Can I sort only the visible filtered results?
Yes. When a filter is active, sort from the column dropdown and Excel sorts the records in the filtered list while preserving the rows as records. Hidden rows remain hidden until you clear the filter. Confirm the visible values and filter indicators afterward.
How do I sort dates from most recent to oldest?
Open the date column dropdown and choose Sort Newest to Oldest. If the dates do not order as expected, some entries may be text rather than real Excel dates or may use inconsistent formats. Check the cell values before changing their format.
Can I return to the original order?
Use Ctrl+Z immediately if the sort was your last action. Otherwise, Excel does not automatically keep a record of the prior order. A saved copy or an index column created before sorting can help you restore it.
Will this work in Excel for Mac or the web?
Yes. Both versions support sorting from filter dropdowns. The ribbon layout and keyboard shortcuts may differ, so use the Data tab or the dropdown menu if a Windows shortcut or label does not match your interface.
Related
- How to Enable Track Changes in Excel
- Enable Scroll Lock in Excel: Keyboard and On-Screen Methods
- How to Enable the Share Option in Excel for Collaboration
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Break-Even Excel Formula: Calculate Units and SalesThe basic break-even formula in Excel is fixed costs divided by the contribution margin per unit: =B2/(B3-B4). If…
- IF vs. IFERROR in Excel: Key Differences and ExamplesIF tests a condition and returns one result when it is true and another when it is false;…
- Days Between Dates in Excel: TODAY Formula and ExamplesTo calculate the number of days from a date in Excel to today, subtract the date cell from…
- Excel Calculating Hours Worked: Formulas and TipsTo calculate hours worked in Excel, subtract the start time from the end time; for a shift that…
- Excel Date Filter Multiple Criteria: Practical MethodsTo filter dates in Excel by multiple criteria, turn on AutoFilter, open the date column’s dropdown, and choose…
- Combine HLOOKUP and VLOOKUP in ExcelYes. You can nest VLOOKUP inside HLOOKUP so VLOOKUP finds the row number and HLOOKUP finds the column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.