Excel Guides

Viewing Two Worksheets At Once in Excel

Viewing two worksheets at once in Excel can be extremely helpful when trying to compare data or make changes to both sheets simultaneously. There are a few different ways that you can view two sheets at the same time:

  1. Open both worksheets in separate windows. To do this, click on the tab for the first sheet that you want to open. Then, hold down the Ctrl key on your keyboard and click on the tab for the second sheet. This will open both sheets in separate windows side-by-side.
  2. Use the Arrange All feature. To use this feature, click on the View tab at the top of the Excel window. Then, click on the Arrange All button in the Window group. In the Arrange Windows dialog box that appears, select how you want to view your worksheets from the Arrangement drop-down menu. You can choose to view your sheets side-by-side, stacked vertically, or tiled.
  3. Use split panes.

    To use split panes, click on the cell where you want to split your worksheet. Then, click on the View

    tab at the top of the Excel window and click on the Split

    button in the Window

    group.



  1. Click on one of the worksheet tabs and then hold down the Ctrl+Page Up keys on your keyboard to quickly move to another sheet.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.