How to Put a Filter in Google Sheets and Sort Data

To put a filter in Google Sheets, select your data range, including its header row, then choose Data > Create a filter. Use the filter icon in a column heading to show only rows that match your criteria, or sort the rows. Filtering hides rows temporarily; it does not delete or rewrite the underlying data. These steps are for Google Sheets in a web browser. Excel has separate filter controls, usually under Data > Filter.

What You’ll Need

A Google account and access to the spreadsheet in a web browser.
A rectangular block of data with one header row, such as columns for Date, Customer, and Status. Keep each record on one row and each type of information in its own column.
Editing permission if you need to turn on a standard filter or change the spreadsheet. If you only have view access, ask the owner for permission; some filtering options may not be available to you.

You do not need to install an add-on or create a formula. If the sheet is important, consider making a copy before changing its shared filter settings. A standard filter can affect what other editors see while they work in the same sheet.

Step-by-Step

Check and identify the data range. Open the correct sheet tab and look over the table before filtering. Make sure the first row contains clear column names, such as Product, Region, or Amount, rather than being part of the records. Avoid merged cells in the table, and check that there are no extra title rows or completely blank rows splitting the data. If the sheet contains several separate tables, work with just the one you want to filter.

Click a cell inside a continuous data block and Google Sheets will usually identify the surrounding range. If you want to be precise, drag to select the full block, including the header row. For example, if the header is in row 1 and the records occupy columns A through D down to row 50, select A1:D50. Selecting only one column can leave other details out of sync when you sort.
Turn on the filter. With a cell in the table selected or the intended range highlighted, choose Data > Create a filter. You can also use the funnel-shaped Create a filter button on the toolbar if it is visible. Google Sheets adds a small filter control to each heading in the selected range. If you do not see controls, check that the command was applied to the right sheet and that you have editing access.
Open the filter for a column. Click the filter control in the heading for the column you want to narrow down. For example, click Status to show only orders marked In progress, or click Region to display a particular location. The menu contains options for sorting and for choosing which rows remain visible.
Filter by specific values. In the menu, use Filter by values to choose which entries to keep. Clear the selection for all values, then check only the items you want to see. You can use the search box in the menu to locate a value in a long list. Click OK or Apply, depending on the control shown, to update the sheet. For example, selecting only West in a Region column hides rows for other regions, but leaves their data in the sheet.

When selecting values, remember that distinct spellings are treated as distinct entries. For example, West, west, and West with a trailing space may appear separately. If a value seems missing, search for it and check whether the data uses a slightly different spelling or has extra spaces.
Filter by a rule when a checklist is not enough. Open the column menu and look under Filter by condition. Choose a suitable condition, such as text contains, date is, or greater than, then enter the value required by that condition. This is useful for showing every amount over a threshold, dates in a selected period, or descriptions containing a word. The available conditions depend on the type of data in the column. Check that dates and numbers are stored as dates and numbers, not as text, or the results may not match what you expect.
Use more than one column if needed. Set a filter in one column, then open another column’s filter and choose an additional value or condition. The sheet will show rows that meet the active filters together. For example, filter Region to West and Status to In progress to see only in-progress records from the West. If the result is empty, remove one condition at a time to see which selection excludes all the rows.
Sort the visible records if useful. Use a column’s filter menu and select an ascending or descending sort option, such as sorting text A to Z or numbers from largest to smallest. Sorting rearranges the rows in the selected data range; it does not merely change their display order in the menu. Confirm that the whole table is included before sorting so names, dates, and other fields stay attached to the correct record.
Clear a filter or turn filtering off. To show all values in one column again, open that column’s filter menu and restore all values, or clear the condition set there. Other column filters may still be active, so check each heading if some rows remain hidden. To remove the standard filter controls altogether, choose Data > Remove filter. Removing the filter does not restore a previous row order if you sorted the data; sorting has already rearranged the rows.
Use a filter view for a separate view of shared data. If you do not want to change the standard filter view other editors use, choose Data > Create a filter view. Set filters and sorting in that view, and give it a useful name if the name field appears. Close the filter-view bar with its close control when you are finished. Reopen a saved view from the Data menu’s filter-view options. Filter views are especially helpful when several people need to examine different parts of the same table.

