Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
Splitting panes in excel means splitting a workbook in different parts, this technique is available in the windows section of the View tab, panes can be split in horizontal or vertical way or it can be a cross split, the horizontal and vertical split can be seen in the mid-section of the worksheet however cross split can be done by dragging the panes.
Split Panes in Excel (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. These are very useful to view multiple distant parts of your worksheet at once. It 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 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 worksheet 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 worksheet.
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 –