As far as I remember, in order for the Auto-Complete" to work - you have to
type the additional street name in the SAME(!) column without leaving blank
cells.
Micky


"Its me" wrote:

Hi
I have a worksheet with all of the names of the streets in my area in one
col.
I have hidden this data and assumed when I went to type in the same street
name it would auto-complete which it isn't
Any ideas how this works or how to activate? I am using 2003
Many thanks
Stephen
Gold Coast Australia

.