Skip to main content
Back to path

Welcome to a Grasp lesson

Create a free account to keep studying and create your own study path.

Lesson 5

Sorting Data

Recommended resources

In our last lesson, you learned how to use conditional formatting to make important data visually stand out, such as high-value invoices or overdue payments. While highlighting is great for drawing attention, sometimes you need to completely reorganize your data to analyze it effectively. This is where sorting comes in.

This lesson will teach you how to sort your data in Google Sheets. As a data researcher, you'll constantly need to arrange lists of information—by name, date, priority, or value—to make sense of them. We will cover how to sort your data based on a single criterion, like ordering invoices from highest to lowest amount, and how to apply multiple sorting rules, such as grouping projects by status and then ordering them by due date.

The Foundation of Sorting: Keeping Your Data Intact

Before we jump into the "how," it's crucial to understand one core principle of sorting: you must sort your entire table, not just one column. Each row in your spreadsheet represents a single, complete record (like one invoice with its client, amount, and due date). If you only sort the Amount column, the amounts will be shuffled, but the client names and dates will stay in their original places, completely corrupting your data.

To understand this concept more deeply, let's start with a brief reading.

How to Sort & Filter Spreadsheet Data in Google Sheets

This article from Envato Tuts+ clearly explains why sorting your entire dataset together is so important.

Please read the introduction under the heading "Google Sheets Sort". Focus on the example of a sale being assigned to the wrong customer. Then, continue reading the next section, "How to Sort Data", which reinforces the best practice of highlighting the entire table before you begin.

The Best Practice: Using the "Sort Range" Dialog

While there are several ways to sort in Google Sheets, the most powerful and safest method is the Sort range dialog box. It gives you precise control and helps you avoid common mistakes.

You can access it by first selecting your entire data table and then navigating to the Data menu.

The 'Sort range' option in the Data menu is your primary tool for organizing data.

Let's see how to use it for a simple, single-column sort.

Google Sheets: Sort and Filter Data Tutorial

This video from Technology Central provides a clear, step-by-step demonstration of sorting a range of data.

Watch the video from the beginning to see how to sort alphabetically by name. Pay close attention to two key steps: Selecting all the data first. Checking the "Data has a header row" box. This tells Google Sheets not to include your column titles in the sort. Then, continue watching until the next section to see the same process applied to a numerical column (Age).

Practical Exercise, Part 1: Sort Your Invoices by Amount

Now, let's apply this to your My Freelance Invoices sheet to find your highest-paying projects.

  1. Open your spreadsheet.
  2. Select your entire data table, including the header row (e.g., from cell A3 to the last row and column of your invoice data).
  3. Go to the menu and click Data > Sort range > Advanced range sorting options.
  4. In the pop-up window, make sure the box for "Data has a header row" is checked.
  5. Under "Sort by," select the column header for your invoice amounts (e.g., Amount (USD)).
  6. To see the highest values first, select "Z → A" (descending order).
  7. Click Sort.

Your entire table of invoices should now be reordered, with the highest-value projects at the top. Notice how all the information for each invoice—client, date, status—moved together with the amount.

Multi-Level Sorting: Adding a Secondary Rule

What if you want to organize your data with more nuance? For example, you might want to see all your "Pending" invoices grouped together, and within that group, you want them ordered by their due date. This is called a multi-level sort.

Let's return to the video to see how to add a second sorting rule.

Google Sheets: Sort and Filter Data Tutorial

This part of the video explains how to add a secondary sorting condition.

Watch the segment from this timestamp. Notice how the instructor clicks "Add another sort column" to define a second rule that applies when values in the first column are the same. The order is important: Sheets will "sort by" the first rule, and "then by" the second.

Practical Exercise, Part 2: Sort by Status, Then by Due Date

This is an extremely practical way to manage your workload and follow up on payments.

  1. First, undo your previous sort by pressing Ctrl+Z (or Cmd+Z on Mac).
  2. With your data table still selected, go back to Data > Sort range > Advanced range sorting options.
  3. Set the first rule ("Sort by") to your Status column, and choose "A → Z" (ascending order). This will group your statuses alphabetically (e.g., "Paid," then "Pending").
  4. Click the "Add another sort column" button.
  5. Set the second rule ("Then by") to your Due Date column, and choose "A → Z" (ascending order). This will order dates from oldest to newest.
  6. Click Sort.

You now have a perfectly organized action list. All your pending invoices are grouped together, and within that group, they are ordered by their due date, so you know which one to follow up on first.

A Quick Word on "Sort Sheet" vs. "Sort Range"

You may have noticed other sort options in the menu, like "Sort sheet." Be careful with these. "Sort sheet" will sort your entire sheet based on the column you currently have selected, which can be fast but less precise. The biggest danger comes from accidentally sorting a single column by itself, which messes up your data.

Sorting and Filtering in Google Sheets

This video from Simon Sez IT clearly illustrates the potential danger of sorting a single column without selecting the whole table.

Watch the segment from this timestamp. The presenter demonstrates Sort sheet and then shows what happens when you sort only a highlighted range in a single column. This is a great visual reminder of why using the Advanced range sorting options with your whole table selected is the safest approach for a beginner.

Conclusion

You've now learned a fundamental skill for organizing data. By rearranging rows based on specific criteria, you can quickly identify top performers, prioritize tasks, and prepare your data for further analysis.

Here are your key takeaways:

  • Sorting reorders the rows in your dataset based on the values in one or more columns.
  • Always ensure your entire data records (rows) stay together. The safest method is to select your whole table and use Data > Sort range > Advanced range sorting options.
  • You can perform a single-level sort (e.g., by amount) or a multi-level sort (e.g., by status, then by date) to create more complex views.

So far, we have highlighted data with conditional formatting and rearranged it with sorting. But what if you only want to see a specific subset of your data, like invoices for a single client or only those that are overdue? In our next lesson, we'll cover filtering, which allows you to hide rows you don't need, helping you focus on just the information that matters.