- Open the Excel spreadsheet.
- Click in cell A1.
- Select the Data tab in the Office ribbon and click the Filter button. Drop-down arrows appear in each column.
- Click the drop-down arrow for the column you wish to filter by.
- Either unmark all the items you want filtered out or unmark Select All and mark each item you want to see.
Connect and collaborate with fellow Blackbaud users.