Filtering Data in MS Excel

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…

Leave a Reply

Your email address will not be published. Required fields are marked *