Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
size limitations on auto filter
Does anyone know the size limitations for using the auto filter function? I
need to know how many rows it will filter. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
size limitations on auto filter
It'll filter the whole sheet (all 65536 rows (-1 for the header)). But only the
first 1000 unique entries will appear in the dropdown. You can still use custom to specify any of the others, though. Debra Dalgleish has some workarounds at: http://www.contextures.com/xlautofilter02.html#Limits jeo1 wrote: Does anyone know the size limitations for using the auto filter function? I need to know how many rows it will filter. Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
size limitations on auto filter
The limitation is 1,000 different items (ie, 1,000 items in the drop down list). jeo1 Wrote: Does anyone know the size limitations for using the auto filter function? I need to know how many rows it will filter. Thanks -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=530916 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
Have you had a problem with Auto Filter freezing? | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |