master list for auto complete data?

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

Tangy

Is it possible to have a master list, in my case it's of names, in a
workbook that excel will use for auto complete data for that workbook?

Thanks
 
Hi Tangy

Go to "Tools>Auto Correct Options", select the "Auto Correct" tab and enter
the abbreviated items and full names for those items you want Excel to
replace. Ensure the relevant boxes are ticked.

--
XL2002
Regards

William

(e-mail address removed)

| Is it possible to have a master list, in my case it's of names, in a
| workbook that excel will use for auto complete data for that workbook?
|
| Thanks
|
|
 
Back
Top