Opening Two Excel Windows

If you have more than one workbook open, you can quickly switch between them.

Switch Between Windows from Excel

1. Click the View tab.
2. Click the Switch Windows button.
3. Select the file you want to make active.
   

The selected file becomes the active workbook.

Arrange Windows

You can stack your open Excel windows in a few different ways to maximize the on-screen data.

1. Click the View tab.
2. Click the Arrange All button.
   
3. Select an arrangement option.
   • Tiled: Windows are arranged as equally sized, tiled squares.
   • Horizontal: Windows are arranged horizontally from top to bottom on the screen.
   • Vertical: Windows are arranged vertically from left to right on the screen.
   • Cascade: Windows are arranged in an overlapping cascade on the screen.
4. Click OK.
   

The windows are arranged on the screen according to the selection you made.