📊 Lesson 3.1: Sorting, Filtering & Filter Views

Why Raw Data Needs Wrangling

Imagine a shoebox of receipts. Every receipt is real and correct, but as a pile it tells you nothing. What did you spend the most on? Which purchases happened last week? Which were over fifty dollars? To answer any of those, you don't change the receipts — you arrange them: stack them by amount, pull out just the ones from last week, set the small ones aside. The receipts never change; only your view of them does.

That's exactly what sorting and filtering are. Your data sits in the grid as the honest, complete record — the raw data. Sorting reorders it so patterns surface; filtering hides rows that don't match a question so you can focus. Neither one adds, deletes, or edits your actual numbers. They're the Views layer of our Cells → Formulas → Views model, sitting on top of the cells without touching them.

Why does this matter so much? Because the whole point of a spreadsheet is that it's a living model. The moment you start hand-editing data to make a view work, you break the model — your totals stop matching reality, and you can't trust the sheet anymore. Sorting and filtering exist precisely so you never have to do that. Learn them well and you'll answer questions in seconds that used to mean rewriting the whole table.

Sorting: Range vs Sheet, Single vs Multi-Column

Sorting reorders rows based on the values in one or more columns — smallest to largest, A to Z, oldest to newest, and their reverses. Google Sheets gives you two doorways to it, and the difference between them is the number-one thing that trips beginners up.

Sort sheet vs sort range

You'll find both under the Data menu (as "Sort sheet" and "Sort range"), and you can also right-click a selection to reach the sort options. A quick A → Z or Z → A sorts by whichever column your selection is in; opening Data ▸ Sort range ▸ Advanced range sorting options lets you pick the exact column and add more.

⚠️ Important Note — the "data has header row" gotcha: The classic disaster is sorting your table and watching your header row ("Date", "Category", "Amount") get shuffled down into the data as if it were just more rows. Whenever you sort, look for the "Data has header row" checkbox and tick it. That tells Sheets to hold the top row still and sort only the rows beneath it. If your headers ever do get sorted in, don't panic — press Ctrl+Z (or Cmd+Z) to undo and try again with the box checked.

Single-column vs multi-column sort

A single-column sort answers one question: put the biggest expense on top, or the newest task first. A multi-column sort breaks ties. Say you sort tasks by Priority — you get all the "High" ones together, but in what order within High? Add a second sort column, like Due Date, and Sheets sorts by Priority first, then by Due Date inside each priority group. The first column is the primary sort; each column you add below it only decides ties left by the ones above.

In the advanced sort dialog you literally stack the rules: "Sort by Category A → Z, then by Amount Z → A" gives you your expenses grouped by category with the biggest spend first inside each group — a genuinely useful arrangement you'll reach for constantly.

Filters: By Condition and By Values

Where sorting rearranges every row, a filter temporarily hides the rows that don't match your question, leaving the matching ones on screen. Turn it on from Data ▸ Create a filter (or the little funnel icon on the toolbar), and a small funnel button appears in each header cell. Click a funnel and you get two ways to narrow the rows.

Filter by values

This shows a checklist of every distinct entry in that column. Uncheck the ones you don't want, or use "Clear" then check only the few you do. Filtering the Category column to just "Groceries" and "Dining" instantly hides every other row. It's perfect when you're picking from a known set of labels.

Filter by condition

This applies a rule instead of a checklist — for example "Amount is greater than 50", "Date is after a chosen day", "Text contains 'coffee'", or "Cell is not empty". Conditions shine for numbers and dates, where listing every value would be silly. Choose a condition from the dropdown, type the value, and only rows that satisfy the rule stay visible.

Hiding rows vs filtering — not the same thing

Beginners often "hide" rows (right-click ▸ Hide row) to get them out of the way and think they've filtered. They're different tools with different consequences:

To remove a plain filter and show all rows again, go to Data ▸ Remove filter (or click the funnel toolbar button off). "Clearing" an individual column's filter (re-checking all its values or resetting its condition) is different — that just widens that one column's rule while the filter stays on.

Filter Views: Slicing Without Disturbing Anyone

A Filter View is the collaborator-friendly answer to everything above. It's a saved, named sort-and-filter that lives on the sheet but only changes your screen while it's active. Your teammates keep seeing the full data (or their own view) undisturbed. Think of it as putting on a pair of tinted glasses: the world doesn't change color, only your view of it does.

Why they matter with collaborators

On any sheet more than one person touches, Filter Views are the default professional choice. Everyone can have their own — "Alex's overdue tasks," "Q3 only," "Expenses over 50" — and switch between them freely without stepping on each other. You can even save multiple views for yourself and jump between them like saved searches. Because each has a name, they're reusable: set the slice up once, and return to it any day with one click.

Creating, saving, and switching

