autofilter is hiding cells outisde of the range I am trying to fil

[dpolking]

How do I make it filter only the group of rows that I want to?

 

[bj]

select only the rows you want to filter before you select autofilter.