Opening Two Excel Windows

How to Work with Multiple Windows in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Opening Two Excel Windows

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

Switch Between Windows from the Taskbar

  1. Hover over the Excel icon in the taskbar.

    A preview of each open window appears above the taskbar.

  2. Click a thumbail to make it the active window.
    Switch Between Windows from the Taskbar

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.
    Switch Between Windows from the Taskbar

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.
    Arrange Windows
  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.
    Arrange Windows

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