Yes. In an Excel table, you can filter multiple columns at the same time by choosing a filter in one column and then choosing filters in other columns; Excel displays rows that meet all the active column filters. Click a table header’s drop-down arrow to filter that column, and repeat in each additional column you want to narrow.
How filters work across columns
Each column in an Excel table has its own filter menu. When you apply filters to different columns, Excel combines them as an AND condition: a row must meet the selected condition in every filtered column to remain visible. For example, filtering Region to West and Status to Open shows only records that are both in the West region and still open.
Within one column, selecting several items from the checklist generally works as an OR condition. If you select West and East in the Region menu, Excel can show rows from either region. Combining that selection with Status set to Open means the visible rows are in West or East and are also open. This distinction—OR among selected values in one column, AND between filtered columns—is the key to understanding a multi-column result.
A filter hides rows that do not meet the conditions; it does not delete them or rearrange the source data. Clearing the filters makes those rows visible again. Sorting is different: it changes the order of rows, while filtering limits which rows are shown. You can sort and filter the same table, but they do separate jobs.
Apply filters to an Excel table
In Excel for Microsoft 365 on Windows, click a cell in the table and use the drop-down arrow in the header of the column you want to filter. Table headers normally show filter arrows automatically. If the arrows are missing, check that the data is formatted as a table and that the filter buttons have not been turned off.
- Click the arrow in the first column header.
- Choose values from the checklist, or select a suitable Text Filters, Number Filters, or Date Filters option.
- Confirm the selection in the menu. Excel hides rows that do not match.
- Open the next column’s arrow and set its filter.
- Repeat for any other columns. The visible rows will satisfy all the column filters together.
For example, imagine a table with columns for Order Date, Region, Status, and Amount. Choose West in Region, Open in Status, and a date range in Order Date. The result contains open orders from the West region within that date range. You do not need to create a separate filter view or move the matching rows elsewhere.
You can also turn filtering on or off from Data > Filter. In a table, the filter buttons are part of the table’s header controls; converting a normal data range to a table through Insert > Table is a reliable way to add those controls and make a structured dataset easier to manage.
Choose the right kind of condition
The checklist is convenient when you know the exact values you want to include or exclude. For text, number, and date columns, the menu also offers condition-based filters. These are useful when a checklist would be long or when the condition is more meaningful than a particular list of values.
- Text: use a condition such as Begins With, Contains, or Equals to find names, codes, or descriptions. For instance, a Contains condition can show product names that include the word cable.
- Numbers: use comparisons such as Greater Than, Less Than, or Between to narrow a sales or quantity column. A number filter can find amounts above a threshold without selecting every amount individually.
- Dates: use date conditions or the date hierarchy in the menu to show records for a relevant period. Date grouping choices depend on the values and the Excel interface, so check that the column contains real Excel dates rather than text that only looks like a date.
Some column menus allow two custom conditions joined by And or Or. For example, a single Amount column could be filtered to show values greater than 100 and less than 500. If you need a more complex combination across several columns, apply separate column filters or consider the Advanced Filter feature described below.
A practical multi-column example
Suppose a service log has four columns: Technician, Priority, Status, and Created Date. You want to see high-priority jobs that are not closed, assigned to either Lee or Morgan, and created during a particular month. Start by selecting Lee and Morgan in the Technician checklist. In Priority, select High. In Status, select the statuses that represent work still in progress, such as New and Working. Finally, filter Created Date to the month you need.
Excel combines those choices across columns. A row assigned to Lee will still disappear if its Priority is Low, its Status is Closed, or its date falls outside the chosen period. This is expected behavior, not a sign that filters are competing. If a row you expect is missing, inspect every active filter, because a condition in any one filtered column can exclude it.
It also helps to make conditions precise. If a status column contains both Open and In Progress, selecting only Open will not include the second label, even if the two labels mean similar things to your team. Similarly, a value with an extra space or a different spelling can appear as a separate checklist entry. Standardizing labels in the source data makes filters more predictable.
Clear or change one filter
To change a filter, reopen that column’s header menu and choose different values or conditions. To remove only one column’s filter, open its menu and choose Clear Filter From followed by the column name. Other column filters remain active, so the table stays narrowed by those conditions.
To remove all active filters at once, use Data > Clear. This clears the applied filter criteria while leaving the table and its data in place. If the arrows themselves are gone, use Data > Filter to turn filtering back on, or check the table’s filter-button setting. Be careful not to confuse clearing a filter with deleting rows: clearing reveals records that were hidden by the filter.
Keep filters reliable as data changes
Tables are useful because they treat related rows as one structured dataset. When you add data directly to the row beneath a table, Excel commonly expands the table to include it; rows added elsewhere may not be included automatically. If a new record does not appear when expected, confirm that it is inside the table. Click a cell in the data and look for the Table Design tab, or check the table boundary and resize the table if needed.
Use one clear header row, avoid blank header cells, and keep each column’s values consistent. A column that mixes dates stored as dates with dates stored as text may not filter as one coherent date field. Likewise, numbers stored as text can behave differently from numeric values. Check the underlying cell values and formats if number or date filters produce surprising results.
When a table has a Total Row, its built-in summary choices commonly use SUBTOTAL so the displayed total can respond to filtering. That is different from a regular SUM placed outside the table, which may include values from rows hidden by a filter. For a report where filtered totals matter, check how the summary is calculated rather than assuming every total adjusts automatically.
When to use slicers or Advanced Filter
Header menus work well for occasional filtering and precise conditions. If other people need to change several filters repeatedly, a slicer can make the choices more visible. Select a cell in the table, choose Insert > Slicer, and select the columns for which you want slicer controls. Clicking a slicer button filters the table; selecting multiple buttons in a slicer can include multiple values. Slicers are especially helpful on a dashboard, though they use more worksheet space than header menus.
For more specialized criteria, Excel’s Advanced Filter can use a separate criteria range and can copy matching records to another location. Its criteria layout supports combinations that can be awkward to express through ordinary header menus: conditions placed on the same criteria row are combined, while separate criteria rows can represent alternatives. Advanced Filter is not simply another name for applying several table drop-down filters; it is a separate tool with its own setup. Use it when you need a reusable criteria area or a copied result rather than just hiding nonmatching table rows.
Common problems and misconceptions
- A filter seems to ignore a row: check every active column filter, not just the column you are currently inspecting. Conditions across columns are combined.
- The dropdown list is incomplete: another filter may already be hiding some records, so the visible choices can reflect the remaining data. Clear the other filters to inspect the full list.
- A new record is not included: confirm that the record is inside the table range. If it is outside, expand the table or add the row to the table.
- Similar labels behave as different values: look for spelling differences, extra spaces, and inconsistent data types in the source column.
- Rows appear missing: filtered rows are hidden, not erased. Clear the relevant filter to reveal them.
Another common misconception is that choosing multiple entries in one column makes Excel show rows that match every selected entry at once. A single cell cannot normally have two different checklist values simultaneously, so multiple selected values in that column act as alternatives. To require two separate conditions, use different columns or the custom filter options where appropriate.
Excel on Mac and the web
The underlying idea is the same in Excel for Microsoft 365 on Mac and Excel for the web: filter a column, then apply another column’s filter to narrow the remaining rows. The ribbon layout and menu wording can vary slightly by platform or update, so look for the filter arrow in the table header if the command is not in the same place as it is on Windows. Excel for the web may also present controls differently in a narrower browser window.
If a workbook is shared, remember that filters change the view of the data and may affect what collaborators see, depending on how the workbook is shared and which Excel features are available. For team reporting, a copy of the workbook or a dedicated report sheet can reduce confusion when someone else is working with the same table.
Frequently Asked Questions
Can I filter two columns at the same time in Excel?
Yes. Apply a filter from the header menu in the first column, then apply another from the second column. Excel shows rows that meet both columns’ active conditions.
Does Excel use AND or OR for filters in different columns?
It uses AND across different columns: each visible row must match every active column filter. Multiple selected values in one column generally act as alternatives, or OR.
How do I remove a filter from just one column?
Open that column’s header drop-down and choose Clear Filter From the column name. Filters on other columns remain in place.
Do Excel filters delete the rows they hide?
No. Filtering hides rows that do not match the criteria. Clear the filter to show those rows again; the underlying records remain in the table.
Can I filter a table by more than one condition in the same column?
Often, yes. Choose the column’s Text Filters, Number Filters, or Date Filters options and use the available custom conditions. The exact choices depend on the type of column data.
Related
- Excel Row and Column Select Shortcut Keys Explained
- Excel Ribbon Keyboard Shortcuts: A Practical Guide
- Excel Reverse Undo Shortcut: What Works and What Doesn’t
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Different Labels in Word: How to Make Each Label UniqueTo create different labels on one sheet in Microsoft Word, start a label mail merge, connect a recipient…
- Excel Conditional Formatting: Nested IFs for Dates?Yes. Excel conditional formatting can use a nested IF formula, but the formula must ultimately return TRUE or…
- IF vs. IFERROR in Excel: Key Differences and ExamplesIF tests a condition and returns one result when it is true and another when it is false;…
- Excel Equation to Remove Duplicates: Formulas & StepsIn Microsoft 365, use =UNIQUE(A2:A100) to return a list of distinct values from A2:A100. This formula leaves the…
- SUMIFS in Excel: Sum Values by Multiple Criteria ExplainedSUMIFS in Excel adds values only when they meet one or more conditions. For example, with sales in…
- Excel Sum Hours: Formulas, Time Formats, and FixesTo sum elapsed hours in Excel, add the duration cells with =SUM(B2:B5), then format the total as [h]:mm…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.