Open Data ▸ Create filter view (sometimes shown as "Filter views ▸ Create new filter view"). The grid gets a dark border and a colored bar across the top — that border is your signal that you are inside a Filter View and nothing you do here disturbs the shared sheet. Now:

1. Set your sort and filters exactly as you learned above — funnels, conditions, value checklists.
2. Give the view a clear name in the top bar (for example, "Expenses over 50"). It saves automatically.
3. Close the view with the ✕ on the bar to return to the normal sheet. Your data is untouched and everyone else saw nothing change.
4. Reopen or switch views any time from Data ▸ Filter views, where all saved views are listed by name.

⚠️ Important Note: A Filter View lets you view the data your way, but if you edit a cell while a view is active, that edit still changes the real underlying data for everyone — the view only controls sorting and which rows are hidden, not whether your edits are private. If you need to stop others changing the data at all, that's protection, which we touch on in Lesson 3.3. Viewers with only "view" access can even create temporary filter views without any edit rights — handy for read-only teammates.

Converting a Range to a Table

Google has been rolling out a newer feature called Tables (Format ▸ Convert to table, or an offer that pops up on well-structured data). It takes a plain range and promotes it to a first-class object: the header row is locked in, each column gets a defined type (text, number, date, dropdown, and so on), and tidy formatting and built-in filter controls come along automatically.

Why bother? A Table bundles up several habits you'd otherwise set up by hand:

• Header row handled for you — no more "data has header row" worries; the table knows.
• Column types — set a column to Date or Dropdown once and every entry is guided and consistent, which foreshadows data validation in the very next lesson.
• Built-in sort and filter menus right on the table, plus quick "group by" style views.
• References by name — formulas can point at the table and its columns by name, which reads far more clearly than A2:A100.

The honest takeaway: sorting, filtering, and Filter Views are the durable, universal skills — they work everywhere and always. Tables are a newer convenience layer that packages good structure for you. Learn the fundamentals first, then adopt Tables when they fit and when the feature has settled on your account.

🎯 Project: Sort, Filter, Save a View

Time to wrangle a real dataset. You'll build a small expense table, sort it, filter it to answer a question, and then save a Filter View so your slice never disturbs a hypothetical collaborator. This is the exact workflow you'll use on real shared sheets for the rest of your life.

Date        Category     Description          Amount
2026-09-01  Groceries    Weekly shop          82.40
2026-09-02  Dining       Coffee with Sam       6.75
2026-09-03  Transport    Bus pass             48.00
2026-09-04  Groceries    Farmers market       31.10
2026-09-05  Utilities    Internet bill        59.99
2026-09-06  Dining       Pizza night          27.50
2026-09-07  Shopping     New headphones      120.00
2026-09-08  Transport    Rideshare            18.25
2026-09-09  Groceries    Midweek top-up       22.85
2026-09-10  Health       Pharmacy             14.30
2026-09-11  Utilities    Phone bill           45.00
2026-09-12  Dining       Lunch out            16.90
2026-09-13  Shopping     Running shoes        89.99
2026-09-14  Groceries    Big monthly stock   134.60
2026-09-15  Health       Gym day pass         12.00
2026-09-16  Transport    Fuel                 61.40

Best Practices for Sorting & Filtering

✅ Do's

• Keep one clean, complete table of raw data and treat every sort and filter as a lens on top of it.
• Always check "Data has header row" when sorting a table with headers.
• Use Filter Views on any shared sheet so your slicing never disrupts collaborators.
• Add an ID column before big sorts if the original order might matter later.

❌ Don'ts

• Don't delete or retype rows to "filter." That destroys the raw data and breaks every formula that depends on it.
• Don't confuse hiding rows with filtering. Hiding is manual and doesn't update; filtering follows a rule.
• Don't use a plain filter on a busy shared sheet and wonder why teammates complain their rows keep vanishing.

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

You took a raw pile of rows and made it answer questions — sorted it to surface the biggest expenses, filtered it to find everything over 50, and saved a named Filter View that respects the people you share with. That's the core data-wrangling loop, and you'll use it on almost every real sheet you ever build.

❓ Common Questions at This Stage

🔭 Looking Ahead

In the next lesson — Lesson 3.2: Data Validation & Dropdowns — we move from arranging data to protecting it at the point of entry. You'll add dropdown menus and rules that reject bad input, so your categories stay consistent and your future sorts, filters, and pivots have clean data to work with.

✅ Before the Next Lesson

• Keep your 16-row expense sheet — you'll build on this kind of dataset next
• Make sure your saved Filter View reopens correctly from Data ▸ Filter views
• Write your Learning Journal entry for this lesson

📚 Additional Resources

• Sort & filter your data (Google Support)
• Google Sheets Help Center — full topic list
• sheets.google.com — open the app