auto filter not working on all data

K

Kaddy

I have used autofilter for a long time and have not encountered this before.
5000 rows of data - autofilter has been working normally for months.
Yesterday a filter stopped at row 4307, nothing below is filtered. All
columns are affected. There are no blank rows, I reformatted the text to
match above rows and nothing has helped. Suggestions?
 
D

Debra Dalgleish

Turn off the AutoFilter, select the entire table, then turn on the
AutoFilter.
 
K

Kaddy

Thank you.

I tried that. The problem was that column A (which was hidden) did not have
data in it past a certain point. Once I added info to this column the filter
recognized the entire table.
 

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

Alternate Row Shading with Filter 1
Filtering data 2
remembering the same filtering criteria 13
Worksheet fails to filter at times 0
Eliminate blanks while copy row and transpose 11
Excel Auto Filter Problem 2
Delete rows autofilter range problem 5
Auto Filter - It's broken! Help! (Office '03) 2

Top