How to Edit a Filter in Excel: Change Criteria and Ranges

Formulas & functions · Updated November 20, 2026

To edit a filter in Excel, open the drop-down arrow in a filtered column and change its selected values or filter conditions, then select OK. To change which columns the filter covers, clear the current filter and apply it to the correct data range. These steps are for Microsoft Excel for Microsoft 365 on Windows; the same ribbon commands are available in Excel for Mac and Excel for the web, though some keyboard shortcuts differ.

What You’ll Need

  • An Excel workbook containing the list or table you want to filter. Save a copy first if the data is important.
  • A header row with a distinct heading for each column. Excel uses those headings to label the filter menus.
  • A general idea of which rows or values you want to show. You can change or remove the criteria later.

Filters hide rows that do not meet your conditions; they do not delete those rows or rearrange the underlying data permanently. If a worksheet is protected, or if you have only read-only access, you may need permission to change its filter.

Step-by-Step

  1. Find the filtered column. Look at the header row for a drop-down arrow. A funnel symbol usually indicates that the column currently has an active filter. If you do not see arrows, click a cell in the data and choose Data > Filter to turn AutoFilter on. In Windows Excel, Ctrl+Shift+L toggles filter arrows for a selected data range. On a Mac, use Data > Filter; keyboard shortcuts can vary with the keyboard and Excel version.
  2. Open the column’s filter menu. Select the arrow beside the heading you want to edit, such as Region, Date, or Status. The menu shows the available values and any filter conditions already applied to that column. A filter on another column may also be affecting which rows you see, so check all relevant headings rather than assuming one filter explains the result.
  3. Change a checklist filter. To choose specific text, numbers, or dates, clear or adjust the checkboxes in the list. Select (Select All) to include every listed value, then clear only the values you want to exclude. Alternatively, clear (Select All) and select just the values you want to display. Choose OK to apply the revised selection. For example, to show only orders marked Open or Pending, select those two values and leave other statuses unchecked.
  4. Use the menu search box for long lists. Type part of a value into the search field at the top of the menu. Excel narrows the displayed checklist to matching entries; select the results you need and click OK. Be careful when changing a searched checklist: if you intend to keep several values that do not match the search term, clear the search and verify the complete selection before applying it.
  5. Set a condition instead of choosing listed values. For text, choose Text Filters; for numbers, choose Number Filters; and for dates, choose Date Filters. Select an option such as Equals, Begins With, Greater Than, or Between, enter the value or values, and confirm with OK. Use Custom Filter when offered to combine two conditions with AND (both conditions must be true) or OR (either condition can be true). For instance, a number filter can show amounts greater than 100 and less than 500.
  6. Clear one column’s filter without removing the others. Open that column’s drop-down and choose Clear Filter From [column name]. Excel restores the rows excluded by that column’s criteria, while filters on other columns stay in place. This is useful when you want to revise one part of a multi-column search without starting over.
  7. Clear every active filter. On the ribbon, choose Data > Clear to remove the current filter criteria and show all rows in the filtered range. The filter arrows generally remain available, so you can set new criteria immediately. To remove the arrows themselves, choose Data > Filter to turn filtering off. Clearing criteria and turning off AutoFilter are different actions.
  8. Change the range covered by the filter. If a column has no arrow, or new rows are not included, turn off AutoFilter with Data > Filter, select the complete data block including its header row, and turn it back on. Avoid including unrelated notes or blank columns. If your data is already an Excel table, add or remove table columns as needed; table headers have filter arrows by default, and rows added directly below a table are usually included automatically.
  9. Check the result. Look for funnel icons in the headings and review the visible records. If the result is unexpected, open the relevant menus and check for criteria on other columns, hidden rows, or values that differ because of spaces, spelling, or data type. Choose Data > Clear if you want to return to the full list and rebuild the filter from a clean view.

When you want to edit the filter rather than simply turn it off and on, change its criteria in the existing column menu. Reapplying the filter is not usually necessary after selecting new criteria; Excel updates the visible rows when you confirm the menu.

Common Mistakes

Clearing the wrong thing: The Clear Filter From command affects one column, while Data > Clear removes criteria across the filtered range. Data > Filter toggles the arrows. If you only need to change a condition, open its menu instead of clearing every filter.

Selecting all values by accident: Choosing (Select All) displays every value in that column and removes its filtering effect. If you then uncheck a single item, you are excluding that item, not selecting only it. To show only a small group, clear the full selection first and check just the wanted entries.

