Split in Excel

Split in Excel

If your Excel sheet has a lot of rows or columns and you have to scroll a lot to review them, Split is the answer to your problem. You can simple split your sheet into two horizontal and vertical panes which you can easily operate to review or compare different rows or columns.

To split your sheet, follow the steps below:

1. Open you MS Excel file

2. On VIEW tab and under the Window group, click on Split


3.This will split your screen into 4 panes.

4 panes

4. In this example, we will only split the screen in two horizontal panes, therefore we will remove the vertical split by double clicking on the vertical bar.

split by double clicking

5. You can operate between both panes freely

panes freely

6. You can also remove the horizontal split by double clicking the horizontal bar or simply clicking the Split button on VIEW tab.