| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I SET UP DROP DOWN CELLS TO AUTO FILL AS I START TYPING IN.
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... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=542310 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| blank cells with auto fill in excel | Excel Worksheet Functions | |||
| Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| Formatting cells Auto fill color using €œIf€ | Excel Worksheet Functions | |||
| Inserting Blank Rows Macro? | Excel Worksheet Functions | |||
Linear Mode
