Filter data

(lively music) - [Narrator] Use the filter tool to hide data that does not meet a specific criteria. In the home ribbon, go to the sort and filter menu, click on filter to enable the filter tool. A menu appears in each column. Open the menu for the column that contains the data that you want to filter out. I want to see only rows where the address column contains the word London. I'll choose text filter, then the contains option.

I'll fill in the word London, then click ok. Now the filter only shows my clients in London. To turn the filter off, go back to the sort and filter menu and click on filter again.