Display multiple pages

Question

I want to have two pages open simultaneously so I can compare numbers across tabs.

Answer 1

Hi Michael Osborne,

Yes, this is supported in Excel for Windows.

Open the workbook, then go to View > New Window. This opens a second view of the same workbook (you’ll usually see :2 added to the workbook name in the title bar).

In one window, select the first worksheet, and in the other window select the second worksheet. Then go to View > View Side by Side to see them at the same time. Once enabled, Synchronous Scrolling becomes available if you want both sheets to scroll together.

If you want the layout arranged more neatly, you can also use View > Arrange All and choose a vertical or horizontal layout.

Note: This does not create a separate copy of the file. Both windows are simply different views of the same workbook. Closing either window is safe and does not affect your data.

Please let me know if this proves useful to you, or if you would like further assistance.

I'm looking forward to your reply.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

In Excel for Windows, open the sheets you want and then use Excel’s window features to view them at the same time.

To view two worksheets of different workbooks side by side:

1. Open both workbooks.
2. Go to the View tab, Window group, and click View Side by Side.
3. If prompted, choose which workbook to compare with.
4. In each workbook window, click the sheet tab you want to compare.
5. (Optional) Turn on Synchronous Scrolling on the View tab so both sheets scroll together.

To view multiple worksheets (including in the same workbook):

1. Open the workbook(s) that contain the sheets.
2. If the sheets are in the same workbook:
   • Select a sheet.
   • On View > Window, click New Window.
   • Repeat for each sheet you want to see.
3. On View > Window, click Arrange All.
4. Under Arrange, choose how you want the windows laid out (for example, Vertical or Horizontal).
5. If all sheets are in the same workbook, select Windows of active workbook.

You can then compare numbers across the visible sheets side by side.

---

References:

• Compare two or more worksheets at the same time
• Video: View files in split and multiple windows