| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display specific rows from table on other worksheet | Excel Discussion (Misc queries) | |||
| How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
| Importing Data From Another Spreadsheet | Excel Discussion (Misc queries) | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
| Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) | |||
Linear Mode
