+ Post New Thread
Results 1 to 3 of 3
How do you do....it? Thread, excel 2007 dropdown box select by typing first letter in Technical; looking at a way to make a dropdown list in excel be able to type first letter of item and ...
  1. #1

    Join Date
    May 2008
    Location
    York
    Posts
    515
    Thank Post
    22
    Thanked 48 Times in 45 Posts
    Rep Power
    24

    excel 2007 dropdown box select by typing first letter

    looking at a way to make a dropdown list in excel be able to type first letter of item and it jump down as list is long and it would save loads of time does anyone know how to do this??

  2. #2

    Join Date
    Dec 2007
    Location
    Preston
    Posts
    364
    Thank Post
    14
    Thanked 84 Times in 77 Posts
    Rep Power
    30
    have a look in the office button>excel options>edit custom lists
    is this what you are looking for?

  3. #3

    Join Date
    May 2008
    Location
    York
    Posts
    515
    Thank Post
    22
    Thanked 48 Times in 45 Posts
    Rep Power
    24
    no i can create drop downs what i need is the facility to type the letters of the entry in list and have cursor move down to that section

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 14
    Last Post: 11th April 2014, 10:49 PM
  2. Excel Cat5e Cable 305MTR 38.50+vat Per Box
    By CPLTD in forum Our Advertisers
    Replies: 12
    Last Post: 4th December 2008, 03:39 PM
  3. Replies: 14
    Last Post: 12th September 2007, 10:13 AM
  4. Excel 2007
    By wesleyw in forum How do you do....it?
    Replies: 7
    Last Post: 25th June 2007, 05:39 PM
  5. Excel 2007
    By wesleyw in forum Windows
    Replies: 0
    Last Post: 22nd June 2007, 03:31 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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