How to Split Panes in Excel: Step-by-Step Guide

To split panes in Excel, go to the View tab and click Split. This divides the worksheet into separate scrollable sections so you can see different areas at once.

Syntax

In Excel, splitting panes is done through the ribbon interface, not by typing a formula. The main command is:

• View > Split: Divides the worksheet into multiple panes.

You can also split panes by selecting a cell and then clicking Split. The split lines appear above and to the left of the selected cell.

excel

No formula code; use the Excel ribbon commands as follows:
1. Select a cell where you want to split.
2. Go to the View tab.
3. Click the Split button.

Example

This example shows how to split panes at cell B2 to view the top-left and bottom-right parts of the worksheet simultaneously.

excel

1. Click cell B2.
2. Go to the View tab on the ribbon.
3. Click the Split button.

Result: The worksheet splits into four panes divided by horizontal and vertical lines above row 2 and left of column B.

You can scroll each pane independently to compare data easily.

Output

Worksheet divided into four scrollable panes with split lines above row 2 and left of column B.

Common Pitfalls

Common mistakes when splitting panes:

• Not selecting a cell before clicking Split splits at the current active cell, which may not be where you want.
• Forgetting to remove the split by clicking Split again can confuse navigation.
• Trying to split panes using formulas or shortcuts that do not exist.

Always select the correct cell before splitting and remember to turn off the split when done.

excel

Wrong way:
- Click Split without selecting a cell (splits at active cell, possibly wrong place).

Right way:
- Select the desired cell first, then click Split.

Quick Reference

Action	Description
Select Cell	Choose the cell where you want the split lines to appear above and left.
View > Split	Click this button to split the worksheet into panes.
Scroll Panes	Each pane scrolls independently to view different data.
Remove Split	Click Split again to remove the pane division.

Key Takeaways

Use the View tab's Split button to divide your worksheet into scrollable panes.

Select the cell where you want the split lines before clicking Split for precise control.

You can scroll each pane independently to compare different worksheet areas.

Click Split again to remove the pane division when finished.