To Filter Data:
In this example, we will filter the contents of an equipment log at a technology company. We will display only the laptops and projectors that are available for check-out.
- Begin with a worksheet that identifies each column using a header row.
- Select the Data tab, and locate the Sort & Filter
- Click the Filter
- Drop-down arrows will appear in the header of each column.
- Click the drop-down arrow for the column you would like to filter. In this example, we will screen the Type column to view only certain types of equipment.
- The Filter menu appears.
- Uncheck the boxes next to the data you don’t want to view. (You can uncheck the box next to Select All to deselect all quickly.)
- Check the boxes next to the data you do want to view. In this example, we will check the Laptop and Projector to display only those types of equipment.
- Click OK. All other data will be filtered or temporarily hidden. Only laptops and projectors will be visible.
Filtering options can also be found on the Home tab, condensed into the Sort & Filter command.
Leave a Reply
You must be logged in to post a comment.