Excel Tutorials
Filter your data by value, text or number condition in under a minute, then clear it just as fast. This lesson uses the Order Manager workbook from Excel Foundations, free to download below.
Follow along in the same file used in the video. No email required.
Filtering is a built-in Excel tool that temporarily hides any row that doesn't match the criteria you set, so you're only looking at the data that actually matters right now. Nothing gets deleted or changed; filtered rows are just tucked out of view until you clear the filter.
It's the fastest way to answer a specific question buried in a big sheet, like "which orders are still pending" or "what did we order from this one vendor," without building a separate report or writing a formula.
Step-by-step, matching the video above.
Click anywhere inside your data range, or select the header row plus the rows below it. Excel only filters the range it can see, so make sure there are no blank rows splitting your data in two.
Go to the Data tab on the ribbon and click Filter. A small dropdown arrow appears in every column header.
Click the dropdown arrow on any column. You'll see every unique value in that column with a checkbox next to it, uncheck whatever you want hidden and click OK. This is the fastest option when you're filtering a short list, like order status or vendor name.
On a text column, hover over Text Filters in the dropdown to see options like Contains, Begins With, Ends With and Equals. Handy when you're searching for a partial match, like every vendor name containing "Supply."
On a numeric column, hover over Number Filters for conditions like Greater Than, Less Than and Between. For example, filter your quantity column to show only orders above a certain amount.
On a date column, Date Filters lets you filter by Before, After, Between, or by a relative range like This Month or This Year, without typing exact dates.
Repeat any of the steps above on another column and both filters apply together. For example, filter Status for "Pending" and Vendor for one supplier at the same time to narrow results from two directions at once.
If a column has empty cells mixed in, uncheck (Blanks) in its dropdown to hide them. To isolate one specific value, like a single order number, use Text Filters > Equals and type it in directly rather than scrolling a long checkbox list.
Click the dropdown arrow and select Clear Filter, or go to the Data tab and click Clear to remove every filter on the sheet at once. Your data is never deleted, filtering only hides rows.
The regular Filter dropdown covers most needs, but Advanced Filter lets you filter on more complex logic, like "Vendor is Acme AND Quantity is over 50, OR Status is Overdue", and it can copy the results to a new location instead of just hiding rows in place.
Above your data, copy the column headers you want to filter on into a blank area, then type your conditions in the cells below them. Conditions in the same row are treated as AND, conditions in different rows are treated as OR.
Click inside your data, go to the Data tab, and click Advanced in the Sort & Filter group.
In the dialog, set the List range to your data and the Criteria range to the headers and conditions you just built, then click OK.
Advanced Filter can hide non-matching rows right where your data is, or copy just the matches to a different location, useful when you want a clean extract without touching the original data.
The basic idea is identical, but Sheets splits filtering into two distinct tools that Excel doesn't separate.
Works like Excel's Filter, dropdown arrows on each header, but it changes what everyone viewing the sheet sees, since it's a property of the sheet itself.
A personal filter only you see, saved and named so you can switch between different views of the same data without affecting anyone else looking at the sheet at the same time.
If you send a filtered sheet to someone else, they may not notice rows are hidden and assume the data is missing. Clear the filter, or add a note, before sharing.
A regular SUM formula totals every row, including ones hidden by a filter. If you want a total that updates with your filter, use SUBTOTAL or AGGREGATE instead.
A merged cell only "belongs" to its first row, so filtering or sorting a range with merged cells often moves or hides data in ways you didn't expect. Unmerge before you filter.
Advanced Filter treats a blank row in the criteria range as "match everything," which silently cancels out conditions above it. Keep the criteria range tight, with no stray blank rows.
Every filter has a purpose. Updoot skips straight to it.
Free 14-day trial. No credit card required.
Select your data range, go to the Data tab and click Filter. Dropdown arrows appear on each column header. Click any arrow to filter by value, text or number condition.
Click the dropdown arrow on the filtered column and select Clear Filter, or go to the Data tab and click Clear to remove all filters at once.
Yes. Filters apply per column and stack together, so you can filter Column A and Column B at the same time to narrow results further.
No. Filtering only hides rows that don't match your criteria, it doesn't delete or change any data. Clearing the filter brings every row back.
Yes. Select your data and press Ctrl+Shift+L to turn Filter on or off, without going through the Data tab.
Yes. Click the dropdown arrow on a column, choose Filter by Color, and pick the fill or font color you want to isolate.
Mostly. Google Sheets has two versions: a regular Filter that changes what everyone viewing the sheet sees, and a Filter View that only changes what you personally see, which Excel doesn't have.
This usually means your data range wasn't fully selected, often because of a blank row or column splitting it. Select the full range, including headers, before turning Filter on.
Advanced Filter, found on the Data tab, lets you filter using more complex AND/OR logic defined in a separate criteria range, and can copy the matching results to a new location instead of just hiding rows in place.
A regular Filter changes what everyone viewing the sheet sees. A Filter View is a personal, saved filter that only you see, without affecting anyone else looking at the sheet.
Every business starts with a spreadsheet. Updoot is where you scale past it, with real purchasing, approval and reorder workflows built in.
Start Your Free Trial →