Using Filters in Excel

Using filters in Excel can make looking for multiple items that are in the same column easier to find when not in order.

Here is a list of bills in chronological order. We are going to use filters to find all bills paid through Entergy.

Highlight Row 1 for the columns that you want filtered.

Click Sort & Filter, then click Filter.

There are now drop down boxes at the top of each column.

Click on the arrow for Item.

Click Select All to deselect all items.

Click on Entergy. Then click anywhere on the sheet to close out the box.

Now we have all items that have been paid to Entergy.

To reset the selection and have it unfiltered. Click back on the arrow and click Select All.