How to Edit a Filter in Google Sheets Without Losing Data

To edit a filter in Google Sheets, click the filter icon in the column header, change the selected values or filter condition, and apply the change. The rows that do not match are hidden, not deleted. These instructions are for Google Sheets in a desktop web browser; menu labels and filter controls can look different in the mobile app.

What You’ll Need

A Google account with access to the spreadsheet. If you can view but not edit the sheet, you may not be able to change its filters.
A sheet containing a data range with a header row. Clear, unique column headings make it easier to identify which filter to edit.
A web browser and an idea of what you want to show, such as rows from one region or dates after a particular day.

Step-by-Step

Open the correct sheet and check its current filter. Open the spreadsheet and click the worksheet tab that contains the data. Look for filter icons, usually funnel-shaped, in the header row. If you see them, a filter is active on that range. Before changing anything, note which columns appear to be filtered and whether you are working with a standard filter or a filter view. This helps prevent changing the view other collaborators rely on.
Choose whether to edit a standard filter or a filter view. A standard filter is the usual choice for a shared range, and its settings can affect what other collaborators see. A filter view lets you sort and filter a range without changing the standard view for everyone else. To open an existing filter view, use Data > Filter views and select it from the list. If you are unsure, check the top of the sheet: an active filter view has a dark bar with its name and controls. If there is no filter-view bar, you are likely using a standard filter.
Open the filter menu for the column you want to change. Click the filter icon in that column’s header, not in a nearby column. The menu shows options for sorting and filtering. Read the column heading first; for example, a filter on Status will offer different values from a filter on Owner. If the menu does not open, check that you have permission to edit and that the filter still covers the header you clicked.
Change a filter based on specific values. In the menu, use Filter by values. The list shows values found in the column. Clear the checkboxes for values you want to hide, or select the values you want to keep. The search box can help when the list is long: type part of a value, then select the matching item or items. Review the checkbox state before applying the change, because selecting only one item will hide every other value. Click OK to apply the updated selection.
Change a rule-based condition when exact values are not enough. Open the column menu and choose Filter by condition. Select a condition that fits the data, such as text contains, date is after, or greater than, then enter the value the rule should use. For example, to show orders above a chosen amount, select a numeric greater-than condition and enter the threshold. For dates, use a valid date or an available date condition. Check the preview or visible rows, then click OK. The exact choices depend on whether the column contains text, numbers, dates, or another type of data.
Check how the edited filter combines with other columns. Filters on separate columns work together: a row must satisfy the active conditions to remain visible. If you set Region to North and Status to Open, you will see rows that meet both selections, not rows that meet either one. If fewer rows appear than expected, inspect the filters on all columns and temporarily broaden one to see which condition is excluding the records.
Confirm the result and make sure nothing was removed. Check a few visible rows against the conditions you chose. Scroll through the range if needed, and look for row numbers that skip; skipped numbers generally indicate hidden rows. A filter hides nonmatching rows rather than deleting them. To see the full list again, reopen the relevant column menu and restore the values or remove its condition. Keep in mind that sorting changes row order, so check whether you also selected a sort option by mistake.
Adjust the range if the filter misses data. A filter only applies to its covered range. If new records or columns sit outside it, they may not respond to the filter. For a standard filter, the straightforward way to reset its coverage is to choose Data > Remove filter, select the complete data range including its header row, and choose Data > Create a filter. Then set the desired conditions again. Removing the filter does not delete the data, but it clears the existing filter setup, so note any criteria you need before doing this.
Save or close the view appropriately. Google Sheets saves changes automatically. With a standard filter, simply leave the sheet when you are done. With a filter view, use its bar to rename the view if the name field is available, or close the view with the close control when you want to return to the regular sheet. Closing a filter view is not the same as deleting rows. If you want to preserve a useful view for later, make sure you are editing the intended named view rather than making a temporary change to the standard filter.

Common Mistakes

