How to Filter Within a Filter in Excel

Formulas & functions · Updated November 20, 2026

To filter within an existing Excel filter, leave the first filter in place and apply another filter from a different column’s drop-down; Excel shows only rows that meet both conditions. For example, filter a sales list to show the West region, then filter the same results to show orders marked Shipped. You can also refine one column with a second condition. These steps are for Excel for Microsoft 365 on Windows.

What You’ll Need

  • A worksheet with one header row and a column for each field you may want to filter, such as Region, Status, or Date.
  • A data range with no completely blank rows or columns breaking it into separate sections. Converting the range to an Excel table is helpful but not required.
  • A saved copy of the workbook if the data is important. Filtering hides rows; it does not delete them, but saving a copy is a sensible precaution before making broader changes.

Step-by-Step

  1. Check the data layout. Make sure each column has a clear, unique header and that records occupy one row apiece. Avoid merged cells in the header. If a title or notes sit directly above the data, select only the actual header and records when turning on filters so Excel does not mistake the title for a field name.
  2. Turn on filter arrows if they are not already visible. Click a cell in the data range and choose Data > Filter. Excel adds a drop-down arrow to each header. If you have already filtered one column, do not turn the filters off; move on to the next step. If your data is an Excel table, its header row normally already has filter arrows.
  3. Apply your first condition. Open the arrow in the column that contains the first condition. For a list of categories, clear (Select All), tick the value or values you want, and select OK. For example, in a Region column, select West. For dates or numbers, use the relevant options under Date Filters or Number Filters. The worksheet now shows only matching rows, while the other records remain in the workbook but are hidden.
  4. Apply a second filter to the displayed results. Open the arrow in another column without clearing the first filter. Choose the next value or condition, then select OK. For example, after filtering Region to West, filter Status to Shipped. The visible rows must match both conditions: Region is West and Status is Shipped. This is the usual meaning of filtering within a filter.
  5. Continue adding conditions as needed. Repeat the previous step for additional columns, such as Salesperson, Product, or Order Date. Each extra column filter narrows the visible list further. If a later condition produces no visible rows, that means no records in the current filtered set meet all the selected conditions; it does not necessarily mean the workbook has no matching records at all.
  6. Refine a condition in the same column. Open that column’s arrow again. For a checklist filter, adjust which values are selected, then choose OK; the new selection replaces the prior checklist selection for that column. To combine two rules on one text, number, or date field, open the column arrow and choose the appropriate option under Text Filters, Number Filters, or Date Filters. Select a rule such as Custom Filter if shown, choose the comparison conditions, and use And or Or to set how they relate.
  7. Use And and Or correctly for two rules in one field. And means a record must meet both rules. For example, a date must be on or after January 1 and on or before March 31 to show the first quarter. Or means either rule is enough, such as a status being Pending or Backordered. The choices and labels in the custom-filter dialog can vary by field type, so check that the operators match what you intend.
  8. Review the filtered result. Look for the filter symbol in each header that has an active condition. Check a few visible rows against your criteria, and check the status bar or row numbers to confirm that rows are hidden rather than removed. To change one condition, use that column’s arrow; you usually do not need to restart the whole process.
  9. Remove one filter or restore all rows. To clear just one column’s condition, open its arrow and choose Clear Filter From [Column Name], or use the corresponding clear option in that menu. Other column filters remain active, so the result may still be limited. To remove all active filters together, choose Data > Clear. This clears the criteria and displays the full range; it does not erase data.

If you are starting with a plain range and expect to filter it regularly, you can make it a table first: select a cell in the data and choose Insert > Table, confirm the range, and make sure My table has headers is selected. Tables include filter arrows and expand more reliably when you add rows. On Excel for Mac, the ribbon commands are also under Data and Insert, though the layout and dialog wording can vary slightly. In Excel for the web, use the Data tab and the header arrows; some desktop dialog details may look different.

