This tutorial shows how to view two sheets from the same workbook at once in Excel and Google Sheets.
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
- First, open a file that contains multiple worksheets.
- Next, in the Ribbon, go to View > Window > New Window.
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.
Tip: You’re not restricted to just two windows; you can click New Window multiple times to keep opening windows in the same file.
- Finally, in the Ribbon, go to View > Window > Arrange All.
- Choose an arrangement: Tiled, Horizontal, Vertical, or Cascade. If there is more than one Excel file open, tick Windows of active workbook.
- Click OK to arrange the windows of the active workbook in a horizontal format.
View Two Sheets at Once in Google Sheets
- To view two sheets from the same workbook in Google Sheets, open another copy of the browser you’re working in.
- Reopen the spreadsheet in that browser.
- To show both browser windows at the same time, right-click the Task Bar and click Show Windows side by side.
You can see both browser windows on the screen.
Alternatively, drag and size the windows on your screen to suit your environment.