How to Filter Two Columns in Excel

Formulas & functions · Updated November 20, 2026

To filter two columns in Excel, turn on AutoFilter for your data, then choose a filter in the first column and another in the second. Excel applies both filters at once, showing only rows that meet both columns’ criteria. Start with a rectangular data range that has one header row and no completely blank rows or columns splitting the list.

What You’ll Need

  • A workbook in Microsoft Excel for Microsoft 365 on Windows, with the data you want to filter.
  • A single header row with a distinct label for each column, such as Region and Status.
  • A continuous block of data. If you can, format it as an Excel table so new rows are included more reliably.

Step-by-Step

  1. Check the data before filtering. Make sure each column has a descriptive heading and that the headings are in one row. Keep each record on one row: for example, one order per row, with its region in one column and its status in another. Remove completely blank rows or columns from the middle of the list, since they can cause Excel to treat part of the data as a separate range. Also check that values meant to be the same are written consistently; Pending and pending may be treated as different text values in some filter lists.
  2. Select the data range or a cell inside it. If the list is continuous, click any cell in it and Excel can usually detect the full range. To be precise, select the whole block, including the headers, and exclude any notes or totals that are not part of the records. If the data is already an Excel table, click within the table instead. You do not need to select both columns separately: a filter applies to rows in the entire selected range, not just the column whose arrow you click.
  3. Turn on the filter arrows. On the Windows ribbon, choose Data > Filter. A drop-down arrow appears in each header cell. The Windows shortcut is Ctrl+Shift+L. On a Mac, use Data > Filter; the shortcut is Command+Shift+F in Excel for Mac. In Excel for the web, choose Data > Filter from the ribbon. If your data is a table, filter arrows are normally present already; check the table headers before switching the filter on again.
  4. Filter the first column. Click the arrow in the first column’s header. For a short list of distinct values, clear Select All, select the value or values to keep, and choose OK. For example, in a Region column, select East to show records for the East region. If you need a rule rather than a particular listed value, use the menu’s text, number, or date filter options. The available options depend on the data type Excel recognizes in that column.
  5. Filter the second column. Click the arrow in the next column and select its criteria in the same way. For example, in a Status column, select Pending and choose OK. The worksheet now shows only rows where Region is East and Status is Pending. Filters across different columns combine as AND conditions: a row has to satisfy the active filter in every filtered column to remain visible. Excel hides rows that do not match; it does not delete them.
  6. Use a rule when a checkbox list is not enough. Open a column’s arrow and choose a relevant option such as Text Filters, Number Filters, or Date Filters, then select a condition such as Contains, Greater Than, or a date range. Enter the value and confirm. You can apply a rule in one column and select values in the other. For instance, filter a Product column to text that contains cable, then filter a Quantity column to numbers greater than 10. Only rows meeting both conditions remain visible.
  7. Check that the result makes sense. Look for filter indicators in the headers and scan several visible rows to confirm that each row meets both criteria. If the list is long, note that the row numbers may skip: this is normal because filtered-out rows are hidden. You can also compare the visible records with the choices you selected in each header. Avoid editing or copying a result until you have confirmed that the active filters are the ones you intended.
  8. Change or clear a filter when needed. To change one column’s selection, open its arrow, choose different values or conditions, and confirm. To remove just that column’s filter, open its arrow and choose Clear Filter From followed by the column name. To remove all active filters while leaving the arrows available, use Data > Clear. To turn off the arrows entirely, choose Data > Filter again. In a table, the filter arrows are part of the table headers, so clearing a filter is usually preferable to turning the feature off.

Example: Suppose columns A through C contain Order ID, Region, and Status, with headings in row 1. Turn on filtering for the range, select East in the Region column, and select Pending in the Status column. The visible rows will be orders whose Region is East and whose Status is Pending. A row marked West and Pending will be hidden, as will one marked East and Complete.

