Split Panes in Excel

Split Excel Sheet (Table of Contents)

Split Panes in Excel
How to Split Panes in Excel?

As you know Excel is very user-friendly software for daily business purpose data manipulation. If you have large data to compare information in your excel sheet, then excel provides split panes ability to view and compare your content in excel workbook. Split panes are very useful to view multiple distant parts of your worksheet at once. Split panes can separate the worksheet into more than one copies so that you can view and compare the data at the same time. Each split panes have its own scroll bars in your worksheet, you can scroll each pane separately.

How to Split Panes in Excel?

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

Example #1 – Split the Excel sheet into Panes Horizontally

Let’s consider a sales data set as shown in the below table to apply the split panes to split the worksheet into panes horizontally.

First, select the cell A5 then Go to the view tab and then click on the split as shown in the below screenshot.

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

Example #2 – Split Excel Sheet into Panes Vertically

Let’s consider the below sales data to apply the split panes to split the excel into vertical panes.

First, select the column B then Go to the view tab and then click on the split as shown in the below screenshot.

Then you will get a vertical splitter in your work sheet as shown in the above screenshot.

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

In this example, we will apply the split pane option to cross split the work sheet.

Let’s consider the below table.

First, select the cell B7 then Go to the view tab and then click on the split as shown in the below screenshot.

By applying this you will get a cross splitter as shown in the below screenshot.

Example #4 – Unsplit the panes

In this example we will unsplit the panes, suppose you have a data on which the split pane is already applied, and you want to remove the split pane option from your worksheet then just go to the view tab and disable the split option to remove the split panes from your worksheet.

Things to Remember About Splitting the Panes in Excel

You can use Alt-W-S shortcut to enable the split panes in your worksheet.

Move the active cell to row 1 to split your worksheet vertically into 2 panes.
Move the active cell to column A to split your worksheet horizontally into 2 panes.
If the select any cell in the middle of somewhere in your worksheet, you’ll get 4 panes or cross panes.

Split Panes in Excel (Horizontally, Vertically, Cross Split)