In Excel freeze panes to compare information, and use view options in Excel to more easily read Excel spreadsheets.
If your workbook contains a lot of content, it can sometimes be difficult to compare different sections. Excel includes additional options to make your workbooks easier to view and compare. For example, you can choose to open a new window for your workbook or split a worksheet into separate panes.
Excel allows you to open multiple windows for a single workbook at the same time. In our example, we'll use this feature to compare two different worksheets from the same workbook.
If you have several windows open at the same time, you can use the Arrange All command to rearrange them quickly.
Sometimes you may want to compare different sections of the same workbook without creating a new window. The Split command allows you to divide the worksheet into multiple panes that scroll separately.
After creating a split, you can click and drag the vertical and horizontal dividers to change the size of each section.
To remove the split, click the Split command again.