Viewing two worksheets at once in Excel can be extremely helpful when trying to compare data or make changes to both sheets simultaneously. There are a few different ways that you can view two sheets at the same time:
Use split panes.
To use split panes, click on the cell where you want to split your worksheet. Then, click on the View
tab at the top of the Excel window and click on the Split
button in the Window