WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Split Panes in Excel

Split Panes in Excel

What does Split Panes in Excel Mean?

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.

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

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.

Split in Excel Example 1

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

Split in Excel Example 1-1

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

Example #2 – Split Panes Vertically

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

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Split in Excel Example 2

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

Split in Excel Example 2-1

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.

Example 3

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

Example 3-1

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

Example 3-2

Example #4 – Unsplit the panes

In this example, we will see unsplit the panes. Suppose you have a date 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. 

Example 4

Things to Remember

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

Alt-W-S shortcut

  • 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.

Recommended Articles

This has been a guide to Split Panes in Excel. Here we discuss how to split panes in excel along with excel examples like horizontally, vertically, cross split panes. You may also look at these useful functions in excel –

  • Split Names in Excel
  • VBA Split Function
  • Split Cells in Excel
  • VBA Split String into Array
  • TANH Function in Excel
4 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More