Excel add filter on column

Try it!

1. Select any cell within the range.
2. Select Data > Filter.
3. Select the column header arrow .
4. Select Text Filters or Number Filters, and then select a comparison, like Between.
5. Enter the filter criteria and select OK.

1. Why can't I add a Filter to a column in Excel?

Why can't I add a Filter to a column in Excel?

Check that you have selected all of the data

If your data has empty rows and/or columns or if you are only wanting to filter a specific range, select the area you want to filter prior to turning Filter on. Failing to select the area leaves Excel to set the filter area.