Sometimes it would be perfect if we could open(or view) the same workbook twice. This is particularly useful when working on Sheet1 and needing to see data on Sheet2 easily. There is a way!
On the main menu bar:
1. Click Window
2. Select New Window
This opened another copy of the current workbook. To see these more easily do this:
3. Click Window
4. Select Arrange
5. Select the Vertical radio button (or whatever suits your needs) and hit OK .