Applying the filter to an incomplete range: Selecting one column or omitting the header can result in arrows on the wrong cells or exclude adjacent data. Select the entire contiguous list, including its headings. A blank row or blank column inside the list can also make Excel treat part of the data as a separate block.

Confusing similar-looking values: Entries such as North, north, and North followed by a space may appear equivalent to a person but be stored as different text values. Likewise, a number stored as text may not behave like a true number under Number Filters. Check the source cells when a value is missing from the menu or a condition returns an odd result.

Assuming hidden rows are deleted: Filtering hides nonmatching records from view. It does not remove them. Avoid copying, deleting, or editing visible rows until you confirm which rows are selected and what the operation will affect.

Tips

Use an Excel table for lists that will grow. Select a cell in the data and choose Insert > Table, confirm that the range is correct, and check My table has headers if appropriate. Tables provide filter arrows and usually extend their range when you enter data directly below them. If Excel interprets a heading as a data value, check that the header option and selected range are correct.

Build a multi-column filter one condition at a time. For example, filter Department to Sales, then filter Status to Open. Excel shows rows that match both column filters. If you need either one condition or another across different columns, ordinary column filters may not express that combined logic directly; consider adding a helper column that labels the rows you want, then filter that column.

Use the most suitable filter type. A checklist is convenient when the exact values are known; Text Filters work well for partial text matches; Number Filters are better for ranges and comparisons; and Date Filters can group dates into periods. For dates, check that the cells contain real Excel dates rather than text that only looks like a date.

Before sharing a workbook, decide whether the recipient should see the filtered view or all records. You can choose Data > Clear to show all rows before saving, or leave a useful filter in place and explain it. If more than one person is editing a workbook, be aware that changes to a shared worksheet’s filter view can affect what other collaborators see, depending on how the workbook is shared.

Keep a source copy when doing extensive cleanup. Filters are reversible, but deleting visible records or pasting over data is not the same as filtering. If you need to work on just a subset, consider copying the filtered results to a separate sheet and checking the copied row count before changing the original list.

Troubleshooting

The drop-down arrows are missing. Click within the list and choose Data > Filter. If arrows still do not appear, check that the sheet is not protected, that you selected a range with a header row, and that the data is not part of a layout that prevents filtering. If the range has blank rows or columns, select the complete block explicitly and turn on Filter again.

Some expected values do not appear in the menu. First clear the search box in the drop-down; it may be limiting the checklist. Then clear other column filters, since rows excluded elsewhere may affect which records are visible. Also inspect the source cells for extra spaces, spelling differences, hidden rows, or values stored as text instead of numbers or dates.

The filter shows no rows. Reopen the criteria and check for an overly restrictive selection or two conditions joined with AND when you meant OR. Clear the filters with Data > Clear and apply them again individually to identify which condition removes the records. Check date boundaries and number formats carefully; a date entered as text may not match a date condition.

New records are not filtered. Confirm that the new rows are directly adjacent to the current range and that a blank row has not separated them. For a normal range, turn off the filter, select the expanded range including the new records, and turn filtering back on. For a table, enter the new record in the row directly beneath the table or resize the table so it includes the record.

The filter menu is unavailable or commands are disabled. The worksheet may be protected, the workbook may be read-only, or you may not have permission to edit it. Ask the owner for access or an unprotected copy. If the workbook is being co-authored, confirm that it has finished syncing before making another change.

Frequently Asked Questions

How do I change an existing filter in Excel?
Open the arrow beside the filtered column, adjust its checked values or choose a different Text, Number, or Date Filter condition, then select OK. You do not need to remove the filter first.

How do I edit a filter without clearing the other columns?
Change the criteria from the menu for the column you want to edit. To remove just that column’s condition, choose Clear Filter From [column name]; criteria in other columns remain active.

Can I filter a column by more than one value?
Yes. Open its drop-down, clear (Select All), select each value to include, and click OK. For conditions such as greater than one amount and less than another, use the relevant Text, Number, or Date Filters menu.

Why does Excel hide rows when I edit a filter?
AutoFilter hides rows that do not meet the active criteria. The data is still in the worksheet. Choose Data > Clear to show all records again, or revise the criteria to include the hidden rows.

How do I add another column to an existing filter?
If the column is already inside the filtered range, it should have a drop-down arrow. If it does not, turn off Filter, select the full data block including the additional column and header, and turn Filter back on. Converting the list to a table can make future range changes easier.

Does editing a filter change the original data?
No. Changing filter criteria changes which rows are visible, not the cell contents. Editing or deleting cells while rows are hidden is a separate action, so check the visible selection before making changes to the data.

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.