Filtering a column

[Lucas Soler]

I'm able to turn on autofilter, but I can't seem to filter a column. For
example, column "Text1" has values "Yes" or blanks. How do I filter this
column?

Thanks.

 

[Jan De Messemaeker]

Hi,

Well, the simplest way is through the autofilter
You can alwo write more complex filters through Project, Filtered for...,
More Filters, New.

HTH

 

[Lucas Soler]

I'm not articulating this well. I can apply the autofilter, but how do I
then filter the column by a value in the dropdown?

 

[Brian K - Project MVP]

I'm not articulating this well. I can apply the autofilter, but how
do I then filter the column by a value in the dropdown?

You select the value from the drop down you wish to use as the filter
criteria. The reason it shows only Yes is becuase it is smart enough to
know that at this point there are only Yes values in the field.