I'd remove the autofilter arrows and then select the entire range to filter and
reapply the autofilter.

If this doesn't help, you may want to share the version of excel you're using.
It may help a potential responder.

John Keith wrote:

A co-worker asked me to look at his spreadsheet and try to fix his
autofilter. The autofilter would only select down through row 30 while
his data went down to row 70 or something. There was no blank row in
the dataset. I tried removing and reapplying the autofilter, same
problem. Are there other conditions that cause autofilter to not
select the full data range?

John Keith


--

Dave Peterson