Excel How to Filter Columns: Steps and Tips

To filter columns in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, then use the arrow in a column heading to select values or set a condition. A filter hides rows that do not match; it does not delete them or hide the column itself.

How column filters work

An Excel filter is attached to a column in a list of related records. For example, a sales list might have columns for Date, Region, Product, and Revenue. Filtering Region to show West displays the records whose Region value is West and temporarily hides the other rows. The headings and the matching records remain visible, so you can inspect a smaller portion of the list without changing the source data.

Filters on different columns work together. If you choose West in Region and select a particular product in Product, Excel shows rows that meet both selections. Within a single column, selecting several listed values generally means “show rows matching any selected value.” This makes it possible to narrow a list by location and product while including more than one product value.

Filtered rows are hidden from view, not removed. Row numbers may therefore skip from one number to another, which is normal. Formulas and charts may respond differently depending on how they are set up, so do not assume that a filtered screen represents a permanent or complete change to the workbook.

Prepare the data before filtering

Excel needs a recognizable header row and a consistent block of records. Put one field name at the top of each column, such as “Region” or “Order date,” and keep each record on a single row. Avoid blank rows or blank columns inside the list: they can make Excel detect only part of the data when you turn on filtering.

Use one header row, with a distinct label for every column.
Keep data of the same kind in the same column. For instance, store dates as dates rather than mixing dates with notes such as “unknown.”
Remove merged cells from the data range. Merged headings can interfere with identifying and filtering a regular list.
Check that there are no accidental spaces or inconsistent spellings in values you expect to match, such as “North” and “North ”.

For an ordinary range, click within the list before turning on Filter. Excel usually detects the contiguous data around that cell. If the worksheet contains nearby notes or a separate table, select only the intended range first so those cells do not become part of the filter area.

Turn on filters in Excel

Use the ribbon to add dropdown arrows to the header row. On Windows, the shortcut Ctrl+Shift+L toggles AutoFilter for the selected range; the ribbon command is useful if you want to confirm what is being applied.

Click a cell inside the data list, or select the full range including its headers.
Choose Data > Filter.
Look for a dropdown arrow in each header cell. Click the arrow for the column you want to filter.
Choose values or a condition, then select OK if the menu presents an OK button.

If you use Excel for Mac, the Data tab also has a Filter command; menu placement can vary slightly by release. Excel for the web has the same basic dropdown filtering approach, though its ribbon layout and available commands can differ. On any platform, the ribbon command is a reliable alternative when a keyboard shortcut is unfamiliar or conflicts with a system setting.

Filter by listed values or search

Click a header arrow to see the options for that field. In a column of regions, for example, clear (Select All) and select only West, then apply the selection. Excel will display records with that value. To include two regions, select both values before applying the filter. The list of available values reflects what is present in the data range, so a value not represented there will not appear as a choice.

When a column contains many distinct entries, use the search box in the dropdown to find a value rather than scrolling through the whole list. Search narrows the choices shown in the menu; select the intended result and apply it. Be sure to notice whether other checkboxes remain selected, because those selections can affect which records stay visible.

A funnel icon on a header indicates that the column is filtered. A plain dropdown arrow means a filter is available but does not, by itself, indicate that a condition is active. To review the current selection, reopen that column’s dropdown. This is helpful when a worksheet looks incomplete and the reason is not immediately obvious.

Use text, number, and date conditions

Value checkboxes are convenient for exact entries, but a condition is often clearer when you need a range or pattern. In the column dropdown, open the relevant filter option—such as Text Filters, Number Filters, or Date Filters—and choose a condition. The labels shown depend on the data type Excel recognizes in that column.

Text: Use conditions such as Begins With, Contains, or Equals. A Contains condition for “chair” can find entries such as “Office chair” and “Chair mat,” depending on the text entered and the chosen operator.
Numbers: Use Greater Than, Less Than, Between, or a related comparison to isolate values. For example, a revenue filter greater than 1,000 keeps rows above that threshold.
Dates: Choose a date condition or use the date hierarchy, where available, to narrow records to a period such as a year, quarter, or month. Confirm that Excel recognizes the entries as dates; text that merely looks like a date may not offer the expected date options.

For a condition with two tests, the dialog may offer And or Or. And requires both conditions to be true—for example, a number above 100 and below 500. Or keeps a row if either condition is true. Choose based on the intended logic; confusing the two can produce a result set that is unexpectedly large or small.

