::: Excel tips 5 :::

>> Opening multiple windows <<

One of the most frustrating problems for Excel users is viewing all the information they need, especially because it often lives in different worksheets. Let your users know about this simple way to view multiple sheets, and they'll love you forever.
. Click on the tab of the worksheet you want to view.
. Choose New Window from the Window menu.
. Repeat this process for each of the worksheets you want to display. (Excel opens each sheet in a window that sits on top of the previous one.)
. To see them all at one time, choose Arrange from the Window menu.
. Select Tiled, Horizontal, or Vertical.
. Select the Windows Of Active Workbook check box.
. Click OK.

------------------------------------------------------------------------------------
>> Creating custom lists <<

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:
. Select all of the cells containing the information you want to copy.
. Select Options from the Tools menu.
. Click the Custom Lists tab.
. Click Import.
If you want to create a list from scratch in Excel 97, follow these steps:
Go to the Tools menu and choose Custom Lists.
. Click in the List Entries box.
. Type each item for your list, pressing [Enter] after each item.
. When you're finished, click OK to create the list.
To create a list from scratch in Excel 2000/XP, follow these steps:
. Select Options from the Tools menu.
. Click the Custom Lists tab.
. Type each item in the List Entries box, pressing [Enter] after each one.
. 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.