Filtering data with AutoFilter in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of AutoFilter in Excel?

AutoFilter helps you quickly show only the rows that meet certain criteria, hiding the rest. It's like sorting your data to see just what you want.

beginner

How do you turn on AutoFilter in Excel?

Select your data range or a cell inside it, then go to the Data tab and click the Filter button. Small dropdown arrows appear in the header cells.

beginner

What happens when you click the dropdown arrow in an AutoFilter header?

You see options to select or deselect values, search for specific text or numbers, and apply conditions like 'Equals', 'Greater than', or 'Contains'.

intermediate

Can AutoFilter be used to filter by multiple columns at the same time?

Yes! You can apply filters on several columns together. Excel will show only rows that meet all the selected criteria across those columns.

beginner

How do you clear all filters applied by AutoFilter?

Go to the Data tab and click the Clear button in the Sort & Filter group. This shows all rows again without any filtering.

What does AutoFilter do in Excel?

A Changes cell colors automatically

B Deletes rows permanently

C Hides rows that don't meet criteria

D Adds new rows to the sheet

AutoFilter hides rows that don't match your filter criteria but does not delete them.

Where do you find the AutoFilter option in Excel?

A Data tab

B Home tab

C Insert tab

D Review tab

AutoFilter is located under the Data tab in Excel.

What appears in the header cells when AutoFilter is enabled?

A Radio buttons

B Check boxes

C Text boxes

D Dropdown arrows

Dropdown arrows appear in header cells to let you choose filter options.

Can you filter by more than one column at the same time using AutoFilter?

A Yes, multiple columns together

B No, only one column at a time

C Only if columns are next to each other

D Only if columns have numbers

AutoFilter allows filtering on multiple columns simultaneously.

How do you remove all filters applied by AutoFilter?

A Delete the sheet

B Click Clear in the Data tab

C Close and reopen Excel

D Right-click and choose Delete

Clicking Clear in the Data tab removes all filters and shows all data.

Explain how to apply AutoFilter to a data table in Excel and filter for specific values.

Think about the steps from selecting your data to choosing what you want to see.

Describe how filtering by multiple columns works with AutoFilter and why it might be useful.

Consider how combining filters helps find very specific data.