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 window as you desire. The easiest method of arranging workbook windows is as follows:

1. Choose Arrange from the Window menu. Excel displays the Arrange Windows dialog box. (Click here to see a related figure.)
2. Make sure the Tiled option is selected. (This divides the screen space evenly between all your windows. The main benefit is that all your workbook windows get at least a piece of the screen.)
3. Click on OK. The windows are all displayed.
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, press 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.