Arranging Workbook Windows

If you have more than one workbook open at a time, Excel allows you to view all the workbooks at the same time, and to arrange each workbook window as you desire. The easiest method of arranging workbook windows is as follows, if you are using a version of Excel prior to Excel 2007:

1. Choose Arrange from the Window menu. This displays the Arrange dialog box. (Click here to see a related figure.)
2. The Tiled option should be selected. Click on OK. This divides the screen space evenly between all your workbooks. The main benefit is that each workbook gets at least a piece of the screen.
3. Click on the window whose size you wish to adjust. It becomes active.
4. Move the mouse cursor near the border of the active window. When the cursor turns into a set of arrows, click the mouse button and drag the window edge to the desired size. Release the mouse button.
5. Repeat steps 3 and 4 for each window you want to adjust.

If you are using Excel 2007, follow these steps instead:

1. Display the View tab of the ribbon.
2. In the Window group click the Arrange All tool. Excel displays the Arrange Windows dialog box.
3. The Tiled option should be selected. Click on OK. This divides the screen space evenly between all your workbooks. The main benefit is that each workbook gets at least a piece of the screen.
4. Click on the window whose size you wish to adjust. It becomes active.
5. Move the mouse cursor near the border of the active window. When the cursor turns into a set of arrows, click the mouse button and drag the window edge to the desired size. Release the mouse button.
6. Repeat steps 4 and 5 for each window you want to adjust.