Split Panes in Excel

Last Updated :

21 Aug, 2024

Blog Author :

Edited by :

Reviewed by :

Table Of Contents

What does Split Panes in Excel Mean?

Splitting panes in Excel means breaking a workbook into different parts. This technique is available in the "View" tab's "Windows" section. We can split panes horizontally or vertically, or it can be a cross split. The horizontal and vertical split can be seen in the mid-section of the worksheet. However, we can do a cross split by dragging the panes.

What does Split Panes in Excel Mean?

How to Split Panes in Excel? (with Examples)

Let’s understand the working of split panes by the below simple examples.

Example #1 - Split Panes Horizontally

As shown in the table below, let us consider a sales data set to apply the split panes to split the worksheet into panes horizontally. Split in Excel Example 1

First, select cell A5, and go to the "View" tab. Then, click on the "Split," as shown in the screenshot below.

Then you will get a horizontal splitter in your worksheet now. You can compare the data by scrolling.

Example #2 - Split Panes Vertically

Let us consider the below sales data to apply the split panes to split the Excel into vertical panes.

First, select column B, go to the "View" tab, and then click on the "Split," as shown in the screenshot below.

Then, you will get a vertical splitter in your worksheet, as shown in the above screenshot.

Example #3 - Insert a Cross Split Pane into a Worksheet

We will use the "Split Pane" option in this example to cross-split the worksheet.

But, first, let us consider the below table.

First, select cell B7, go to the "View" tab, and then click on the "Split," as shown in the screenshot below.

By applying this, you will get across the splitter, as shown in the below screenshot.

Example #4 - Unsplit the panes

In this example, we will see the panes unsplit. Suppose you have a date on which the split pane is already applied. If you want to remove the "Split" pane option from your worksheet, then go to the "View" tab and disable the "Split" option to remove the split panes from the worksheet.

Things to Remember

We can use the "Alt+W+S" shortcut keys to enable the split panes in the worksheet.

We must move the active cell to row 1 to split the worksheet vertically into two panes.
We must move the active cell to column A to split the worksheet horizontally into two panes.
If we select any cell in the middle of somewhere in the worksheet, we will get 4 panes or cross panes.