Sort Ascending in Google Sheets: A Complete Guide

To sort ascending in Google Sheets, select your data, open Data, choose Sort range, and sort by the column you want from A to Z. For a whole table, include every related column in the selected range so each row stays together; for a whole worksheet, use Data > Sort sheet.

What ascending sort means

Ascending puts values in the order that generally runs from smallest to largest: numbers go from low to high, dates from earliest to latest, and text from A to Z. It is the reverse of descending order, which sorts numbers high to low, dates newest to oldest, and text Z to A. The exact ordering of some text can depend on the spreadsheet’s locale and how values are stored.

Sorting changes the displayed order of rows; it does not calculate a ranking or remove duplicate values. If you sort a table by its revenue column, for example, the rows are rearranged according to revenue while the names and dates in those same rows should move with them. A sort is different from filtering: filtering hides records that do not meet a condition, while sorting reorders records.

Choose whether to sort a range or a whole sheet

The right sort scope matters more than the direction. A range sort affects the selected cells, while a sheet sort reorders the worksheet’s rows according to a chosen column. If a table has customer names in A, order dates in B, and amounts in C, select all three columns’ data before sorting by date. Sorting only column B could leave the dates beside the wrong customers and amounts.

Sort a range when the data is a table or a defined block and you want to leave unrelated notes or other tables elsewhere on the sheet alone.
Sort a sheet when the worksheet contains one main table and you want its rows ordered across the sheet.
Sort a filtered table when you want to reorder records while working with a filter or filter view.

If you select one column inside a multi-column table and start sorting, Sheets may ask whether to expand the selection. Choose the option to expand it when the other columns contain information belonging to those same records. Choose to sort only the current selection only when that column is intentionally independent.

Sort a selected range from A to Z

For an ordinary table, use the range-sorting controls so you can specify the key column and tell Sheets whether the first row is a header.

Select the complete data range, including all columns that make up each record. You can include the header row if the range has one.
Open Data > Sort range > Advanced range sorting options.
If the first row contains labels such as Name, Date, or Amount, enable Data has header row.
In the sort controls, choose the column to use as the key and select A to Z for ascending order.
Choose Sort to apply the order to the selected range.

For example, suppose A1:C4 contains a header row and three records: Maya, 2024-03-10, 18; Ana, 2024-01-22, 12; and Lee, 2024-02-14, 15. Sorting the range by the Date column from A to Z puts Ana first, Lee second, and Maya third, with each person’s amount staying on the same row. If the header-row setting is wrong, a label can be treated as a value and end up among the records.

Sort an entire sheet

When a worksheet is devoted to one table, sorting the sheet is a convenient way to keep each row’s values together across the worksheet. Choose Data > Sort sheet, then choose the sort command for the column you want, such as Sort sheet by column A (A to Z). Use the command that matches the actual column and direction. If your sheet has a header, keep it out of the data rows or use the relevant header-aware range-sorting controls instead; a sheet sort can otherwise treat the label as part of the sortable data.

Before using this option, check for other content in the same rows. A note or separate block of information to the right may move along with the sorted rows, even if it is not part of the main table. Conversely, content in separate rows may not belong with the records at all. For mixed-purpose sheets, selecting and sorting the exact table range is usually safer.

Sort by more than one column

A secondary sort key helps when many records have the same value in the main column. For instance, sort a class list by Grade ascending, then by Last name ascending. Students with different grades are grouped in grade order, and names are alphabetized within each grade.

Open Data > Sort range > Advanced range sorting options, set the first sort column to the main key, and choose A to Z. Then use Add another sort column to add the tie-breaker and set its direction. Add more keys if needed, such as department, then last name, then first name. The first key has priority: later keys only order records that tie on earlier keys.

Use the SORT function for a separate sorted result

A menu sort changes the order of the selected source data. If you want the original list to remain as it is and show a sorted copy elsewhere, use Google Sheets’ SORT function. This can be useful for a report or a read-only view that should update when its source changes.

