Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    China, Maine, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dropdown box (Excel 2000)

    I've created a dropdown box using Data Validation, and it shows the valid entries for a cell. But the dropdown box isn't quite long enough, and you have to scroll to see all the choices. How do I make the dropdown box a little longer, so all the entries show? This isn't an ActiveX control or anything like that, just the Data Validation list of choices.
    Thanks,
    Charlie

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

    Re: Dropdown box (Excel 2000)

    The length of the dropdown list for Validation isn't configurable. See if you can use the combo box from the Forms toolbar. Put it over the linked cell. you can set the number of drop down lines by right clicking the combo box and selecting Format Control, Control tab.

Posting Permissions

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