+ Reply to Thread
Results 1 to 3 of 3

HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN.

  1. #1
    Trenner
    Guest

    HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN.

    I have dropdown cells set up which draw from a list on another worksheet, I
    am trying to set it up so that when I start to type within the cell it will
    strat filling from the list.

  2. #2
    paul
    Guest

    RE: HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN.

    if you have a list hidden directly above your input cell as you type excel
    will fill in from the list above.
    --
    paul
    paul.shepherd@nospamparadise.net.nz
    remove nospam for email addy!



    "Trenner" wrote:

    > I have dropdown cells set up which draw from a list on another worksheet, I
    > am trying to set it up so that when I start to type within the cell it will
    > strat filling from the list.


  3. #3
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243
    Hi Trenner,

    Have a look at Debra's pages:

    The start (for background info),
    http://www.contextures.com/xlDataVal01.html

    useful page,
    http://www.contextures.com/xlDataVal10.html

    hth
    Rob Brockett
    NZ
    Always learning & the best way to learn is to experience...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1