| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Autofilter number of records
I have a very big spreadsheet. When it goes over 1,000, not all records will
show in filter. It will leave out the records at the bottom of the spreadsheet. I just went to an Excel class, and they said it's probably set to 1,000, but autofilter could actually filter to 60,000 records. How do you change that? -- Ginger |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
| Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
| How do I show number of records that meet criteria filter | Excel Discussion (Misc queries) | |||
| How to count number of occurences in an autofilter list | Excel Worksheet Functions | |||
| Number of records by Month that meet a specific requirement | Excel Worksheet Functions | |||
Threaded Mode
