Sort Highest to Lowest in Google Sheets: A Clear Guide

To sort values from highest to lowest in Google Sheets, select the full data range, choose Data > Sort range > Advanced range sorting options, select the column to sort by, and choose Z → A. If the first row contains column names, check Data has header row before sorting so the headings stay at the top.

What “highest to lowest” means

For numbers, highest to lowest means descending order: the largest value appears first and the smallest appears last. In Google Sheets’ sorting controls, this direction is labeled Z → A, even when the selected column contains numbers rather than letters. For example, sorting sales values of 125, 480, 210, and 90 from Z to A produces 480, 210, 125, and 90.

The same direction has different practical meanings for other data types. Dates appear newest to oldest, while text is sorted in reverse alphabetical order. That can be useful for finding recent entries or names near the end of the alphabet, but it is not the same as ranking a numerical score. Choose the sort direction based on what the column represents, not just on the label shown in the menu.

A crucial distinction is whether you sort a complete table or just one column. If names, dates, and amounts belong to the same records, sorting only the amount column can separate the values from the people or transactions they describe. The safe default is to sort the entire rectangular range of related data, using the amount or score column as the sorting key.

Sort a range without moving the header

Use the range-sorting controls when you want to sort a table while keeping its header row in place. In a browser, these steps work in Google Sheets:

Select the data range, including all columns that belong to each record. For instance, select A1:C6 if row 1 has headings and rows 2–6 contain names, regions, and sales.
Open Data > Sort range > Advanced range sorting options.
Check Data has header row if the first selected row contains labels such as Name or Sales.
Under Sort by, choose the heading for the numeric column, such as Sales.
Choose Z → A, then select Sort.

For the example range, the complete rows move together, so each name and region remains matched to its original sales figure. The headings remain above the sorted records. If you omit the header-row setting, Sheets may treat the heading as ordinary data and move it into the sorted list.

You can also use the simpler Data > Sort range options shown for a selected range, when available. The advanced range options are helpful when you need to identify the header row or choose among several columns. If the data is part of a larger sheet, check the selected range carefully before confirming the sort.

Sort an entire sheet

If the records occupy the sheet and you want to sort all of them together, use the sheet-sorting command rather than sorting a single selected column. Choose Data > Sort sheet, then select the column and the descending direction offered in the menu. Depending on the menu presentation, the choices may be named for a particular column, such as sorting by column C, and by direction.

Before sorting, confirm that the sheet does not contain unrelated information outside the table. A sheet-level sort can rearrange rows beyond the data block you intended to organize. If there are notes, totals, or a second table below or beside the main list, consider selecting and sorting only the intended range instead.

For a table with headings, use the option that recognizes the header row when it is offered, or select the data range and use the range-sorting method above. The goal is the same: move whole records according to one column, while leaving headings and unrelated material where they belong.

Sort by more than one column

Secondary sorting is useful when multiple records share the same primary value. Suppose a list has Region, Sales, and Rep columns. You can sort by Sales from highest to lowest, then add Region as a second sort column. Within groups with equal sales, the regions will be ordered according to the secondary direction you choose.

In the advanced range sorting options, set the first sort column and direction, then use Add another sort column to specify the next key. The first key determines the main order; the second key only orders records whose first-key values tie. You can add another key if needed, such as sorting tied regions by representative name.

This is different from applying separate sorts one after another without planning the order. A later sort can change the order created by an earlier one. Multi-column sorting states the priorities in a single operation, which makes the intended ranking easier to understand and repeat.

Use SORT for a live sorted result

If you want an automatically updated sorted copy rather than rearranging the source data, Google Sheets has the SORT function. With names in A2:A6 and scores in B2:B6, enter this formula in an empty cell outside the source range: =SORT(A2:B6,2,FALSE). It returns the two-column range ordered by its second column, scores, in descending order. If the scores are 91, 76, 98, 84, and 91, the returned score order is 98, 91, 91, 84, 76, with each name kept beside its score.

