How to Insert a Filter in Excel: Quick Steps

To insert a filter in Excel, click a cell in your data, then select Data > Filter. Excel adds a drop-down arrow to each column heading; open an arrow to show only the rows that match your choices. These steps are for Excel for Microsoft 365 on Windows. On Mac or in Excel for the web, the same Data > Filter command is available, though the ribbon layout may look a little different.

What You’ll Need

An Excel workbook with a list or table of data, preferably arranged in columns.
A header row with a heading for each column, such as Date, Region, or Status.
Permission to edit the workbook. If it is read-only or protected, you may not be able to add or change filters.

You do not need to convert a range into an Excel table to filter it. Filters work on a regular, continuous data range as well. A table can be useful if you want the filtered range to expand as you add rows, but the steps below cover both options.

Step-by-Step

Check that your data is organized as a single list. Put one type of information in each column, with one record per row. For example, a sales list might have columns for Order Date, Customer, Region, and Amount. Keep the headings in one row above the records. Remove completely blank rows or columns from inside the list, because they can make Excel treat part of the data as a separate range.
Click inside the data. Select any cell within the list, including a heading or a data cell. In most cases, you do not have to highlight the entire range: Excel detects the connected block of data around the active cell. If the worksheet has nearby notes or another list, select only the intended range before applying the filter so Excel does not include unrelated cells.
Apply the filter. On the ribbon, select Data > Filter. Small drop-down arrows should appear beside the headings in the detected range. You can also use the Windows shortcut Ctrl+Shift+L to turn AutoFilter on or off. On Mac or in the web app, use Data > Filter if that shortcut is unavailable or conflicts with your setup.
Open a column’s filter menu. Select the arrow beside the heading you want to filter. The menu usually includes a search box, a list of values, sorting commands, and filter options suited to the data type. For instance, a Region column may show region names, while a Date column may provide date-related choices.
Choose the values to keep visible. To show only selected entries, clear Select All, check the values you want, and select OK. For example, in a Region column, select West and Central to display records from those regions only. Excel hides rows that do not meet the selection; it does not delete them.
Use search or a condition for a longer list. If the menu contains many distinct values, type part of a value into its search box, check the matching result, and select OK. For text, number, or date columns, open the menu’s relevant filter option, such as Text Filters or Number Filters, and select a condition such as Begins With or Greater Than. Enter the requested value and confirm the condition.
Filter by more than one column when needed. Apply a choice in one column, then open another column’s arrow and set its filter too. Excel combines filters across columns: a row remains visible only when it meets the active criteria. For example, filtering Region to West and Status to Open shows open records from the West, not every open record and every western record separately.
Review and adjust the result. Check the visible rows and the filter indicators in the headings. A funnel icon or changed drop-down indicator signals that a filter is active. To revise a choice, reopen that column’s menu and select different values or conditions. If the result is unexpected, clear the filters and apply them again after checking the source data and headings.
Clear a filter or remove the arrows. To show all rows while leaving the arrows in place, open a filtered column’s menu and choose Clear Filter From that column. To clear all active filtering, use Data > Clear where that command is available, or clear each filtered column. To remove the drop-down arrows, select Data > Filter again. Turning the filter off does not delete records; it restores the full list to view.

If your range is already an Excel table, its header row normally has filter arrows automatically. Click a cell in the table and use the same arrow menus to filter. If the arrows are missing, select a table cell and look for the table options on the ribbon; enable the header row if necessary. A range can also be made into a table with Insert > Table, but check that My table has headers is selected when your first row contains headings.

Common Mistakes

Leaving blank headings. Each column needs a clear heading. Blank or duplicated headings can make the filter menu confusing, especially in a table. Add a distinct name to each heading before filtering.
Selecting only one column and separating it from its records. Filtering a lone column can hide values without hiding the matching information in other columns. Apply the filter to the whole connected list, not just one column, so complete rows stay together.
Expecting a filter to delete or rearrange data permanently. Filtering hides rows that do not match. They remain in the worksheet and reappear when the filter is cleared. Sorting changes row order, while filtering changes which rows are displayed; they are different actions.
Assuming visible rows are the whole dataset. A total or count entered manually beside filtered data may still include hidden rows, depending on how it was calculated. Check the formula and use a method designed for filtered lists if you need a subtotal that responds to filtering.
Including notes or extra blocks in the selected range. Nearby titles, blank separators, or a second list can cause Excel to detect the wrong boundaries. Select the intended data range explicitly if automatic detection does not match your list.
Looking for a value that is not consistent in the source. A column may contain extra spaces, different spellings, or dates stored as text. These entries can appear as separate choices or fail to match a date condition. Clean or standardize the source values before relying on the filter.

