From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using filters

Using filters

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using filters

“

- If you work with lists of data, there are certainly times when you are saying, "I don't need to see all this for the moment, "I want to focus on just the people "in a certain department, maybe marketing." Or at another time, "I just want to see "the full-time people here." Or at another time, "Let's focus on the people "with the best or the worst job rating." Any number of different reasons for not wanting to see all the data and focus on just the data you need to see, the feature is called Filter. You can, from the Home tab, far right, click Sort & Filter, and then Filter to get to it that way. You could also jump over to the Data tab, and you'll see filter there as well. As with other data management tools, make sure that your data has no empty rows or columns within it. If you work with the data frequently, that's not a concern. Simply click on one of the cells within the data. Here is Filter right here, click it. And we see filter arrows at the top of each column. And it's…

Contents