Sort a Column in Google Sheets: Steps and Tips

To sort a column in Google Sheets, select the data you want to organize, then choose Data > Sort range and pick an ascending or descending order. If the column belongs to a table of related rows, include the whole table in the selected range so names, dates, and other values stay together.

What sorting a column does

Sorting rearranges cells according to their values: text can be ordered alphabetically, numbers from low to high or high to low, and dates from earliest to latest or latest to earliest. It changes the order of the data in the sheet; it does not merely change how the cells look. For example, sorting a list of product names A to Z moves the rows into alphabetical order.

The important question is whether the column stands alone. If column A contains a list of unconnected words, sorting only that column may be exactly what you want. But if each row represents a person, order, or item, other columns in the row are part of the same record. Sorting just one column can pair each name with someone else’s phone number or each product with the wrong price. Select the complete table in that case, or use a sheet-level sort.

Google Sheets runs in a web browser, and its sorting commands are under the Data menu. The choice between sorting a sheet, a range, or filtered data depends on how much of the sheet should move and whether you want the result to be temporary or shared.

Sort an entire sheet

Use a sheet-level sort when the data occupies the sheet and each record should remain intact. First click a cell in the column that will determine the order. Then open Data, choose Sort sheet, and select the option for that column, such as sorting by column A from A to Z or Z to A. The menu shows the column letter, so check that it matches the field you intend to sort by.

A sheet-level sort rearranges rows across the sheet, not just the values in the active column. This is convenient for a simple data table, but check for unrelated content before using it. A note, second table, or manually placed heading elsewhere on the same sheet may also be affected. If your data is only one block among other content, sort the specific range instead.

If the first row contains column names, make sure Sheets recognizes it as a header when sorting a range. Otherwise, the header may be treated like a regular data value and end up among the records. On a sheet-level sort, the header is generally kept at the top when Sheets detects it, but for a carefully controlled operation, selecting the table and using the header-row option in the range-sorting dialog makes the intent explicit.

Sort a selected range and keep rows together

To sort a table without rearranging unrelated parts of the sheet, select the full rectangular range containing the headers and records. For example, if names are in columns A and B contains their email addresses, select both columns across the header and data rows rather than selecting just the names. Then choose Data > Sort range > Advanced range sorting options.

Select the complete table range, including every column that belongs to each record.
Open Data > Sort range > Advanced range sorting options.
If the top row contains field names, select Data has header row.
Choose the column to sort by and choose A to Z or Z to A, or the corresponding ascending or descending order.
Select Sort to apply the order to the selected range.

For instance, to sort a class list by student surname while keeping each student’s grade and email address aligned, include all those columns in the selected range and choose the surname column in the sort dialog. The rows move as units, so the grade and email remain associated with the same student.

If Sheets warns that you selected only part of a data range and asks whether to expand the selection, choose the option that expands it when the other columns belong to the same records. Choosing to sort only the current selection is appropriate only when the selected cells are genuinely independent. Before confirming, inspect the highlighted range and verify that it includes every related column and row.

Sort by more than one column

For records with ties, sorting by multiple columns creates a more useful order. In the advanced range-sorting options, set the primary sort column first, then use Add another sort column to specify a secondary column. The primary column determines the broad order; the secondary column orders records that share a primary value. You can add further sort columns when the table needs additional tie-breakers.

Suppose a table has department, last name, and first name. Sort first by department A to Z, then by last name A to Z, and finally by first name A to Z. The result groups employees by department, orders each group by surname, and resolves repeated surnames by first name. If you instead sort by first name first, the department grouping will not be the main organizing principle.

Choose ascending or descending separately for each sort level if the dialog offers the direction control for that level. For example, a report might sort departments A to Z and sales within each department from largest to smallest. Multi-column sorting is especially helpful for schedules, inventory, and reports where one field alone does not produce a stable, readable order.

Sort filtered data and use filter views

Filters help when you need to inspect or sort a subset of a table. Select the table and choose Data > Create a filter. Filter controls appear in the header row. Open the control for a column to sort its values or limit which rows are displayed. Sorting through a filter is useful for quickly organizing a dataset while also being able to hide records that do not meet a condition.

For a saved, separate way to view and sort shared data, use a filter view. Choose Data > Filter views > Create new filter view, then set the filter or sort using the header controls. Filter views are useful when collaborators need different ways to examine the same source table; one person can work in a filter view without simply changing the shared sheet’s ordinary view for everyone. Give a useful filter view a recognizable name so it can be found again.

Filters do not replace good range selection. The header row should be part of the filtered table, and all columns for each record should remain within that table. If the filter is applied to only one column in a wider dataset, sorting or filtering may not produce the aligned result you expect.