Common Mistakes

  • Selecting only the two columns. If the data has other fields, filtering a partial selection can separate the visible records from their related information. Apply the filter to the whole table or continuous data range so complete rows stay together.
  • Including a title or extra heading row. A report title above the actual column labels can be mistaken for a header if it is included in the selected range. Select the real header row and records, not decorative titles or explanatory notes.
  • Expecting OR across different columns. Selecting East in Region and Pending in Status means East AND Pending. It does not show every East row plus every Pending row. To match either of two conditions across columns, consider a helper column, Advanced Filter, or a formula-based approach suited to the task.
  • Assuming hidden rows are deleted. Filtering only hides records that do not match. Clearing the filter brings them back. Be careful when selecting visible results for copying or deleting; verify the selection before making changes.
  • Using inconsistent or mixed data. Extra spaces, misspellings, numbers stored as text, or dates stored as text can make filter results incomplete or confusing. Standardize the source values if equivalent entries appear as separate items.

Tips

  • Convert a regular list to a table. Select a cell in the data and choose Insert > Table, then confirm that the table has headers. A table provides filter arrows and generally expands when you add records directly below it. This is useful for lists that change over time.
  • Keep the header row visible. If the list is long, freeze the top row with View > Freeze Panes > Freeze Top Row. The column names remain visible while you scroll, making it easier to remember which filters are active.
  • Use the search box in a filter menu. When a column contains many distinct entries, type part of the value in the menu’s search box rather than scrolling through the full list. Review the checked items before confirming, because a search can change which values you see in the menu.
  • Filter dates and numbers with conditions. For a range, a condition is often clearer than selecting many separate values. Date and number filter menus let you set boundaries such as dates before a chosen day or values greater than a threshold. Ensure Excel recognizes the entries as dates or numbers first.
  • Keep a record of the intended criteria. For a repeatable report, write down the criteria or save a copy of the workbook before changing filters. AutoFilter settings can be easy to overlook when someone else opens the file, especially if only a small subset of rows is visible.

Troubleshooting

No arrows appear: Click a cell in the data and choose Data > Filter. If you selected a range, confirm that the header row was included. In a protected worksheet, filtering may be unavailable unless the sheet’s protection settings allow it. If the data is a table, look for arrows in the table headers; they may already be enabled.

Some records do not appear in a filter list: Check for blank rows or columns that split the data, and confirm the range includes every record. If new rows were added outside a normal filtered range, select the expanded range and reapply the filter, or use a table so the range is easier to extend. Also inspect the source cells for extra spaces, spelling differences, or values stored in an unexpected format.

The results are too narrow or show nothing: Open both filtered menus and review their selected values or conditions. Because the columns combine with AND, a valid value in one column will still be hidden if it fails the other column’s condition. Clear one filter temporarily to identify which criterion removes the rows, then correct that selection or rule.

A number or date filter behaves like text: The column may contain mixed types, such as numbers stored as text or dates entered as text. Check a few source cells and standardize the column’s contents, then reopen the filter menu. A date range cannot reliably group entries that Excel does not recognize as dates.

Rows seem to be missing after you finish: They are probably still hidden by a filter. Use Data > Clear to remove active filters, or clear the relevant column from its arrow menu. If rows remain hidden, check whether they were hidden manually or whether the worksheet has an outline; clearing AutoFilter does not undo those separate actions.

Frequently Asked Questions

Can I filter two columns at the same time?
Yes. Turn on AutoFilter for the full data range, then apply a criterion in each column. Excel keeps rows that meet both active column filters.

Does filtering two columns use AND or OR?
It uses AND between columns. For example, Region equals East and Status equals Pending must both be true for a row to remain visible. Multiple selected values within one column generally work as alternatives, so selecting East and West shows either region while still honoring the other column’s filter.

Can I filter columns that are not next to each other?
Yes, as long as both columns are in the same continuous filtered range or table. The filter arrows appear on all included headers, so you can set criteria in nonadjacent columns and leave the other columns unfiltered.

How do I show rows that match either of two conditions in different columns?
AutoFilter does not provide a simple OR between separate column filters; filters in those columns intersect. You can add a helper column that marks rows meeting either condition and filter that column, or use Advanced Filter with criteria arranged for OR logic. Choose the method that best fits whether you need a quick view or a repeatable report.

Can I filter two columns in Excel for the web or on a Mac?
Yes. The basic process is the same: use Data > Filter, then choose criteria from each header arrow. Ribbon layout and keyboard shortcuts can differ by platform, so use the ribbon path if a shortcut does not work in your version.

Will filtering change or remove my data?
No. AutoFilter hides rows that do not meet the criteria; it does not delete or rewrite them. Clear the filters to show the full list again. If you are about to edit, copy, or delete rows, first check which records are visible and what selection the action will affect.

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.