See Two Sheets within a Workbook Simultaneously

Sometimes it's helpful to see two sheets within the same workbook at the same time. To do so, choose Window, and then New Window. Next, choose Window, Arrange, and then choose Horizontal. Click Windows of Active Workbook, and then click OK. If you want to see the windows side by side, choose Tiled or Vertical in the Arrange dialog box.