We all know that a worksheet contains a lot of data most of the time if not always and it does become annoying to find anything you looking for quickly. To get over this frustration Excel 2016 has a solution for you and it’s easy and fun to use.
So let’s get started and teach you how to use data filter option in Excel 2016.
- Filtering will work properly only when you have a header row included in your worksheet that defines the name for every row. Let’s say, our worksheet is organized into different columns identified by the header cells in row 1: ID#, Type, Equipment Detail, and so on.
- Look for the Data tab, then select the Filter option.
- A drop-down arrow will show up in the header cell for every column.
- Click the drop-down arrow for the column you are likely to filter. For Eg, we will filter column C to view only certain type of data.
- The Filter menu will show up.
- Deselect the box next to Select All to quickly deselect all data.
- Select the boxes next to the data you want to filter, then click OK. In our example, we will Select Laptop and Projector to view only these types of equipment.
- This will filter the data and hide any content for temporarily that doesn’t fit the situation, temporarily hiding any content that doesn’t match the criteria. In this example, only laptops and tablets can be seen.
Note: Filtering options can be accessed from Data tab which itself is between Formulas & Review tab.