Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing autocomplete to lookup from a range of cells
By default, when you're typing in a cell entry, Autocomplete finds
matching entries from the previous entries above in the same column. Is there a way to force Autocomplete to lookup values from a designated range of cells? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing autocomplete to lookup from a range of cells
I don't think so.
Maybe you could use an alternate method--either Data|Validation to choose from a dropdown. Or a combobox from the Control toolbox toolbar (which allows you to set the ..matchentry to do the same kind of thing as autocomplete). Nick Hebb wrote: By default, when you're typing in a cell entry, Autocomplete finds matching entries from the previous entries above in the same column. Is there a way to force Autocomplete to lookup values from a designated range of cells? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing autocomplete to lookup from a range of cells
I've decided what I'll do is seed the column with a list of valid
entries at the top of the sheet, then hide those rows. Then I can set my validation list range to the hidden cells. That way, I get the autocomplete, the dropdown list, and the validation capability. --Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of a range of cells that include cells using LOOKUP | Excel Worksheet Functions | |||
trouble with lookup in a range of cells. | Excel Worksheet Functions | |||
Lookup through a Range of Values in different cells | Excel Discussion (Misc queries) | |||
if function or lookup??? across a range of cells in a row. | Excel Worksheet Functions | |||
lookup and return range of cells | Excel Worksheet Functions |