When you are working in a very large Excel worksheet, sometimes you may want to view different areas of the worksheet at the same time. If the worksheet is too large, it is not possible to view different areas of the worksheet at the same time by zooming out the worksheet. There is a feature in Excel, which allows you to split the active worksheet into Split Panes horizontally or vertically. Each Pane has separate scrollbar, so that you can scroll them separately. Once the active worksheet is split into different panes, you can view and compare different areas of worksheet by scrolling horizontally or vertically.
To split an Excel worksheet horizontally at a Row, follow below steps.
Step 1 - Select the Row (or left-most Cell of the Row) where you want to split the worksheet by clicking on its Row number. In this example, I had selected Row 121, as shown in below image.
Step 2 - Click "Split" button from Excel Ribbon > "View" Tab > "Window" Group to split Excel worksheet horizontally, as shown in below image.
Step 3 - Excel splits its worksheet window horizontally along the top-side of the selected Row and displays a Split Pane bar along the top-side of the selected Row horizontally. After splitting the worksheet window horizontally into two different Panes, each pane has its own vertical scroll bar as shown in below image. Both Split Panes spans the entire worksheet so that you can scroll, view and compare different areas of the Excel worksheet at the same time.
If you keep the mouse pointer over the Split Pane bar, the pointer changes to a double headed arrow, as shown in below image. You can change the size of a pane by clicking, dragging and releasing the mouse pointer on Split Pane bar, after its shape changed into double headed arrow.
To remove the Split Panes, simply click the "Split" button again or double click on the Split Pane bar.
An animation about how to split panes horizontally of an Excel worksheet at a Row is copied below.