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!

Autocomplete is applicable for the current region. Try these workarounds

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

If this post helps click Yes
---------------
Jacob Skaria


"Yaelikins" wrote:

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!

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

On Tue, 1 Sep 2009 19:56:01 -0700, Yaelikins
wrote:

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!