How to Sort a Column From Highest to Lowest in Google Sheets

Sorting a column from highest to lowest in Google Sheets is how you rank sales, scores, prices, or dates with the biggest (or newest) value at the top. Google Sheets calls this Z to A sorting, and it works for numbers and dates as well as text. This guide covers the quick sort, sorting with a header row, sorting by more than one column, and the SORT function for a live, automatically updated ranking.

Quick Answer

Freeze your header row with View > Freeze > 1 row. Then right-click the letter at the top of the column you want to sort (or click its dropdown arrow) and choose Sort sheet Z to A. The whole sheet is reordered with the largest values first, and each row stays together.

What “Z to A” Means for Numbers and Dates

Data type	A to Z	Z to A
Numbers	Lowest to highest	Highest to lowest
Dates	Oldest to newest	Newest to oldest
Text	Alphabetical	Reverse alphabetical

Method 1: Sort the Whole Sheet

1. If your data has a header row, go to View > Freeze > 1 row so the headers stay at the top.
2. Right-click the column letter (for example, B), or hover over it and click the small down arrow.
3. Choose Sort sheet Z to A.

Every row on the sheet moves together, so each product keeps its matching values. You can also select a cell in the column and use Data > Sort sheet > Sort sheet by column B (Z to A).

Method 2: Sort Only a Range (With Headers)

Use this when the sheet has other content you don’t want to move.

1. Select the full table, including every column that belongs to each row (for example, A1:C7).
2. Go to Data > Sort range > Advanced range sorting options.
3. Check Data has header row.
4. Under Sort by, choose your column (for example, Units sold) and select Z → A.
5. Click Sort.

Warning: If you select only one column and sort it, only that column moves, which scrambles your rows. Always select the whole table, or use Sort sheet.

Method 3: Sort by More Than One Column

To rank by one column and break ties with another, such as highest revenue first, then alphabetically by product:

1. Select the table and open Data > Sort range > Advanced range sorting options.
2. Set the first sort column to Revenue, Z → A.
3. Click Add another sort column and choose Product, A → Z.
4. Click Sort.

Method 4: SORT Function (Live Ranking)

Sorting with menus changes your data once. The SORT function creates a separate sorted copy that updates automatically when the original changes.

In an empty area, enter:

=SORT(A2:C7, 2, FALSE)

• A2:C7 is the data (without headers).
• 2 is the column within the range to sort by (the 2nd column, Units sold).
• FALSE means descending (highest to lowest). TRUE is ascending.

For an open-ended range that includes new rows, use =SORT(A2:C, 2, FALSE). To show only the top 5, wrap it: =ARRAY_CONSTRAIN(SORT(A2:C, 2, FALSE), 5, 3), or use =SORTN(A2:C, 5, 0, 2, FALSE).

Method 5: Sort With a Filter or Table

• Filter: Select your data and click Data > Create a filter. Click the filter icon in a header and choose Sort Z → A. Headers stay in place automatically.
• Filter view: Use Data > Filter views > Create new filter view to sort just for yourself without changing what collaborators see.
• Tables: If your data is formatted as a table (Format > Convert to table), click a column header’s menu and choose Sort Z to A.

Sort on Your Phone

1. In the Google Sheets app, tap the column letter to select the column.
2. Tap the letter again (or the three-dot menu) and choose Sort Z-A.

Freeze the header row first (tap the row number, then Freeze) so it isn’t sorted into the data.

Troubleshooting

• Numbers sort in the wrong order (like 1,000 before 200): They’re stored as text. Select the column and choose Format > Number > Number, or remove leading apostrophes and spaces.
• Header row got sorted into the data: Press Ctrl + Z, freeze row 1, and sort again, or check Data has header row.
• Merged cells error: Sheets can’t sort ranges with merged cells of different sizes. Unmerge them with Format > Merge cells > Unmerge.
• Dates sort alphabetically: They’re text, not real dates. Use Format > Number > Date or DATEVALUE to convert them.

Summary

1. Freeze the header row (View > Freeze > 1 row).
2. Right-click the column letter and choose Sort sheet Z to A.
3. Use Sort range for part of a sheet or multiple sort columns.
4. Use =SORT(range, column, FALSE) for a ranking that updates automatically.