Compare different parts of excel worksheet using Split

Use the split box to split excel worksheet horizontally or vertically to see different parts. Splitting the worksheet can be useful in comparing two rows or columns of data located in different parts of worksheet. We can use it as an alternative to freeze panes to keep worksheet titles or headings on screen as we scroll down the worksheet.

2. You can see that the sheet is divided into four parts from the selected cell.

3. You can scroll different sides of worksheet to view different parts. For example, use the lower vertical scroll bar to move to row 26 and use upper vertical scroll bar to move to row one to see the title. You can see that first 8 rows are still visible.

4. To move vertical or horizontal scrollbar, just drag it to required cell