See all How-To Articles

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

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 very 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, make sure you have a file open that contains multiple worksheets.

 

excel view2sheets sheet tabs

 

2. Next, in the Ribbon, select 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 will show that you have two windows of the same book by putting a 2 after the file name.

excel view2sheets titlebar

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

3. Finally, in the Ribbon, select View > Window > Arrange All.

 

excel view2sheets arrange-all

 

4. Select the arrangement type required: Tiled, Horizontal, or Vertical. If there is more than one Excel file open, make sure that Windows of active workbook is ticked.

 

excel view2sheets arrangementtype

 

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

 

excel view2sheets horizontal-view

 

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.

2. Reopen the spreadsheet in that browser.

3. To show both browser windows at the same time, right-click on the Task Bar and select Show Windows side by side.

 

excel view2sheets gs taskbar

 

The browser windows will both be shown on the screen.

 

excel view2sheets gs stacked

 

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