With headers in row 1 and records in A2:C100, where column A is Name and column B is Score, enter =SORT(A2:C100,2,TRUE) in an empty area to return the rows in ascending order by Score. The number 2 means the second column within the supplied range, and TRUE requests ascending order. The result includes all three columns, so each record remains intact. The output needs room to expand; clear any obstructing cells in the destination area. This formula does not sort the source range in place.

To sort by the first column of that same range instead, use =SORT(A2:C100,1,TRUE). These examples omit the header row so the label is not included in the results. If you change the range, check that the sort-column number still points to the intended column within that range. SORT is a Google Sheets function; Excel has a similarly named function in supported versions, but its interface and version availability differ.

Sort while using filters

For a table you inspect repeatedly, create a filter with Data > Create a filter. Filter icons appear in the header row. Open the icon for the column you want and choose Sort A to Z to sort ascending, or the reverse option for descending. The filter also lets you show or hide values without deleting records.

A filter view is useful when you want a particular sort or filter arrangement without changing what other collaborators see in their own view. Use Data > Filter views to create or manage one. A filter is not a substitute for checking the selected range: make sure the filter covers the whole table and that the header row is correctly identified. If you are collaborating, be clear whether you are changing the shared sheet’s order or working in a separate view.

Prepare data and resolve common sorting problems

Sorting can expose inconsistencies in the source data. A date that looks like a date but is stored as text may not sort chronologically with actual date values. Numbers stored as text can also appear in an unexpected position or order. Check the cell format and the underlying values if a sort looks wrong; changing a display format alone does not necessarily convert text into a true date or number.

Header appears in the middle of the list: confirm the header-row setting, or exclude the header from the selected data range.
Names no longer match their details: undo the action immediately if possible, then sort the complete table rather than one column. Google Sheets supports undo through the toolbar or Ctrl+Z on Windows and ChromeOS; on Mac, use Command+Z.
Dates appear out of chronological order: check whether all entries are real date values, not a mixture of dates and date-like text. Also check for inconsistent date formats or locale assumptions.
Some rows are missing from the result: inspect the selected range and any active filters. A filter may hide rows without deleting them, and a range that stops early will not sort data below it.
Equal values seem to move unpredictably: add a second sort key, such as a name or ID column, to make the order within ties explicit.

For cleaner results, keep one record per row, use a single header row, avoid merged cells in the data block, and do not insert blank rows inside the table. These habits make it easier for Sheets to recognize the data as one continuous range and reduce the risk of excluding a record by accident.

Google Sheets and Excel sorting

The basic idea is the same in both spreadsheet programs: select the relevant records, choose a key column, and order it ascending or descending. In Google Sheets, the browser menu paths include Data > Sort range and Data > Sort sheet. In Excel for Microsoft 365 on Windows, sorting commands are on the Data tab in the Sort & Filter group; the dialog and ribbon labels are not identical to Sheets. Do not assume that a Sheets menu instruction or a Sheets-only workflow maps one-to-one to Excel.

Frequently Asked Questions

How do I sort a column alphabetically in Google Sheets?
Select the full table range if the column belongs to records with other data, then use Data > Sort range > Advanced range sorting options. Choose the name column and A to Z. For a filtered table, open that column’s filter menu and choose Sort A to Z.

How do I sort numbers from smallest to largest?
Sort the complete data range by the numeric column and choose A to Z. Google Sheets uses that ascending option for numbers as well as text; it orders numeric values from low to high. If the order looks odd, check whether some numbers are stored as text.

Can I sort without changing the original data?
Yes. Put a SORT formula in an empty area to create an automatically updated sorted result, leaving the source range in place. For example, =SORT(A2:C100,2,TRUE) sorts the rows in A2:C100 by their second column in ascending order.

Why did sorting one column separate my rows?
The sort may have applied only to the selected column rather than the full table. Undo the sort if possible, select all columns that belong to each record, and sort that range by the desired key. Expanding the selection when Sheets prompts you is usually right for a table.

Can I sort by multiple columns?
Yes. In the advanced range-sorting options, choose the primary column and then add another sort column. The primary key determines the broad order; the additional key sorts records that have the same value in the first key.

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.