Split Excel Sheet (Table of Contents)
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.
This has been a guide to Split Panes in Excel. Here we discuss its How to Split Panes in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –