Bird
Raised Fist0
Google Sheetsspreadsheet~5 mins

Sorting (single and multi-column) in Google Sheets - Step-by-Step Guide

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Introduction
Sorting helps you organize your data by putting it in order. You can sort by one column or by several columns to see your data in a way that makes sense to you.
When you want to see your sales list from highest to lowest amount.
When you need to arrange a list of names alphabetically.
When you want to sort a table first by date, then by customer name.
When you want to find the top scores in a test quickly.
When you want to group similar items together in your data.
Steps
Step 1: Select
- the range of cells you want to sort
The cells are highlighted and ready for sorting
Step 2: Click
- Data menu at the top
A dropdown menu appears with sorting options
Step 3: Choose
- "Sort range" option
A dialog box opens to set sorting preferences
Step 4: Check
- "Data has header row" if your selection includes headers
Headers are excluded from sorting and shown at the top
Step 5: Select
- the column to sort by from the dropdown
The column is set as the first sorting key
Step 6: Choose
- Sort order (A → Z or Z → A)
The sorting direction is set for the selected column
Step 7: Click
- "Add another sort column" to sort by more columns
Additional sorting levels appear to set multi-column sorting
Step 8: Set
- the next column and order for sorting
The second sorting key is ready
Step 9: Click
- "Sort" button
The data rearranges according to your sorting choices
Before vs After
Before
A table with unsorted sales data: Names and sales amounts in random order
After
The table sorted first by sales amount from highest to lowest, then by name alphabetically for ties
Settings Reference
Data has header row
📍 Sort range dialog box
To tell Sheets if the first row is a header and should not be sorted
Default: Unchecked
Sort by column
📍 Sort range dialog box dropdown
Select which column to sort the data by
Default: First column in range
Sort order
📍 Sort range dialog box
Choose if the data sorts from smallest to largest or largest to smallest
Default: A → Z
Add another sort column
📍 Sort range dialog box
To sort by more than one column in order
Default: None
Common Mistakes
Not selecting the entire data range before sorting
Only part of the data sorts, causing rows to mismatch and data to become incorrect
Always select all columns and rows of your data before sorting to keep rows intact
Forgetting to check 'Data has header row' when sorting
The header row gets sorted with data, mixing headers with values
Check the 'Data has header row' box if your selection includes headers to keep them at the top
Summary
Sorting arranges your data by one or more columns to make it easier to read and analyze.
You can sort by a single column or add more columns to sort by multiple levels.
Always select the full data range and set header row correctly to avoid mixing data.

Practice

(1/5)
1. What does the SORT function do in Google Sheets?
easy
A. It arranges data in a specified order based on one or more columns.
B. It deletes duplicate rows from the data.
C. It calculates the sum of selected cells.
D. It changes the font style of the selected cells.

Solution

  1. Step 1: Understand the purpose of SORT

    The SORT function is designed to reorder data based on column values.

  2. Step 2: Compare with other options

    Deleting duplicates, summing cells, or changing font are different functions, not sorting.

  3. Final Answer:

    It arranges data in a specified order based on one or more columns. -> Option A

  4. Quick Check:

    SORT = Arrange data order [OK]
Hint: SORT arranges data by columns, not formatting or calculations [OK]
Common Mistakes:
  • Confusing SORT with SUM or formatting functions
  • Thinking SORT deletes data
  • Assuming SORT changes cell styles
2. Which of the following is the correct syntax to sort data in range A2:C10 by the first column in ascending order?
easy
A. =SORT(A2:C10, 1, FALSE)
B. =SORT(A2:C10, TRUE, 1)
C. =SORT(A2:C10, 1, TRUE)
D. =SORT(A2:C10, 2, TRUE)

Solution

  1. Step 1: Recall SORT syntax

    The syntax is SORT(range, sort_column_index, is_ascending).

  2. Step 2: Match syntax to options

    =SORT(A2:C10, 1, TRUE) uses correct order: range A2:C10, column 1, ascending TRUE.

  3. Final Answer:

    =SORT(A2:C10, 1, TRUE) -> Option C

  4. Quick Check:

    SORT(range, column, TRUE) = ascending [OK]
Hint: Remember: SORT(range, column_number, TRUE/FALSE) [OK]
Common Mistakes:
  • Swapping the order of TRUE and column number
  • Using FALSE for ascending order
  • Selecting wrong column index
3. Given the data in A1:B4:
Name | Score
Alice | 85
Bob | 92
Carol | 78
What will be the result of =SORT(A2:B4, 2, FALSE)?
medium
A. Bob 92
Alice 85
Carol 78
B. Carol 78
Alice 85
Bob 92
C. Alice 85
Bob 92
Carol 78
D. Bob 92
Carol 78
Alice 85

Solution

  1. Step 1: Understand sorting by second column descending

    Sorting by column 2 (Score) with FALSE means highest to lowest.

  2. Step 2: Order the scores

    Scores: Bob 92, Alice 85, Carol 78. Sorted descending: 92, 85, 78.

  3. Final Answer:

    Bob 92
    Alice 85
    Carol 78     -> Option A

  4. Quick Check:

    SORT by Score descending = highest first [OK]
Hint: FALSE means descending order, highest values first [OK]
Common Mistakes:
  • Mixing TRUE and FALSE for ascending/descending
  • Sorting by wrong column index
  • Ignoring header row in sorting
4. You want to sort data in A2:C10 first by column 2 ascending, then by column 3 descending. Which formula fixes the error in this incorrect formula?
=SORT(A2:C10, 2, TRUE, 3)
medium
A. =SORT(A2:C10, 3, TRUE, 2, FALSE)
B. =SORT(A2:C10, 2, TRUE, 3, FALSE)
C. =SORT(A2:C10, 3, FALSE, 2, TRUE)
D. =SORT(A2:C10, 2, TRUE, 3, TRUE)

Solution

  1. Step 1: Identify correct multi-column SORT syntax

    Multi-column SORT needs pairs: column index and TRUE/FALSE for each.

  2. Step 2: Fix missing TRUE/FALSE for second column

    The original formula misses the order for column 3. =SORT(A2:C10, 2, TRUE, 3, FALSE) adds FALSE for descending.

  3. Final Answer:

    =SORT(A2:C10, 2, TRUE, 3, FALSE) -> Option B

  4. Quick Check:

    Multi-column SORT needs column and order pairs [OK]
Hint: Always pair column number with TRUE/FALSE in SORT [OK]
Common Mistakes:
  • Omitting TRUE/FALSE for each sort column
  • Swapping column order and sort order
  • Using wrong TRUE/FALSE for desired order
5. You have a list of employees with columns: Name (A), Department (B), and Salary (C). You want to sort the list first by Department ascending, then by Salary descending. Which formula correctly sorts this data in range A2:C100?
hard
A. =SORT(A2:C100, 1, TRUE, 3, FALSE)
B. =SORT(A2:C100, 3, FALSE, 2, TRUE)
C. =SORT(A2:C100, 2, FALSE, 3, TRUE)
D. =SORT(A2:C100, 2, TRUE, 3, FALSE)

Solution

  1. Step 1: Identify sorting order for each column

    Department (column 2) ascending = TRUE; Salary (column 3) descending = FALSE.

  2. Step 2: Match formula with correct column and order pairs

    =SORT(A2:C100, 2, TRUE, 3, FALSE) matches: column 2 TRUE, column 3 FALSE.

  3. Final Answer:

    =SORT(A2:C100, 2, TRUE, 3, FALSE) -> Option D

  4. Quick Check:

    Sort by Dept ascending, Salary descending = =SORT(A2:C100, 2, TRUE, 3, FALSE) [OK]
Hint: Sort by main column ascending, then secondary descending [OK]
Common Mistakes:
  • Reversing sort order for columns
  • Sorting by wrong column numbers
  • Using inconsistent TRUE/FALSE values
Recommended

Ready to prove it?

Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

10 questions~5 mineasy hard