Applying a filter in Microsoft Excel 2019

  1. Click on the drop-down arrow next to the DIVISION heading.
  2. Choose to sort from Ascending toDescending.
  3. Click on OK to confirm. The datasorts alphabetically.
  4. Let’s try another example, where we will apply a filter to theDIVISION column to show only the Parklands data.
  5. Click on the drop-down filter arrow to the right of the DIVISION column heading, and then click onthe (Select All) checkbox to removethe checkmark.
  6. Select the Parklands division byclicking on it, and then confirm by clicking on the OK command to return to theworksheet, as illustrated in the following screenshot:
ms office 473
  1. Please note that the icon on the DIVISION drop-down arrow has now changed toa Filter icon to reflect that a filter isapplied. If you place your mouse pointer over the icon, it will give youinformation about the filter type, as illustrated in the followingscreenshot:
ms office 122
  1. Also, note that the row numbers have changed to a blue font,indicating that a filter is applied and not all the records (rows) aredisplayed on the worksheet.

Leave a Comment