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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering data from a non-continuous list 3
Filtering data 2
Indenting every other paragraph in Word at the same time? 0
Cell data entering slow! 0
Calculation Time 2
Need Help with a VBA subroutine 0
filtering: sometimes data below blank lines is &isnt available? 2
On Double Click - Filter Transactions to New WorkSheet 0

Top