Arranging 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:

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.