In this formula, A2:B6 is the range to return, 2 identifies the second column within that range as the sort key, and FALSE requests descending order. The source cells remain as they are; the sorted results appear in the formula cell and the cells below and beside it as needed. Leave enough empty space for the results, or the output may be blocked by existing content.

A formula-based result can be convenient for a dashboard or report, because it reflects changes to the source data. It does not replace the original list, and it is not the best choice if you need to manually edit the sorted output. For a one-time rearrangement of the original records, use the Data menu instead.

Numbers, dates, text, and blanks

Sorting works best when the values in the key column have consistent types. A column that looks numeric may contain numbers stored as text, such as an entry preceded by an apostrophe or imported from another system. Text-formatted numbers may not sort in the numerical order you expect. If the result looks wrong, check the cell contents and formatting, and convert inconsistent entries to actual numbers before sorting.

Dates should also be genuine date values rather than text that merely looks like a date. A real date sorted Z to A puts the latest date first. Text dates can instead be arranged according to their characters, which may produce a surprising sequence, especially when formats vary. Standardize the date entries if newest-to-oldest order matters.

Blank cells and mixed content can affect how a sorted list appears. If missing values should not be ranked, decide whether to leave them blank or fill them consistently before sorting. For a ranking report, it may be clearer to exclude incomplete records from the selected range or review them separately, rather than assume a blank is equivalent to zero.

Common sorting problems and safe habits

Only one column moved: Undo immediately if the rows no longer match. Then select the full table and sort by the desired key column.
The heading was sorted into the data: Repeat the sort and identify the header row in the range-sorting options.
The order seems alphabetical instead of numeric: Check for numbers stored as text or mixed values, then correct the column and sort again.
The rows are sorted but a formula output is missing: Make room for the results by clearing cells in the area where the SORT output needs to appear.
Equal scores appear in an unexpected order: Add a secondary sort column to define how ties should be arranged.

Before a major reordering, consider making a copy of the sheet or using undo promptly if the result is not what you intended. Sorting changes row order, not the underlying values, but it can still be disruptive if the wrong range was selected. A quick check of the first and last few rows, along with a spot-check of a complete record, helps catch mistakes.

When several people work in the same file, a filter view can be a less disruptive way to examine a sorted version. Use Data > Filter views > Create new filter view, then use the filter controls in the column headings to choose descending order. A filter view gives a way to organize and inspect the data without treating a personal sort as a permanent change to the shared sheet’s displayed order.

How Google Sheets compares with Excel

The underlying idea is similar in Excel: select the full data table, identify the sort column, and choose descending order. But the menu paths and wording differ, so instructions written for one program should not be assumed to match the other. This guide’s paths, including Data > Sort range, refer to Google Sheets in a web browser, not Microsoft Excel.

In either program, the most important safeguard is to keep related fields together. Sorting a single column independently can detach its values from the rest of each record. For a live sorted copy, both programs offer sorting formulas, but their available options and behavior are not identical in every case. Use the formula syntax and menu commands for the spreadsheet app you are actually using.

Frequently Asked Questions

How do I sort one column from largest to smallest in Google Sheets?
Select the complete range of related records, open Data > Sort range > Advanced range sorting options, choose the numeric column, and select Z → A. Include the header row and mark it as a header if the range includes headings.

Does Z to A mean highest to lowest?
For numerical values, yes: Z to A sorts from the largest number to the smallest. For dates, it generally means newest to oldest; for text, it means reverse alphabetical order. The correct interpretation depends on the data type.

How can I keep the header at the top while sorting?
Select the range, open the advanced range sorting options, and check Data has header row. Then sort by the named column. This tells Sheets to treat the first row as labels rather than as a record to rearrange.

Can I sort highest to lowest and then sort ties by name?
Yes. In the advanced range sorting options, set the numeric column to Z → A, add another sort column, and choose the name column with the direction you want. The name order applies within groups that tie on the primary value.

Can Google Sheets keep a second copy sorted automatically?
Yes. Put a SORT formula in an empty area, with the complete source range and the position of the key column. For example, =SORT(A2:B6,2,FALSE) returns columns A and B sorted by column B from highest to lowest, while leaving the original range unchanged.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.