| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Promting Text?
Dear All,
Column A contains a list of my school pupils. Against their names in column B I have started to input their favourite food. Some of their choices accur several times. Is there a means by which Excel can prompt me what I'm typing, e.g. if I start typing "Fi..." it offers "fish and chips" as this was written above? Yours in appreciation, Neil |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Promting Text?
Hi Neil, I have uploaded one file for you at (created in EXCEL 2007):-
www.pierrefondes.com If you check out this file I have shown you how to set up what you want. Please click on Yes if my posting has been helpful to you. Thanks. "Neil Pearce" wrote: Dear All, Column A contains a list of my school pupils. Against their names in column B I have started to input their favourite food. Some of their choices accur several times. Is there a means by which Excel can prompt me what I'm typing, e.g. if I start typing "Fi..." it offers "fish and chips" as this was written above? Yours in appreciation, Neil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| promting a number in cell | Excel Discussion (Misc queries) | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
Hybrid Mode
