Data Filter

J

JD

Is there any way to manually set the range for a data
filter? The reason is because the sheet that I want to do
a data filter on has some blank rows between in it but i
want to filter the whole thing. Any ideas
 
D

Debra Dalgleish

Select all the cells that you want to include, then choose
Data>Filter>AutoFilter
 
Top