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

auto filter on columns 2
Auto Filter Comma Dilemiation 2
Auto Filter Multiple Criteria 1
Excel Auto Filter Problem 2
Select specific column for auto filter 4
Filter zeros from two columns, maybe on different rows 2
Hidden Rows with Auto-Filter 2
auto-filter image 3

Top