Data Filter - Not all rows in spreadsheet will display in Autofilt
 

I have a large spreadsheet from a query with 13,980 rows. I have sorted the
spreadsheet so that Column D is in numerical order.

When I put on the Data Filter - Autofilter, I can only display up to 1020 of
the 6960 numbers.

I have tried reformating the cell with the Data Filter off. The actual cell
looks like a formula: ="000000000001". No matter how I reformat the cell it
continues to display the formula and I continue to display only up to 1020.

--
Excel Help

Hi

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

You can also use my Filter Add-in to see all the numbers also
http://www.rondebruin.nl/easyfilter.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Excel Help" wrote in message ...
I have a large spreadsheet from a query with 13,980 rows. I have sorted the
spreadsheet so that Column D is in numerical order.

When I put on the Data Filter - Autofilter, I can only display up to 1020 of
the 6960 numbers.

I have tried reformating the cell with the Data Filter off. The actual cell
looks like a formula: ="000000000001". No matter how I reformat the cell it
continues to display the formula and I continue to display only up to 1020.

--
Excel Help