Updated: November 19, 2026

If you need Google Sheets how to sort by multiple columns, the key is to sort the full range, not just one column. That keeps each row intact while you rank the data first by one field and then by another, such as sorting by department and then by name, or by date and then by score. Once you know where the sort range starts, the process is quick and repeatable.

Sort data with the built-in multi column sort

The built-in sort tool is the fastest way to sort data by multiple columns in Google Sheets. Use it when you want a permanent rearrangement of rows in a table, not a temporary view.

  1. Click any cell inside your data range.
  2. Go to Data, then choose Sort range.
  3. If your table has headers, check Data has header row.
  4. Choose the first column to sort by, then pick A to Z or Z to A.
  5. Select Add another sort column.
  6. Choose the second column and its sort order.
  7. Repeat for any additional columns, then apply the sort.

This answers the common need to sort by more than one column in Google Sheets. The first sort key decides the main order, and the second key breaks ties within that group.

Use single column sort when one field is enough

If you only need a basic Google Sheets single column sort, you can sort one column without adding extra rules. That is useful for names, dates, prices, or any list where a second sort key is not needed.

How to sort a column without breaking the table

Do not click only the column header and sort that one column by itself unless you want the rest of the row to stay put. That breaks matching data. Instead, select the full table, then sort by the target column so every row moves together.

For a clean Google Sheets sort by column result, use the full data range and keep the header row out of the sort order. This is the safest way to sort a column while preserving related values in adjacent columns.

Sort by multiple columns with the SORT function

Use the SORT function when you want a formula based result that stays in a new location and updates when the source data changes. This is the best option for a dynamic sorted view, and it handles Google Sheets sort function multiple columns cleanly.

Basic formula for ascending order

The formula pattern is:

=SORT(range, sort_column1, TRUE, sort_column2, TRUE)

Use TRUE for ascending order and FALSE for descending order. For example, if your data is in A2:D100, and you want to sort first by column A, then by column C, the formula is:

=SORT(A2:D100, 1, TRUE, 3, TRUE)

This is the direct answer to Google Sheets formula ascending order and Google Sheets sort ascending. Change the column numbers and sort direction to match your data.

Sort in descending and mixed order

You can mix sort directions in one formula. If you want dates ascending but scores descending, use TRUE for the date column and FALSE for the score column. This is useful for reports, leaderboards, and task lists where the main category stays ordered one way and the secondary ranking reverses.

When you need Google Sheets sort on multiple columns with a formula, SORT is the cleanest option because it does not require manual resorting after every edit.

Use QUERY for a sorted result you can filter later

The QUERY function works when you want SQL style sorting and possibly more control over the displayed data. It is a good fit for Google Sheets query sort ascending requests, especially when the sorted result is part of a larger report.

Example with ascending order

Use a query like this:

=QUERY(A1:D100, “select A, B, C, D order by A asc, C asc”, 1)

This sorts first by column A and then by column C, both ascending. If you want descending on the second field, use desc for that column. QUERY is useful when you need to sort data and display only selected columns at the same time.

When QUERY is better than SORT

Use QUERY if you want a formula driven report with order by rules, filtering, and selected columns in one place. Use SORT if you just want a sorted copy of the same data. For most spreadsheet cleanup tasks, SORT is faster. For dashboards and report tabs, QUERY gives more control.

Fix Google Sheets not sorting correctly

If Google Sheets is not sorting correctly, the problem is usually the range, the header row, or mixed data types. A sort that looks wrong almost always comes from one of those three issues.

Check the range first

Make sure the entire table is selected before sorting. If only one column is included, rows separate from their matching data. If blank rows split the dataset, Sheets can treat the table as multiple blocks. Remove accidental blank rows before sorting.

Check numbers stored as text

If Google Sheets is not sorting numbers correctly, the values are likely stored as text. That makes 100 appear before 20 in an alphabetical sort. Convert text numbers to real numbers, remove leading apostrophes, and format the column as a number or plain number. Once the values are numeric, Google Sheets sort ascending works as expected.

Check for inconsistent formatting

Date columns with mixed text dates and real dates sort badly. Keep one data type per column. If a column should sort by date, make sure every value is a real date, not typed text. The same rule applies to currencies and percentages.

Keep data sorted as it changes

If you want Google Sheets keep data sorted without redoing the sort every day, use a formula on a separate sheet or in a separate area. That way the source data stays untouched and the sorted view updates on its own.

  • Use SORT for a live sorted list.
  • Use QUERY for a live sorted report with filtering.
  • Keep raw data on one tab and sorted output on another tab.
  • Use headers in row 1, then start data in row 2 for easier formulas.

This approach is the cleanest way to handle Google Sheets sorting columns when the source table changes every day. It also avoids accidental edits to the original dataset.

Frequently Asked Questions

How do I sort Google Sheets by multiple columns?

Select the full range, open Data then Sort range, enable the header row if needed, choose the first sort column, then add another sort column and choose its order. The first column sets the primary order, and the next columns break ties.

How do I sort Google Sheets by column?

Select the whole table, then sort the range by the column you want. Do not sort only one column unless you want the rows to stop matching. For a single column sort, keep the full data range selected so the row data stays together.

What is the formula for sorting multiple columns in Google Sheets?

Use =SORT(range, sort_column1, TRUE, sort_column2, TRUE) for ascending order, or change TRUE to FALSE for descending order. For example, =SORT(A2:D100, 1, TRUE, 3, TRUE) sorts by the first and third columns ascending.

Why is Google Sheets not sorting numbers correctly?

The numbers are stored as text, so Sheets sorts them alphabetically instead of numerically. Convert the values to real numbers, then apply the sort again. Dates and currencies need the same treatment if they are mixed with text entries.

Can I sort by more than two columns?

Yes. In the sort range dialog, keep adding sort columns. In formulas, add more sort pairs to SORT, or add more fields to the QUERY order by clause. Each added column gives you a deeper tie breaker for the rows.