Hi
Russell,
You can
definitely apply a filter down a column in
Excel. Here's how:
- Select the entire table or range of data that you want to filter.
- Go to the Data tab in the ribbon at the top of the screen.
- Click on the Filter button. This will add drop-down arrows to the headers of each column in your table.
- Click on the drop-down arrow for the column you want to filter.
- Select the criteria you want to filter by. You can choose from options like "equals", "does not equal", "contains", "begins with", etc.
- Click "OK" to apply the filter.
You can also apply multiple filters at once by clicking on the drop-down arrows for multiple columns and selecting criteria for each one.