If you want to view different distant parts of a worksheet of Excel at once on your screen, you can split the worksheet in Excel by following steps:
3. Excel will create a horizontal line and two vertical scroll bars, by using them you can view line no 21 while keeping line no 7 visible at once.
4. To remove the split, simply double-click on it or press one by one Alt, W, and S.
Note: You may split the worksheet horizontally or into a left and right pane by clicking on a column where you want the split then repeat same above-mentioned steps.