Common Mistakes

Leaving out the header row: If the range starts on the first record instead of the headings, the filter controls may be attached to the wrong row and the headings may be treated as data. Include one clear header row when creating the filter.

Selecting only one column: A filter or sort applied to a single column can make the displayed information confusing, and sorting only one column can separate values from their associated records. Apply the filter to the complete table, not just the column you want to inspect.

Assuming hidden means deleted: A filtered-out row is still present. Clear the filter to see it again. Do not delete rows just because they disappear after you choose a filter value.

Expecting a filter to include new data automatically: If new records are added outside the filtered range, they may not receive filter controls or respond as expected. Check the range and extend it to include the added rows. Keeping the table in one continuous block makes the range easier to manage.

Using a standard filter in a shared sheet without warning: A standard filter changes the view other editors may be using. Use a filter view when people need independent ways to inspect the same data, or coordinate before changing the shared view.

Tips

Use descriptive headings. Short, distinct labels make it easier to pick the correct column from filter menus. Avoid duplicate or blank headings.
Start with a specific question. Decide whether you are looking for a particular status, date range, or threshold. This helps you choose between filtering by values and filtering by condition.
Check the visible row numbers. Gaps between row numbers usually indicate that some rows are hidden by the current filter. If a record appears to be missing, clear the filters before concluding that it has been removed.
Keep original data together. If you are unsure about a sort, make a copy of the sheet first. A filter only hides rows, but a sort changes the row order and can be harder to reverse after further edits.
Name filter views for their purpose. Names such as Open orders or West region help you and collaborators identify a saved view without having to inspect its settings.

Troubleshooting

No filter icons appear: Confirm that you selected a cell inside the table, then try Data > Create a filter again. Check that you are on the intended tab and that the range includes the headings. If the menu command is unavailable, confirm that you have editing permission and that the sheet is not protected in a way that prevents changes.

The filter hides too many rows or shows none: Open each filtered column and inspect the selected values and conditions. Several filters are combined, so a row must meet all active criteria to remain visible. Clear one filter at a time and review the results. Also check for inconsistent spelling, spaces, number formats, and dates stored as text.

The filter does not include some records: Check whether those records fall outside the range where the filter controls were created. Select the full updated table and recreate or adjust the filter. Look for blank rows that may split the data, and make sure new records follow the same column layout as the existing ones.

Sorting scrambles the table: Undo immediately with Edit > Undo if you have not made other changes since sorting. Then select the full table, including all related columns and the header, before sorting again. If other edits have already been made, use a copy or version history rather than guessing at the previous order.

A collaborator sees a different result: Standard filters can affect the shared sheet view, and another editor may change the active filter. Ask whether a filter view is being used. A saved filter view can preserve a particular arrangement, while collaborators can use their own views without repeatedly changing the standard filter.

Frequently Asked Questions

Does filtering delete rows in Google Sheets?

No. A filter hides rows that do not match the chosen criteria. Clear the filter or restore all values in its menu to make those rows visible again. Deleting rows is a separate action.

Can I filter by more than one column?

Yes. Apply a value selection or condition in one column, then set another in a different column. The visible rows must satisfy the active filters together, so adding a second filter will usually narrow the results further.

Can I filter a sheet without changing what others see?

Use Data > Create a filter view and set up a separate view. A standard filter can change the shared sheet view, while filter views let people work with different ways of looking at the same data.

How do I show all rows again?

Open each column’s filter menu and restore all values or clear its condition. If you want to remove the filter controls as well, choose Data > Remove filter. Check every filtered column if some rows are still hidden.

Can I filter by color?

Google Sheets provides filter options for fill color and text color when colors are present in the range. Open the column’s filter menu and look under Filter by color. If that option is unavailable, check whether the selected range contains the relevant colored cells.

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.