Spliting the Worksheet Window
When working in Excel, it can sometimes be helpful to split the worksheet into two separate, so that you can compare data in the sheet.
To split the window:
- Click where you want to split the window.
- On the VIEW tab, in the Window group, select Split.
- You can now scroll through each window separately to easily view and compare data.