Filtering Data

Learning Objectives

  • Filter data in a table.

After entering data in Excel, it is also possible to filter, or hide some parts of the data, based on user-indicated categories. When using the Filter option, no data is lost; it is just hidden from view.

Method 1

  1. Select the column or row you wish to sort.
  2. From the Sort & Filter button in the Editing group in the ribbon, click the Filter button.
  3. When the Filter menu appears, you can choose which categories of data to hide and deselect the appropriate buttons. For example, you can deselect the button next to large and you will no longer see the large cells in your table.

Data has been entered in an excel sheet. A dropdown menu from the size button has been revealed.

Method 2

You can similarly access the Filter menu through the Data tab; the same menu will appear.

Data has been entered in Columns A and B through row 13 on an excel sheet. There is a green arrow pointing to the size dropdown menu and there is a green box around the sort and filter menu.

Practice Question