Updated: November 17, 2026

If you need to sort in Google Sheets, the fastest path is to sort one column, a whole range, or an entire sheet without breaking the rest of your data. The key is knowing when to sort a selected range and when to use a filter so names, dates, values, and related rows stay aligned. Once you know the difference, sorting becomes a two click task instead of a cleanup job.

Sort a single column or an entire range

The simplest way to sort data in Google Sheets is to select the range you want sorted and use the built in sort options. This works best when your data has headers like Name, Date, or Amount and every row belongs together. If you sort only one column without including the full range, the rows can get mismatched.

  1. Click and drag to select the full data range, including all columns tied to each row.
  2. Open Data in the top menu.
  3. Choose Sort range.
  4. Check Data has header row if your first row contains labels.
  5. Choose the column you want to sort by.
  6. Pick A to Z for ascending order or Z to A for descending order.

This is the standard method for how to sort in Google Sheets by column, by value, or by name. If you want how to sort sheet in Google Sheets without changing the layout, always select the full dataset first.

Sort alphabetically, chronologically, or by value

Google Sheets sorts text, dates, and numbers using the same menu, but the result depends on the column type. For alphabetic sorting, text goes from A to Z. For chronological sorting, dates go from oldest to newest or newest to oldest. For values, numbers sort from smallest to largest or the reverse.

How to sort Google Sheets alphabetically

For names, titles, cities, or any text column, use an ascending sort. That gives you alphabetical order from A to Z. If you need the reverse, use descending order to sort Z to A. This answers how to sort Google Sheets alphabetically and how to sort names in Google Sheets at the same time.

How to sort Google Sheets chronologically

For dates, select the date column and sort from oldest to newest to create a timeline. Use newest to oldest when you want the most recent items at the top, such as recent invoices, posts, or tasks. If the dates do not sort correctly, the cells are stored as text, not true dates, and you need to convert them first.

How to sort Google Sheets by value

For prices, scores, quantities, or totals, sort the numeric column directly. Smallest to largest is the default ascending result. Largest to smallest is the reverse and is useful for ranking sales, grades, or inventory counts. This is the cleanest way to sort data Google Sheets when numbers drive the order.

Sort names, people, and lists by one column

If you want how to sort Google Sheets by name, use the column that contains the names and keep the rest of the row attached to it. This is the right method for contact lists, rosters, mailing lists, and customer records. Sorting only the name column by itself rearranges names without matching the other data, which creates errors.

Sort by first name or last name

If first and last names are in separate columns, choose the column you want to control the order. Sort by first name if the list is casual. Sort by last name if you are managing a formal roster, directory, or class list. If full names are in one column, Sheets sorts by the first character it finds, so the list is ordered by first name unless you split the names into separate columns.

Sort one list without disturbing the rest of the sheet

If your sheet has notes, summaries, or unrelated content below the table, select only the range you want sorted. Do not click the full sheet unless every row and column belongs to the same dataset. This is the safest answer to how to sort on Google Sheets when the page contains more than one table.

Sort by column using filters and sorting on Google Sheets

Filters are the best way to sort a table that you expect to re order again later. They let you sort by one column, switch columns, and keep the sort available without reopening the menu every time. This is useful for dashboards, project trackers, and shared spreadsheets.

  1. Select the header row and the data beneath it, or click inside the table.
  2. Open Data.
  3. Choose Create a filter.
  4. Click the filter icon in the header of the column you want to sort.
  5. Choose Sort A to Z or Sort Z to A.

This method covers how to use sort in Google Sheets and how to add sorting to Google Sheets when you need repeatable control. It also makes sorting on Google Sheets faster because the sort button stays attached to the header row.

Sort by multiple columns

Use a multi column sort when one sort key is not enough. For example, you can sort by department first and then by employee name, or by status first and then by due date. This keeps groups together while still ordering the rows inside each group.

  1. Select the full data range.
  2. Open Data and choose Sort range.
  3. Check Data has header row if needed.
  4. Choose the first sort column and set the order.
  5. If the advanced sort options appear, add a second sort column and order.

This is the right answer for how to sort things in Google Sheets when the sheet contains categories, teams, or repeated names. It also prevents the common problem where a primary sort mixes together rows that need a second level of order.

How to undo sort in Google Sheets, remove sorting, or reset sorting

There is no true permanent unsort button for a manual sort in Google Sheets. If you sort a range and want the original order back, the simplest path is to use Undo immediately. If you already moved on, you need a saved order column or version history to restore the earlier arrangement.

Undo a sort right away

Press Ctrl+Z on Windows or Command+Z on Mac, or choose Edit then Undo. This reverses the last sort action if nothing else has changed since then. That is the correct fix for how to undo sort in Google Sheets and how to undo a sort in Google Sheets right after it happens.

Remove sort in Google Sheets

If you created a filter sort, click the filter icon again and sort the column in the opposite direction, or remove the filter from Data if you no longer want the table sorted through the filter tools. If you want to remove sort in Google Sheets after a manual sort, there is no one click reset unless you preserved the original order in another column.

Reset sorting in Google Sheets

The best way to reset sorting in Google Sheets is to add a helper column before sorting. Put 1, 2, 3, and so on down the side, then sort by other columns as needed. If you want the original order back, sort by the helper column. This is the only reliable way to fully restore a prior sequence after multiple sorts.

Fix common sorting problems

Most sorting mistakes come from selecting the wrong range, using the wrong data type, or sorting one column without the rest of the row. If names, dates, or numbers land in the wrong order, the issue is usually in the data, not the sort command.

Dates sort as text

If chronological sorting fails, the cells are stored as text. Convert them to real dates before sorting. A date that looks right on screen can still behave like text if it was pasted from another source or entered in an unusual format. Once the dates are real date values, Google Sheets sorts them correctly.

Rows break apart after sorting

This happens when only one column is selected. Always select the entire table, not just the column you want to reorder. That keeps each name, date, and value on the same row. If the table has headers, include them and mark them as a header row when the sort dialog asks.

Alphabetical order looks wrong

If names are sorting oddly, check for leading spaces, numbers, or mixed formatting. A space before a word can move it above other entries. Numbers in a text column sort before letters. Cleaning the data before sorting gives you the expected A to Z result.

Frequently Asked Questions

How do I sort in Google Sheets by column?

Select the full range, open Data, choose Sort range, and pick the column you want. Then choose ascending or descending order. This keeps the row data together while sorting by the chosen column.

How do I sort Google Sheets by name?

Select the table, then sort the name column from A to Z. If names are split into first and last name columns, choose the exact column you want to control the order. For full names in one column, Sheets sorts by the first word it reads.

How do I sort Google Sheets chronologically?

Sort the date column from oldest to newest or newest to oldest. If the dates do not behave correctly, convert them to real date values first. Text that looks like a date will not sort as a true date.

How do I remove sorting in Google Sheets?

Use Undo right after the sort if possible. For filter based sorting, remove or change the filter. If the original order is gone, restore it from a helper column or version history.

How do I sort in Excel Google Sheets style?

Google Sheets uses the same basic logic as Excel, select the range, sort by a column, and keep rows together. The menu labels differ a little, but the process is the same for basic alphabetical, numeric, and date sorting.