Here's another timesaving tip to pass on to your users. If they often make use of the same lists of data, you can teach them to create a custom list instead of typing the same information repeatedly.

For all versions of Excel, if the data is already in a worksheet, follow these steps:

1.       Select all of the cells containing the information you want to copy.

2.       Select Options from the Tools menu.

3.       Click the Custom Lists tab.

4.       Click Import.

If you want to create a list from scratch in Excel 97, follow these steps:

1.       Go to the Tools menu and choose Custom Lists.

2.       Click in the List Entries box.

3.       Type each item for your list, pressing [Enter] after each item.

4.       When you're finished, click OK to create the list.

To create a list from scratch in Excel 2000/XP, follow these steps:

1.       Select Options from the Tools menu.

2.       Click the Custom Lists tab.

3.       Type each item in the List Entries box, pressing [Enter] after each one.

4.       Click Add.

To use a custom list, type the first entry of the list. Use the fill handle at the bottom right corner of the cell to drag the whole list across adjacent cells.

Comment an article   Name   E-mail    Title Available characters: 4000  Notify me of follow-up comments Enter what you see:

No comment posted