Results 1 to 2 of 2

Thread: Drop-down list in Excel Workbook

  1. #1

    Red face Drop-down list in Excel Workbook



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a drop-down list in Excel Workbook where the list range is from A1:A100 including 100 department names.

    To find a department name start with S, I will have to open the list and scroll down until I reach all Dpets names that start with S and then try to find the required name.

    There is a way where you select the first option (the top of the list) and press S and it will take you directly to the first Dept name started with S.
    Also, you can keep entering S and it will scroll down through all names start with S.
    I appreciate your help. Thank you.

  2. #2
    Conjurer Roger Govier's Avatar
    Join Date
    Mar 2011
    Location
    Located near Abergavenny, South Wales, UK
    Posts
    113
    Articles
    0
    Hi

    No you can't do it with ordinary DV.
    You would need to use a Combo box.
    Full instructions can be found here
    http://www.contextures.com/xlDataVal10.html
    Regards

    Roger Govier
    Microsoft Excel MVP
    http://www.technology4u.co.uk

Posting Permissions

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