Can you add data into the auto-complete list?

  • Thread starter Thread starter Yaelikins
  • Start date Start date
Y

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!
 
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
 
Back
Top