Fill in a list of employees instead of typing the list.
Excel has all sorts of lists you can complete with the fill handle: 1, 2, 3; Mon, Tues; 9:00, 10:00; Quarter 1, Quarter 2; or 15-Jan, 15-Feb.
But Excel can also fill in custom lists that you create, such as a list of employees at your company.
Enter the employee names once, select them, open Custom Lists in the Options dialog box (Tools/Options), and then click Import.
The next time you need to enter the list, type the first name, and then use the fill handle to complete the list. You'll see exactly how to create and fill in a custom list in the practice session.
Tip If a list isn't already available to import, you can type it directly in the Custom Lists dialog box. If you do, remember to press ENTER after each entry, or type them all in one line, but separate each entry with a comma.
