auto complete replacement list

  • Thread starter Thread starter Tangy
  • Start date Start date
T

Tangy

Is there a file that contains the auto complete data for Excel 03 I have
allot of data to add and there must be a way to do it faster than going in
through the auto complete options and adding them one by one.

Thanks
 
Tangy

Auto Complete or Auto Correct?

Auto complete or "pick from list" is based on what you have entered in
contiguous cells above where you are now entering data.

There is no list saved anywhere that you can edit.

Auto Correct list is added to one by one AFAIK.


Gord Dibben Excel MVP
 
I guess I mean auto correct then. I want it to "pick from list" but not only
from cells above or below the current working cell, I want it to pick from
an master list.
 
Thanks I got Data Validation to work but I still have to pick from a list,
with a list of over 100 names it's still a bit of a pain. Is there a way to
get Data Validation to pop up as I type. i.e Type "Bob" and all the Bobs
will be displayed below and I pick one??
 
Unfortunately, data validation doesn't support autocomplete. If you can
use programming, there's a sample file here that provides a combobox
from which you can select one of the values from the data validation
list. In the combobox, you can enable autocomplete:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Data Validation Combobox'
 
Back
Top