Can you add data into the auto-complete list?

[Yaelikins]

Hi,

I've copied a column of names from one spreadsheet into a new one. I want
to get excel to auto-complete the word for me, either in this column and in
other columns, but as i copied the text in, and haven't recently physically
typed it, it doesn't appear in my auto-complete options. Is there a way i
can add to the recent words to appear as auto-complete, or can i trick excel
somehow? We are talking 300 different names, so i don't want to have to type
them again!

I'm desperate! We have a major fundraiser for a school PTA tomorrow, and i
needed this yesterday.... anything to save time will help.

Thanks!

 

[Jacob Skaria]

Autocomplete is applicable for the current region. Try these workarounds

http://www.ozgrid.com/Excel/autocomplete-validation.htm

If this post helps click Yes

 

[Gord Dibben]

Autocomplete works only in one column and only when data is contiguous.

Copying a new set of items into that contiguous range in that column will
produce autocomplete.


Gord Dibben MS Excel MVP