View Two Sheets From the Same Workbook in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on July 29, 2023

This tutorial shows how to view two sheets from the same workbook at once in Excel and Google Sheets.

excelview2sheetsintro

Excel, you often have a workbook with multiple sheets. It’s often useful to see more than one sheet on the screen at the same time. You can open multiple files at once and view them in different windows, and you can do the same with sheets in a single workbook.

View Two Sheets at Once

  1. First, open a file that contains multiple worksheets.

excel view2sheets sheet tabs

  1. Next, in the Ribbon, go to View > Window > New Window.

excel view2sheets newwindow

Now you can switch to the new window and move to a different sheet. The title bar in Excel shows that you have two windows of the same book by putting a 2 after the file name.

excel view2sheets titlebar

Tip: You’re not restricted to just two windows; you can click New Window multiple times to keep opening windows in the same file.

  1. Finally, in the Ribbon, go to View > Window > Arrange All.

excel view 2 sheets arrange all

  1. Choose an arrangement: Tiled, Horizontal, Vertical, or Cascade. If there is more than one Excel file open, tick Windows of active workbook.

excel view 2 sheets arrangement type

  1. Click OK to arrange the windows of the active workbook in a horizontal format.

excel view2sheets horizontal-view

Tip: See a list of your worksheets if there are many.

View Two Sheets at Once in Google Sheets

    1. To view two sheets from the same workbook in Google Sheets, open another copy of the browser you’re working in.
  1. Reopen the spreadsheet in that browser.
  2. To show both browser windows at the same time, right-click the Task Bar and click Show Windows side by side.

excel view2sheets gs taskbar

You can see both browser windows on the screen.

excel view2sheets gs stacked

Alternatively, drag and size the windows on your screen to suit your environment.

AI Formula Generator

Try for Free

See all How-To Articles