Filtering a column and not all cells are available
 

When I try to filter a column which contains numbers from 0 to 9430 not all
those numbers are available to filter by. There are no blank cells in the
filtered column, all cells are formated as numbers. The filter will only
give me 0-6430 as filtered cells.

How do I get all the cells to filter?

Filtering a column and not all cells are available
 

Hi

See this page
http://www.contextures.com/xlautofilter02.html#Limits



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"jkd7058" wrote in message ...
When I try to filter a column which contains numbers from 0 to 9430 not all
those numbers are available to filter by. There are no blank cells in the
filtered column, all cells are formated as numbers. The filter will only
give me 0-6430 as filtered cells.

How do I get all the cells to filter?