Tips

Make headings descriptive and concise. A heading such as Invoice Date is easier to identify than a generic label such as Date 1. Avoid putting explanatory notes in the same header row.
Use the menu search for large lists. Searching a filter menu is usually quicker than scrolling through hundreds of names or codes. Clear the search text if you want the full value list back before making another selection.
Use conditions when you need a range. Selecting individual values is handy for a short list. For dates, amounts, or text patterns, a condition such as after a date or greater than a number can be more precise. Read the condition before confirming so you do not accidentally exclude the boundary you need.
Convert a growing range to a table. Tables expand when you add data directly beneath them and make column headings easier to work with. This can help keep new rows within the filtered dataset. If you paste data far away from the table, however, it may not become part of it automatically.
Keep a copy of the original data when experimenting. Filters are reversible, but editing or deleting records while only some rows are visible can have consequences. Before making bulk changes, clear filters or confirm exactly which rows are selected and visible.
Remember that filters can be combined. If a row disappears, it may fail a condition in a different column from the one you just changed. Check each heading for an active filter rather than troubleshooting only the most recently used menu.

Troubleshooting

No arrows appeared after choosing Data > Filter: Confirm that a cell in the data range is selected and that the worksheet is not protected in a way that prevents filtering. Check whether the filter was toggled off by mistake. If the range has a completely blank row or column through its middle, select the full intended range and apply the command again.
The arrows appeared on the wrong cells: Undo is not usually necessary. Turn off the filter, select the exact range including its header row, and choose Data > Filter again. Check for a title row above the real headings or an adjacent block that Excel may have included.
A value seems to be missing from the menu: First clear the menu search box and any other column filters. Then check the source cells for leading or trailing spaces, inconsistent spelling, or a value in a row outside the filtered range. If the list has changed since the filter was applied, reapply the filter or confirm that the new rows are inside the range or table.
The filter shows no rows: One or more active conditions may be too restrictive, or the selected value may not exactly match the data. Open each filtered column menu and clear its filter, then add criteria one at a time. This makes it easier to identify the condition that removes every row.
Dates or numbers are treated like text: Mixed formats can stop Excel from offering the expected date or number conditions. Check a few source cells and make sure their values are stored consistently as dates or numbers, not text that only looks like a date or amount. Correct the source values, then clear and reapply the filter.
You cannot change the filter: The worksheet may be protected, the workbook may be read-only, or another user may have restricted editing. Check the workbook’s protection and sharing settings, or ask the owner for edit access. In Excel for the web, confirm you are not viewing a read-only copy.

Frequently Asked Questions

How do I add a filter to just one column?
Excel’s AutoFilter applies to a list or table, so its arrows appear on the headings for all columns in that range. Open the arrow on the one column you want to filter; the matching rows will remain intact across the list.

Does filtering delete hidden rows?
No. A filter hides rows that do not match the selected criteria. Clear the filter to display them again. Avoid selecting and deleting rows unless deletion is actually what you intend.

Can I apply two filters at the same time?
Yes. Set a filter in one column, then set another in a different column. Excel displays rows that satisfy both active filters. You can also select multiple values within a single column’s menu.

How do I filter a date range?
Open the arrow in the date column and choose a date filter option, such as a range or a before/after condition, then enter the dates and confirm. The exact menu choices depend on the values and Excel version. If dates are not grouped or recognized as dates, check that the source cells contain real Excel dates rather than text.

Can I filter in Excel for Mac or Excel for the web?
Yes. Select a cell in the list and choose Data > Filter, then use the heading arrows. Ribbon arrangement and some menu details can vary by version, but the basic process is the same.

Why does a new row not appear in my filter?
The row may be outside the original filtered range. Add it directly below a table so it can expand, or turn off the filter, select the enlarged range including the header, and apply Data > Filter again. Check for a blank row that separates the new data from the original list.

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.