Combine filters across columns

You can apply a filter to one column and then open another column’s dropdown without clearing the first. For example, filter Region to West, then filter Status to Open. Excel displays rows that satisfy both filters. This is useful for answering a focused question such as “Which open orders in the West are due this month?”—assuming the date column is also filtered to the relevant period.

To broaden the results, adjust a column’s selections rather than turning off every filter. For example, include both West and Central in the Region dropdown while leaving the Status filter in place. Remember the difference between combining columns and selecting multiple values within one column: separate column filters narrow results together, while multiple checked values in one dropdown typically allow any of those values.

Use an Excel Table for ongoing lists

If the data will grow or be maintained over time, consider converting it to an Excel Table. Select a cell in the list and choose Insert > Table, confirm the range and whether it has headers, then select OK. Tables include filter arrows in their header row and generally expand when you add records directly below them, making the filter range easier to maintain.

A table is not required to filter data; an ordinary range works too. Tables also provide structured references and formatting features, which may be useful for ongoing work, but they do not repair inconsistent data or make an unsuitable header row reliable. Check the table boundaries if new records are not appearing in a filter’s choices.

Clear filters and fix common problems

To remove a condition from just one column, open that column’s dropdown and choose Clear Filter From followed by the column name, where that command is available. To clear filters across the active range, use Data > Sort & Filter > Clear. This restores the hidden rows without deleting the data. To remove the filter arrows themselves, choose Data > Filter again.

If expected records are missing, check these common causes:

A filter is still active: Look for funnel icons and clear or revise the relevant selection.
The selected range is incomplete: Turn off the filter, inspect whether all intended rows and columns are included, and apply it again to the correct range.
Values differ slightly: Extra spaces, spelling differences, or inconsistent number formats can make entries appear as separate values.
Blank rows split the list: Remove unintended gaps or select the complete range explicitly before filtering.
The field is stored in an unexpected type: Text-formatted numbers or dates can prevent number or date conditions from behaving as expected.

Filtering is different from sorting. Sorting changes the order of records; filtering controls which records are visible. It is also different from hiding a worksheet column: filtering a column does not make that column disappear. To hide a column, use the column’s context menu or the Home tab’s Format options instead.

Filter dropdowns, Advanced Filter, and the FILTER function

For everyday browsing, header dropdowns are usually the simplest choice because they change the visible rows in place. Excel’s Data > Sort & Filter > Advanced command is another option when you need criteria arranged in a separate range or want to copy matching records elsewhere. Advanced Filter has a more structured setup, so it is useful for repeatable or more specialized criteria rather than a quick one-time selection.

The worksheet function FILTER is different from the dropdown command: it returns matching data in another area and leaves the original list in place. It is available in Microsoft 365 and Excel 2021 or later. For example, assume the headers are in A1:C1, Region is in A2:A5, and the complete records are in A2:C5. If the four records are West / Desk / 400, East / Chair / 250, West / Lamp / 90, and North / Desk / 150, enter this in E2:

=FILTER(A2:C5,A2:A5="West","No matches")

The result spills into three columns and returns the West / Desk / 400 and West / Lamp / 90 rows. The function is useful for a separate, formula-driven result, while dropdown filters are better when you want to interactively inspect the original list. Make sure the cells where a spilled result should appear are empty.

Frequently Asked Questions

How do I filter one column in Excel without affecting the others?
Turn on Data > Filter, then use only that column’s header dropdown. Other columns remain available, but the rows displayed across the sheet are limited to records matching the selected column.

Can I filter two or more columns at once?
Yes. Apply a selection or condition in one column, then apply another in a different column. Excel shows records that meet the active filters together.

Does filtering delete rows in Excel?
No. Filtering temporarily hides rows that do not match. Clear the filter to display them again; do not confuse a filtered view with deleting records.

Why can’t I see all the values in a filter dropdown?
A value may be outside the filtered range, excluded by another active filter, or spelled or formatted differently from the entry you expect. Check the range, clear other filters, and inspect the source values.

How do I filter for blank cells?
Open the column dropdown and select (Blanks) if it appears in the value list. If it does not, check whether the intended cells are truly empty or contain spaces or formulas returning an empty string.

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.