Search

How to split Excel worksheet horizontally and vertically into four panes

 

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. Once the active worksheet is split into different panes, you can compare different areas of worksheet by scrolling horizontally or vertically. Each Pane has separate scrollbar, so that you can scroll them separately.

You can split Excel worksheet window into two or four Panes. When you split Excel worksheet window horizontally or when you split Excel worksheet window vertically, you split Excel worksheet window into two Split Panes. When you split Excel worksheet window into horizontally and vertically, you split Excel worksheet window into four Split Panes.

To split an Excel worksheet horizontally and vertically into four Split Panes, follow below steps.

Step 1 - Select the Cell where you want to split the Excel worksheet window to four panes horizontally and vertically. The selected Cell will become the top-left corner Cell of the bottom-right pane, after Excel split the worksheet window into four Split Panes. In this example, Cell address C351 is selected as shown in below image.

 Select the Cell where you want to split horizontally and vertically

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 and vertically

Step 3 - Excel splits its worksheet window horizontally and vertically into four panes as shown in below image and displays two Split Pane bars horizontally and vertically with their point of intersection at the top-left corner of the selected Cell. Note that the Cell pointer we had selected (Cell address C351) to split the Excel worksheet into four panes became the top-left corner Cell of the bottom-right pane.

 Worksheet panes are split four horizontally and vertically

If you keep the mouse pointer over any of the split 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 after its shape changed into double headed arrow.

To remove the split panes, simply click the "Split" button again.

 Four split panes vertically resize mouse pointer

 

 Four split panes horizontally resize mouse pointer

 

An animation about how to split excel worksheet window into four panes horizontally and vertically is copied below.

 How to Split Excel worksheet Panes into four panes horizontally and vertically

 

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 Row horizontally
• How to split panes an Excel worksheet at a Column vertically
• Difference between Freeze Panes and Split Panes of Excel worksheet