Arrange Workbook Windows

Learn how to arrange workbooks so they don’t overlap each other and you’re able to view or edit their data without having to switch from one workbook to another.

If you work with multiple Excel workbooks, you can view them at once by arranging them on the desktop. In this tutorial, I will show you how to arrange two or more workbooks in simple steps. I’m using Office 2021 at the time of writing this post if you’re using an older Office version, read this tutorial: Create a Personal View of Your Workbooks.

Follow these step to arrange all opened workbooks:

  1. Open workbooks
  2. Click View tab
  3. Click Arrange All
  4. Choose a view mode from the Arrange Windows dialog box. Excel offers four view modes for arranging workbook windows:
    • Tiled
    • Horizontal
    • Vertical
    • Cascade.
  5. Click OK.
Arrange Windows

Working with two different parts of a workbook at once

You can create multiple windows for a workbook and then arrange them horizontally, vertically, tiled, or cascade view mode. It appears as if there are multiple copies of the worksheet, but they are just separate views of the same worksheet. To create a new window of an opened workbook, follow these steps:

  1. Click the View tab, and
  2. Click New Window.

Repeat the above steps to create more windows for the same workbook. After opening (creating) the desired number of windows, you can arrange them to work on the different parts (or worksheets) on the same workbook simultaneously:

  1. Click Arrange All
  2. Choose a view mode from the Arrange Windows dialog box.
  3. Check the Windows of active workbook check box to arrange only the windows of the current workbook, other workbooks will be ignored.
  4. Click OK

Understanding Workbooks and Worksheets: