autofilter help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when i set my auto filter it stops at blank lines rather than allowing me to
select "blanks or non blanks"

the data that it filters doesnt pass the blank line so i have

dispatched
arrived
arrived

dispatched

when i set the auto filter to show "arrived" it still shows the second
"dispatched" because it is after the blank line

is there some setting causing this
 
Hi Max,

If you have only selected the first cell in a column or columns
then applied Autofilter it will only select as far as the first
blank it comes to.

If you want it to select all of your data blanks included then
highlight all of your data before applying Autofilter.

You can also select the entire column or columns by
highlighting the column headers A,B,C etc.

HTH
Martin
 
You must log in or register to reply here.

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

Field is being truncated after simple query is run, even though nogrouping is taking place 1
Autofilter Automatically Update 1
Autofilter updating automatically 2
Problem with Union Query for a ComboBox 6
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
VBA: How can I use a string variable as autofilter criteria? 4
Update query. Within the same table: populating field 2 from field 6
autofilter count 1

Back
Top