How Google Sheets orders different values

Text, numbers, and dates can look similar while being stored differently. A number stored as text may sort in a surprising place or follow text ordering rather than numeric ordering. For example, text values “1”, “10”, and “2” can sort alphabetically as 1, 10, 2, while numeric values sort as 1, 2, 10. If a sort looks wrong, check whether the cells have consistent types and whether imported values contain extra spaces or characters.

Dates also need to be recognized as dates, not merely strings that look like dates. A consistent date format helps, but display format alone does not convert text into a real date value. Try changing the cell format or cleaning the imported data if dates appear out of chronological order. Similarly, check that currency and percentage columns contain actual numeric values rather than symbols or text pasted into the cells.

Blank cells can be grouped at one end of the sorted results, and mixed values can make the order harder to interpret. Decide whether blank records should be removed, filled, or retained before sorting. If the sheet uses a particular language or regional setting, alphabetic ordering may also reflect those locale rules. When precise ordering matters, test on a copy or a small sample first.

Create a live sorted copy with SORT

Menu sorting changes the order of the existing data. If you want to preserve the source order and display a sorted result elsewhere, the Google Sheets SORT function can create a formula-driven copy. The output updates as the source values change, provided the formula’s output area is clear and the source range includes the rows and columns you want returned.

With names in A2:A5 and scores in B2:B5, where the rows are Mira 82, Owen 95, Priya 88, and Theo 76, enter =SORT(A2:B5,2,FALSE) in an empty cell. This sorts the selected two-column range by its second column in descending order, returning Owen 95, Priya 88, Mira 82, and Theo 76. The number 2 means the second column within the supplied range, and FALSE requests descending order.

Keep the formula outside the source range so it does not overwrite the cells it needs to read. Also leave enough blank space for all returned rows and columns; existing content in the output area can prevent the result from expanding. Use a menu sort when you want to reorder the original table, and a formula when you want a separate, automatically updated view while keeping the original sequence intact.

Common sorting problems and safeguards

Only one column moved: Undo immediately with Edit > Undo, then select the full table and sort again. Sorting one field alone can break row relationships.
The header moved into the data: Repeat the range sort and enable Data has header row. Confirm that the selected range starts at the header.
The order seems illogical: Check for numbers stored as text, dates stored as text, leading spaces, blank rows, or mixed types.
Unrelated cells changed position: The selected range or sheet may have included extra content. Undo, then choose a narrower range that still includes every column in the table.
A formula result will not appear: Make sure the output cells are empty and that the source range is valid and large enough to include the intended records.

Sorting a shared sheet is a real change to its row order, so consider warning collaborators before reorganizing a table they are using. If you are unsure whether a sort is safe, make a copy of the sheet first or use a filter view or formula-based sorted copy. Sorting itself does not delete records, but a mistaken selection can make the data misleading until it is undone or corrected.

Google Sheets sorting compared with Excel

The core idea is the same in Google Sheets and Microsoft Excel: select the relevant data, identify the sort column, and preserve complete rows. The interface differs. In Sheets, the main browser menu paths include Data > Sort sheet, Data > Sort range, and Data > Create a filter. Excel for Microsoft 365 on Windows provides sorting commands on the Data tab and may show a prompt to expand the selection when you sort part of a table.

Do not assume that a set of menu directions or shortcut applies unchanged between the programs. If a workbook is opened in Excel, check Excel’s selection and header settings before sorting; if it is open in Sheets, use the Sheets menus and dialogs described here. In either program, the data-safety principle is the same: sort related columns as one range so each complete record stays together.

Frequently Asked Questions

How do I sort one column alphabetically in Google Sheets?
Select the data range, including the header if there is one, then choose Data > Sort range > Advanced range sorting options. Mark Data has header row when appropriate, choose the text column, and select A to Z. If the column is part of a table, include the other table columns in the selected range.

How do I sort a column without mixing up the rows?
Select the entire table, not just the column you want to use as the sort key. Then sort the range by that column. This moves each row together, keeping names, dates, and other fields attached to the right record.

Can I sort by two columns in Google Sheets?
Yes. Open Data > Sort range > Advanced range sorting options, choose the primary sort column, and add another sort column. The second column breaks ties in the first, and you can add more levels for further tie-breakers.

How do I sort from highest to lowest?
Choose the descending option for the relevant column in the sort dialog. For a numeric column, that puts the largest value first. For dates, descending order puts the latest dates first; for text, it reverses the alphabetical direction.

Can Google Sheets keep a sorted copy while leaving the original alone?
Yes. Place a SORT formula in an empty area and point it at the source range. The formula returns an ordered result without rearranging the original cells, and it can update when source values change. Leave enough empty space for its output.

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.