Excel
– Creating a New Custom List
Custom lists
are something you can create in advance to save time when using
Excel. For example if you have a list of names of employees
and find you are constantly retyping the names, follow these
steps for an easy solution:
1)
From the Tools menu, select Options
2) Click on the Customs List Tab
3) Click on New List
4) Click in the List entries box, then enter each item in the
list, pressing Enter to move from one entry to the next
5) When complete click on Add and Close
To
test your new list, do the following:
1) Type the first entry in the list into a cell
2) Drag the fill handle, down the workbook to AutoFill several
cells – the customised list should appear
