Opening Multiple Windows: MS Excel

Dennis Faas's picture

One of the most frustrating problems for Excel users is viewing all the information they need, especially because it often lives in different worksheets. Below is a simple way to view multiple sheets in one session.

  1. Launch Microsoft Excel (if it isn't already open).
  2. Choose New Window from the Window menu. If you don't see the Window menu, it just means that you have to use the down arrow because you aren't set up to see full menus. To correct that, click on Tools | Customize | Options Tab | and check Always show full menus.
  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.

That's it!

Visit Carol's web site to learn more tips like this one!

| Tags:
Rate this article: 
No votes yet