- Excel allows you to view two worksheets in the same workbook side-by-side via the Window option in the View menu.
- You can use the Arrange All option under the View tab to select Tiled, Horizontal, Vertical, or Cascade arrangements and customize the view of side-by-side workbooks.
How to View Two Excel Worksheets Side-by-Side
View Two Worksheets in the Same Excel Workbook Side-by-Side
Step 1: From your PC’s Start menu or Taskbar, click the Microsoft Excel app or workbook to open it.
Step 2: On the Excel Ribbon, click the View tab.
Step 3: In the Window group of the View tab, click New Window . This will create a duplicate of your open workbook.
Step 4: Click the View tab again and View Side by Side within the Window group. This will place both workbooks side by side.
Step 5: Click the sheet you want to compare in each workbook window.
You must ensure the worksheet tabs are showing so you can view them side by side.
View Two Worksheets in Different Excel Workbooks Side-by-Side
Step 1: Open the workbooks with the worksheets that you want to place side-by-side.
Step 2: On the Excel Ribbon, click the View tab.
Step 3: Click the View Side by Side option within the Window group.
Step 4: If you have more than two workbooks open, Excel will launch the Compare Side by Side dialog box. Select the workbook you want to compare and click OK . This will place both workbooks side by side.
Step 5: Once done, click the sheet you want to compare in each workbook window.
Edit the View of Side-by-Side Excel Workbooks
When you enable the View Side by Side option, Excel, by default, will place both worksheets in a Tiled view. However, you can change the view of your worksheets using the steps below:
Step 1: On the Excel Ribbon, click the View tab.
Step 2: Click the View tab, and within the Window group, click Arrange All . This will launch the Arrange Window dialog box.
Step 3: From the following options, select how you want your Excel workbooks stacked:
- Tiled: The windows are arranged as squares of equal size in the order you open them.
- Horizontal: the windows are stacked one below another.
- Vertical: the windows are placed next to each other.
- Cascade: the windows overlap one another.
Step 4: If you want to work with multiple worksheets in a workbook, tick the box for Windows of active workbook .
Step 5: Click OK to save your changes.
