Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a limit to the amount of space in filter
I am using filters on exell.
Does anynone know if there is a limit to the amount of space in the pop up filter box. I appear to have several lines missing when searching in looking in certain cells??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a limit to the amount of space in filter
I believe Excel2002 displays up to 1,000 unique values in the autofilter
dropdown list. There may be some workarounds to get what you want, depending on your data list structure. *********** Regards, Ron XL2002, WinXP-Pro "ian coney" wrote: I am using filters on exell. Does anynone know if there is a limit to the amount of space in the pop up filter box. I appear to have several lines missing when searching in looking in certain cells??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a limit to the amount of space in filter
Yes, there is a limit of 1000 unique items. However, if you use Custom
then Greater Than and a suitable value, you can see the items that are larger. Hope this helps. Pete |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a limit to the amount of space in filter
Debra Dalgleish offers some more options at:
http://contextures.com/xlautofilter02.html#Limits ian coney wrote: I am using filters on exell. Does anynone know if there is a limit to the amount of space in the pop up filter box. I appear to have several lines missing when searching in looking in certain cells??? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to limit amount of numbers in cells in excel | Excel Worksheet Functions | |||
Can I limit the amount of characters in a cell? | Excel Worksheet Functions | |||
Is there a limit on amount of text that can go into a cell? | Excel Discussion (Misc queries) | |||
Limit the number of rows for a filter | Excel Discussion (Misc queries) | |||
Auto Filter Limit Question | Excel Discussion (Misc queries) |