Create automatic data in Microsoft Excel (NEW LIST)
Wednesday, April 4th, 2007To create an automatic data in Microsoft Excel is easy.
The advantage of using automatic data is we as a user, do not need type a routine words. For example, we have the list below:
Acapulco
Miami
Puerto Rico
San Francisco
San Juan
The step to create new list:
Click Tools
Click Options
Click Custom Lists tab
Click NEW LIST to create
The cursor will move to List Box Entries
Type the all cities name lists that we have
Don’t forget press ENTER after you type any city.
Click Add then click OK
To see the result, you just type Acapulco then move the mouse to the bottom on the right corner and it show plus sign.

After you click and drag you should see ..

So when we need those lists, we just type Acapulco then click & drag to show the rest of the words.