Select the range you want to include before you apply the filter.
--
David Biddulph

"Stuart E" wrote in message
...
Hi I'm trying to place a data filter at the top of a column that can sort
the
data within that column. The filter works but it doesn't cover the whole
column some of the info is not shown as an option to select when I try to
use
the filter. It seems to be the data at the bottom of the sheet from approx
line 500 onwards