Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill with custom list
Is there a way to make a list of certain items, and use that as a auto fill
list? for example on a seperate sheet, when I start writing a word, it should auto fill it? (I'm not talking about the custom list from the drag / fill feature). For example, I want to make, that when I start writing for example, "milk" and milk is on the custom list that I created, then when I type "mi" it should auto fill it with milk. and so on. I have a long list. Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill with custom list
Go to... Tools | Options | Edit (tab) ... "Enable AutoComplete for Cell Values" should be check marked. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "art" wrote in message Is there a way to make a list of certain items, and use that as a auto fill list? for example on a seperate sheet, when I start writing a word, it should auto fill it? (I'm not talking about the custom list from the drag / fill feature). For example, I want to make, that when I start writing for example, "milk" and milk is on the custom list that I created, then when I type "mi" it should auto fill it with milk. and so on. I have a long list. Please help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill with custom list
That feature works only if the previously entered text is in the same column on
one sheet. I know of no way to have autocomplete on a separate sheet Gord Dibben MS Excel MVP On Tue, 17 Jul 2007 12:34:40 -0700, "Jim Cone" wrote: Go to... Tools | Options | Edit (tab) ... "Enable AutoComplete for Cell Values" should be check marked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Auto fill | Excel Discussion (Misc queries) | |||
Custom auto fill question | Excel Discussion (Misc queries) | |||
Auto-Fill in List Fields? | Excel Worksheet Functions | |||
Auto Fill using a list of students | Excel Discussion (Misc queries) | |||
Auto Fill using a list of students | Excel Discussion (Misc queries) |