Filtering shows and hides rows based on what you type, without deleting anything

Filtering in Excel lets you display only the rows that match what you're looking for. If you have a spreadsheet with 500 customer records and you want to see only those from California, filtering hides the rest temporarily. The data stays in your file — filtering just changes what's visible on screen. You can remove the filter anytime and see all rows again.

Filtering works best when your data is organized in a table with headers — one row at the top that names each column. Excel reads those headers and creates dropdown buttons you click to choose what to show.

The simplest filter takes 30 seconds. The most useful filters let you combine multiple conditions, like "show me sales over $1,000 from the last 30 days." This section covers both.

Key Takeaways

  • Turn on filtering by selecting any cell in your data table, then clicking Data > Filter on the ribbon.
  • Click the dropdown arrow in a column header to show only rows with specific values in that column.
  • Use the search box in the dropdown to find one value quickly instead of scrolling through a long list.
  • Combine filters across multiple columns to narrow results — for example, show only California customers who spent more than $500.
  • Filtering hides rows but does not delete them; remove the filter to see all data again.

Turn on filtering with one click

Start by clicking any cell inside your data table — it does not matter which one. Excel will recognize the whole connected block of data as your table.

Look at the ribbon at the top of the screen and find the Data tab. Click it. You will see a button labeled Filter (sometimes shown as a funnel icon). Click that button.

Excel adds a dropdown arrow to the header row of each column. These arrows are how you control what rows appear. If you do not see arrows in your header row, make sure you clicked a cell that has data in it, then try the Data > Filter step again.

Filter one column to show matching rows

Click the dropdown arrow in the column you want to filter. A menu appears with a list of every unique value in that column. For example, if your column is "State," you will see Alabama, Alaska, Arizona, and so on.

Uncheck the box next to All at the top of the menu. This unchecks every value. Then check only the boxes for the values you want to see. If you want to show only California and Texas, check those two and leave the rest unchecked. Click OK at the bottom of the menu.

Excel now hides every row except those with California or Texas in the State column. The row numbers on the left turn blue, which signals that some rows are hidden. The data has not been deleted — it is just not visible right now.

Search for a value instead of scrolling

If your column has hundreds of values, scrolling through the checkbox list is slow. Use the search box instead. Click the dropdown arrow, then type in the search box at the top of the menu. As you type, the list shrinks to show only matching values.

For example, if you are filtering a "Product Name" column and you type "shirt," the list shows only products with "shirt" in the name. Check the boxes you want and click OK. This is much faster than unchecking 200 items to find the five you need.

Combine filters across columns for more control

You can filter multiple columns at once to narrow results further. After you filter the State column to show only California, click the dropdown arrow in a different column — say, "Sales Amount" — and set up another filter there.

For instance, you might filter State to show California, then filter Sales Amount to show only values greater than $1,000. Now Excel displays only California rows where the sale was over $1,000. Each filter you add makes the results smaller.

The order does not matter. You can filter Sales Amount first, then State, and get the same result. Remove any filter by clicking its dropdown arrow and checking All again, or remove all filters at once by clicking Data > Filter to turn filtering off.

Use number and date filters for ranges

Columns with numbers or dates have an extra option. Click the dropdown arrow and look for Number Filters or Date Filters (the label depends on what type of data is in the column). Click that option and you will see choices like "Greater Than," "Less Than," "Between," and "This Year."

These are faster than manually checking boxes when you want a range. For example, if you want to see sales between $500 and $2,000, click Between, enter 500 in the first box and 2,000 in the second, and click OK. Excel shows only rows in that range without you having to check individual values.

Date filters work the same way. You can show only orders from the last 30 days, or from a specific month, without typing exact dates yourself.

Clear filters and get back to your full data

To remove one filter and see all values in that column again, click its dropdown arrow and check All. To remove all filters at once and see every row, click the Data tab and click Filter again. The dropdown arrows disappear and all hidden rows reappear.

Your data is never deleted when you filter or remove filters. Filtering only changes what is visible on your screen. You can turn filtering on and off as many times as you want.

Frequently Asked Questions

Can I filter text that contains a specific word?

Yes. Click the dropdown arrow in the column, then look for Text Filters and choose Contains. Type the word you are looking for and click OK. Excel shows only rows where that column contains that word anywhere in the text.

What if I filter a column and then add a new row of data — will the filter hide it?

If the new row does not match your filter conditions, yes, it will be hidden. You will not see it until you remove the filter or adjust it to include the new value. This is why it is good to check that filtering is off before you add new data.

Can I sort and filter at the same time?

Yes. Filter first to show only the rows you want, then click a column header dropdown and choose Sort A to Z or Sort Z to A. The sort applies only to the visible rows. When you remove the filter, the sort stays in place.

Does filtering work the same way in Google Sheets?

The steps are similar but the menu looks different. In Google Sheets, click Data > Create a filter, then click the filter icon in each column header. The search and checkbox options work the same way as Excel.

What happens to formulas in other cells when I filter?

Formulas that reference the filtered column will include hidden rows in their calculations. If you want a formula to count only visible rows, you need a different function like SUBTOTAL. For most everyday filtering, this is not a concern.