Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    No. of Filter Items (Excel 2000)

    It appears that you can have up to 1,000 items, but Is there a way of increasing this?

    This is more of a curiosity than anything else. If I need something that isn't listed then I just use the "custom" option.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: No. of Filter Items (Excel 2000)

    I don't understand WHY you would want to.
    Personally, I hate to scroll through a list of even 50 items let alone 1,000!

    It would be better to have groups and subgroups to filter. 20 groups each with 20 subgroups each with 20 subsub groups yields 8,000 entries but it is easier to go through the 3 lists of 20 than to go through 1 list of 8,000!

    You also have the custom list pinpoint.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •