Auto filter problem

M

Martin B

Can anyone suggest why autofilter fails after around 20 rows on my spreadsheet? I have a column of "Y"s & "N"s which I want to auto filter but after about 20 rows the auto filter fails. I have ensured there are no blanks in the column which is usually the cause but I am now out of ideas.

Thanks if you are able to assist

Martin
 
D

David Biddulph

Select the whole range, making sure you include all the rows & columns you need, then select AutoFilter,
--
David Biddulph

Can anyone suggest why autofilter fails after around 20 rows on my spreadsheet? I have a column of "Y"s & "N"s which I want to auto filter but after about 20 rows the auto filter fails. I have ensured there are no blanks in the column which is usually the cause but I am now out of ideas.

Thanks if you are able to assist

Martin
 

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

Dealing with a Pivot Table (when I don't want to) 0
Auto Filter Multiple Criteria 1
auto filter on columns 2
Auto Filter Comma Dilemiation 2
Auto Filter - It's broken! Help! (Office '03) 2
Filtering data 2
filter function 0
Alternate Row Shading with Filter 1

Top