Opening multiple windows (01/12/2007)
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.
1. Click on the tab of the worksheet you want to view.
2. Choose New Window from the Window menu.
3. 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.)
4. To see them all at one time, choose Arrange from the Window menu.
5. Select Tiled, Horizontal, or Vertical.
6. Select the Windows Of Active Workbook check box.
7. Click OK.
< More itips