Split the screen in Excel

Split the screen in Excel

HomeHow to, TechSplit the screen in Excel

This article explains how to split the screen in Excel. The instructions apply to Excel versions 2019, 2016, 2013, and Excel for Microsoft 365.

Enable Split Screen in Microsoft Excel

Use Excel's split-screen feature to view multiple copies of the same worksheet. Splitting the screen divides the current worksheet vertically and/or horizontally into two or four sections, allowing you to view the same or different parts of the worksheet.

Splitting the screen is an alternative to freezing panes to keep worksheet titles or headings on the screen as you scroll. In addition, split screens can be used to compare two rows or columns of data that are in different parts of the worksheet.

You can split the Excel screen into four panes using the Split icon on the View tab of the ribbon.

Tagged:
Split the screen in Excel.
Want to go more in-depth? Ask a question to learn more about the event.