Search

How to split panes an Excel worksheet at a Row horizontally

 

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.

 Split Panes Row Select Row

Step 2 - Click "Split" button from Excel Ribbon > "View" Tab > "Window" Group to split Excel worksheet horizontally, as shown in below image.

 Click Split button to split Panes horizontally

 

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.

 Worksheet panes split horizontally

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.

 split pane resize horizontally mouse pointer

 

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.

 How to Split Panes Rows Horizontally

 

Related Tutorials
• How to Freeze Pane at Rows in Excel worksheet
• How to Freeze Pane at Columns in Excel worksheet
• How to Freeze Pane Rows and Columns in Excel worksheet
• How to unfreeze frozen Rows or Columns in Excel worksheet
• How to split panes an Excel worksheet at a Column vertically
• How to split Excel worksheet horizontally and vertically into four panes
• Difference between Freeze Panes and Split Panes of Excel worksheet