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