Assuming filtered-out rows were deleted. They are normally just hidden by the filter. Clear or broaden the conditions to show them again before concluding that information is missing.
Editing the wrong column’s menu. The filter icon belongs to the header directly above it. Confirm the heading before changing checkboxes or conditions.
Using a standard filter when you need a private view. Standard filter changes can affect the shared sheet view. Use a filter view when you want to explore or narrow records without changing how collaborators see the standard range.
Forgetting that multiple conditions narrow results together. If each condition looks reasonable on its own but the sheet is nearly empty, check the other filtered columns as well.
Including a blank row or excluding new records from the range. A blank row in the middle can make data behave like separate blocks, while records below the covered range may not be filtered. Select one continuous range with a clear header row when creating the filter.
Mixing up filtering and sorting. Filtering hides rows that do not match; sorting reorders the rows. If the records are still there but in a different order, check whether you chose a sort command in the column menu.

Tips

Use consistent data formats. If dates in one column are stored partly as text and partly as dates, date conditions may not treat every entry alike. Likewise, extra spaces or inconsistent spelling can create separate entries in a values list. Clean up inconsistent source values if a filter seems to miss them.
Use the search box for long value lists. Searching within Filter by values is often faster than scrolling through hundreds of names or categories. After searching, verify which boxes are selected before clicking OK; the search narrows the list shown but does not itself define the final condition.
Keep the header row simple. Give each column one clear heading, avoid merged header cells, and keep the records in a continuous block. This makes filter menus easier to identify and helps Sheets interpret the range correctly.
Make a filter view for repeat tasks. If you often need the same subset, create a named filter view rather than repeatedly changing a shared standard filter. Use Data > Filter views > Create new filter view, then set the column conditions and give the view a recognizable name.
Be careful when collaborators are editing. Ask before changing a shared standard filter if others may be using the sheet. Filter views are useful for independent analysis, but edits to the underlying cells are still shared edits; a view does not make the data private or create a separate copy.
Do not use a filter as a substitute for deleting or protecting data. Hiding rows is only a display change. Anyone with access and the right permissions may be able to clear the filter and see those rows.

Troubleshooting

The filter icon is missing. The range may not have a filter, or you may be looking at a different worksheet. Select the data range including its header row and choose Data > Create a filter. If the command is unavailable, check your editing permission and whether a filter view or protected range is affecting what you can do.

The filter menu is there, but the expected value is missing. Check whether the value is outside the filter’s range, has a spelling or spacing variation, or is stored in a different format. If the list is long, search for part of the value. If new rows were added beyond the range, reset the filter range as described above.

Nothing appears after applying a condition. The condition may not match the actual cell contents, or another column’s filter may be excluding the same rows. Reopen the menu and inspect the condition and entered value. Temporarily broaden or clear other column selections to identify which rule is responsible, then reapply the conditions you actually need.

The filter changes what a collaborator sees. You may have edited the standard filter. If the sheet is shared, restore its previous settings if known, or agree on a shared arrangement with collaborators. For your own analysis, use a filter view in future; it changes your view without replacing the standard filter settings.

I cannot change or restore the filter. You may have view-only access, or the sheet owner may have protected the range. Ask the owner for edit access or help changing the filter. If you are an editor but the range behaves unexpectedly, check whether you are inside a named filter view and close it before working on the standard sheet.

Frequently Asked Questions

Does editing a filter delete rows?
No. A filter hides rows that do not match its rules. The underlying cell contents remain in the sheet. Clear or change the filter to display those rows again.

How do I clear a filter from one column?
Open that column’s filter menu and restore the full set of values or remove its condition, then click OK if prompted. Other columns may still have active filters, so clearing one menu might not show every row.

Can I change the range of an existing filter?
For a standard filter, note its settings, choose Data > Remove filter, select the complete replacement range including the headers, and choose Data > Create a filter. Reapply the conditions afterward. This resets the filter configuration but does not erase cell data.

What is the difference between a filter and a filter view?
A standard filter changes the shared filter on a range and can affect the view collaborators see. A filter view is a named, separate way to sort and filter the same data without changing the standard view for everyone. Neither one creates a private copy of the underlying information.

Can I edit a Google Sheets filter on my phone?
The Google Sheets mobile app has different controls from the desktop browser, and some filter-view tasks may be harder to manage there. For the menu paths in this guide, open the spreadsheet in a desktop browser. In Microsoft Excel, filtering is also available, but its menus and commands differ from Google Sheets.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.