AutoFilter ALWAYS shows the 1st ROW...

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I select a column say A containing CustomerNumber

If I select the 1st items in the column the filter is correct
If I choose ANYOTHER ROW CustomerNo) to filer on
I ALWAYS get 1st item !!

What am I doing wrong...???
 
If you list doesn't have heading cells, the first item in each column
will be treated as a heading. It will remain visible, no matter what you
select from the dropdown list.
 
Bill

Insert a blank row just above the point you want to start your filtering.

Gord Dibben Excel MVP
 
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

Can you Create an Autofilter that goes over 2 columns at the same 1
filtering 3 data row 2
Autofilter header row 3
Autofilter results 3
Lock Part of a Formula 2
Autofilter to filter out non-numeric rows 3
Conditional format lowest value greater than zero and copy formula 2
Merge Multiple workbook sheets into one workbook 0

Back
Top