Common Mistakes

  • Clearing the first filter by mistake. Choosing Data > Clear removes all active filter criteria, not just the one you are currently working on. To keep other conditions, clear or change the specific column from its own drop-down.
  • Assuming another filter adds rows. Filters across columns work as an intersection: each additional condition narrows the visible results. If you need records from either of two different regions, select both region values in the Region checklist rather than filtering one region and expecting a second column to add alternatives.
  • Using And when you mean Or. A value cannot usually be both equal to North and equal to South at the same time. For alternative values in one field, select both values in the checklist or use an Or condition in the custom filter.
  • Leaving an item selected unintentionally. If you mean to choose only a few checklist values, clear (Select All) first. Then tick the intended values and verify the selection before pressing OK.
  • Filtering an incomplete range. Blank rows or columns can cause Excel to treat adjacent data as separate ranges. A filter may then omit records that appear to belong to the list. Use a continuous range or convert it to a table.
  • Thinking filtered rows were deleted. AutoFilter hides nonmatching rows. Do not copy, delete, or edit rows on the assumption that a filtered view contains the entire dataset; first check which rows are visible and what operation you are performing.

Tips

  • Use a table for data that grows. A table is a practical choice for lists that receive new records. When you add rows immediately below it, the table can expand and keep its formatting and filter controls with the data.
  • Use the search box for long lists. In a header’s filter menu, type part of a value in the search box to find matching checklist entries. Confirm the desired boxes are selected before choosing OK; searching is a way to find values, not a separate permanent filter condition.
  • Keep field types consistent. Store dates as real Excel dates and numbers as numbers, rather than mixing them with text entries. Consistent values make the date and number filter options more useful and reduce surprising results.
  • Make the criteria explicit. Before applying several filters, write down the intended logic in plain language, such as West region, shipped status, and order date in March. This makes it easier to notice whether a condition was applied to the wrong column.
  • Clear conditions selectively. When checking a different scenario, remove only the condition you want to change. This preserves other useful filters and makes comparisons quicker.

Troubleshooting

  • No filter arrows appear: Click inside the data and choose Data > Filter. If the command does not cover all records, select the complete range, including the header row, before applying it. Check for blank rows that divide the data.
  • No rows remain after the second filter: Open the arrows for each filtered column and review the selected values and conditions. One condition may be too restrictive, the values may not match exactly, or the records may not meet every condition together. Clear one criterion at a time to find which combination removes the rows.
  • A value you expect is missing from the checklist: Check for leading or trailing spaces, spelling differences, or values stored with different types, such as a number stored as text. Also confirm that the record is inside the filtered range. Correct the source value or expand the range, then reopen the filter menu.
  • The filter shows unexpected text or date results: Check whether the column mixes data types or contains inconsistent date formats. A date-looking entry stored as text may not behave like a true Excel date. Correct the source data and reapply the filter.
  • Some records seem unaffected: Confirm the filter range includes every row and column, and that the header row is correctly identified. If rows were added outside a table or range after filtering began, extend the table or select the full range and apply the filter again.
  • You cannot see all records after clearing one column: Other columns may still have active filters. Look for filter icons in the other headers and clear those conditions individually, or choose Data > Clear to restore the whole list.

Frequently Asked Questions

Can I apply more than two filters in Excel?
Yes. You can apply conditions in multiple columns, and the visible records must meet the active conditions together. Add another condition from the relevant header arrow.

Can I filter the same column twice?
You can refine one column using its checklist or combine two comparison rules in its custom-filter options. A second checklist selection replaces the earlier selection for that column; it does not create a separate independent filter layer.

Does filtering within a filter delete hidden rows?
No. AutoFilter hides rows that do not meet the active criteria. Clear the filters to display the records again. Avoid using delete commands unless you intend to remove source data.

How do I show one of several values in a column?
Open the column arrow, clear (Select All), select each value you want included, and choose OK. Those selected values work as alternatives within that column.

How do I remove only the last filter I added?
Open the arrow for the column where you added that condition and choose Clear Filter From [Column Name]. Filters in other columns should remain active.

Why does my filter return zero results when the values look right?
Check all active conditions, not just the last one. A hidden space, inconsistent spelling, text-formatted number, or date stored as text can also prevent an apparent match. Inspect and standardize the source values if needed.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.