Filtering, or temporarily hiding, data in a spreadsheet is simple. This allows you to focus on specific spreadsheet entries.
To Filter Data
Step 1: Click the Filter command on the Data tab. Drop-down arrows will appear beside each column heading.
Step2: Click the drop-down arrow next to the heading you would like to filter. For example, if you would like to only view data regarding Flavors, click the drop-down arrow next to Category.
Step3: Uncheck Select All.
Step 4:Choose Flavor.
Step 5: Click OK. All other data will be filtered, or hidden, and only the Flavor data is visible.
To Clear Filter
- Select one of the drop-down arrows next to a filtered column.
- Choose Clear Filter From…