Arranging Windows Automatically

If you want all your open workbook windows visible on-screen, you can move and resize them manually — or you can have Excel do it automatically. Follow these steps to make all open workbooks visible on the Excel screen:

1. Click the View tab in the Ribbon.
2. Click the Arrange All button. Excel displays the Arrange Windows dialog box.
3. Choose from the Tiled, Horizontal, Vertical, or Cascade options.
   
   
   
   
   
   
4. Click OK.

You can save the layout of your open workbooks for future use.