Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Validation Drop down size (Excel 2003 SP2)

    A coworker asked if you can increase the number of rows displayed in the drop down when doing a Data Validation using a list.
    I told him I thought it was fixed, but would ask the people that Know All (thats you guys).

    Thanks,
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Data Validation Drop down size (Excel 2003 SP2)

    The dropdown list shows at most 8 items, and you are correct that this caanot be changed.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Data Validation Drop down size (Excel 2003 SP2

    <img src=/S/nope.gif border=0 alt=nope width=15 height=15>

    Maximum is 8 I am afraid
    Jerry

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Validation Drop down size (Excel 2003 SP2

    HansV and Jezza,
    Thanks for the fast response. I thought that was the case.

    Jezza, do not be afraid, it's OK. <g>

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Data Validation Drop down size (Excel 2003 SP2

    <img src=/S/hiding.gif border=0 alt=hiding width=70 height=24> <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  6. #6
    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: Data Validation Drop down size (Excel 2003 SP2)

    You got the answer, but as an alternative the combobox from tht FORMS toolbar or the control toolbox can be used and allow a more expanded list.

    Steve

  7. #7
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data Validation Drop down size (Excel 2003 SP2)

    Steve,

    Thanks for the workaround. I will pass that info on.
    Have a great day.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

Posting Permissions

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