Ready to Checkout?

shopping-cart

Try the Excel Course for Free!

Split Panes in Excel – Instructions and Video Lesson

by / Monday, 16 October 2017 / Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365

Split Panes in Excel: Overview

            To split panes in Excel when viewing a large worksheet, use the “Split” command in Excel. This command lets you split the Excel worksheet into different panes. Each pane contains its own horizontal and vertical scroll bars. Therefore, you can scroll each pane separately to view information from different sections of the worksheet. For example, you could split a large worksheet to see column headings in the top row and totals in the bottom row at the same time.

            To split the current worksheet into four separate panes, click the “View” tab in the Ribbon. Then click the “Split” button in the “Window” button group. This lets you scroll each pane to independent sections of the same worksheet. To remove the split panes when finished, click the “Split” button again.

Split Panes in Excel - Instructions and Video Lesson: A picture of a user splitting a large Excel workbook into separate panes.

Split Panes in Excel – Instructions and Video Lesson: A picture of a user splitting a large Excel workbook into separate panes.

Split Panes in Excel: Instructions

  1. To split the current worksheet into four separate panes, click the “View” tab in the Ribbon.
  2. Then click the “Split” button in the “Window” button group.
  3. To remove the split panes, click the “View” tab in the Ribbon.
  4. Then click the “Split” button in the “Window” button group again.

Split Panes in Excel: Video Lesson

            The following video lesson, titled “Split Panes,” shows how to split panes in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2016-2013.”

TOP