Home |
Search |
Today's Posts |
#1
|
|||
|
|||
autocomplete?
I'm trying to figure out if there is a way that I can use some sort of
autocomplete for filling in columns for predefined worksheets. for example: in column A rows 50 through 60 I have information that If I type in any thing that matches in rows 1 through 10 then autocomplete will come into play. (ie. if I have words such as one, two, three, etc. and in row 1 I typed in O then autocomplete would show me an option to enter the word one, tw would opt for two, etc.) Is there a way to do this? |
#2
|
|||
|
|||
Autocomplete depends on how far the existing entries are from the cell you're
typing (in the same column). Maybe you could add a bunch of rows at the top of the worksheet and add your list, then hide those rows. Gary wrote: I'm trying to figure out if there is a way that I can use some sort of autocomplete for filling in columns for predefined worksheets. for example: in column A rows 50 through 60 I have information that If I type in any thing that matches in rows 1 through 10 then autocomplete will come into play. (ie. if I have words such as one, two, three, etc. and in row 1 I typed in O then autocomplete would show me an option to enter the word one, tw would opt for two, etc.) Is there a way to do this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autocomplete numbers help pls! | Excel Discussion (Misc queries) | |||
Autocomplete function | Excel Discussion (Misc queries) | |||
Autocomplete question | Excel Discussion (Misc queries) | |||
Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) |