You might have data that is reused many times, for example,
the name list of people in your company. You can predefine a list
for frequently used data. Lists without simple text are ignored. After
you predefine the list, you can enter your data by entering the first
value and dragging the cursor.
Microsoft® Excel
2003
To predefine a list, do the following steps:
- Click tab.
- Make sure that New List option is selected
in the Custom lists field. In the List
entries field, specify your list and use a comma to separate
each other.
- Click Add to add the list.
- Click OK to close the window.
IBM® Lotus® Symphony™ Spreadsheets
To
predefine a list, do the following steps:
- Click tab.
- Click New to specify your list in the Entries field.
Use a comma to separate each other.
- Click Add to add the list.
- Click OK to close the window.