#How to keep headers in excel 2016 when scrolling how to#
The steps below cover how to split the Excel screen both horizontally and vertically using the Split feature.Īlthough data doesn't need to be present for split screens to work, it makes it easier to understand how the feature works if a worksheet containing data is used. Splitting the Screen Both Horizontally and Vertically This option works by adding both horizontal and vertical split bars to the worksheet.Įach pane contains a copy of the entire worksheet and the split bars can be manipulated individually or together to allow you to see various rows and columns of data at the same time.
![how to keep headers in excel 2016 when scrolling how to keep headers in excel 2016 when scrolling](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2013/04/excel-2010-edit-header-5.jpg)
You can split the Excel screen into four panes using the Split icon located on the View tab of the ribbon. In addition, split screens can be used to compare two rows or columns of data located in different parts of the worksheet. Splitting the screen is an alternative to freezing panes to keep worksheet titles or headings on screen as you scroll. Splitting the screen divides the current worksheet vertically and/or horizontally into two or four sections allowing you to see the same or different areas of the worksheet. Use Excel's split-screen feature to view multiple copies of the same worksheet. Click on the Split icon to divide the screen into four parts.The instructions apply to Excel versions 2019, 2016, 2013, and Excel for Microsoft 365. This article explains how to split the screen in Excel. To reduce the number of screens to two, drag one of the two split bars to the top or right side of the screen.Reposition the split bars by clicking and dragging.
![how to keep headers in excel 2016 when scrolling how to keep headers in excel 2016 when scrolling](https://i.ytimg.com/vi/T-GN7bBcq7w/maxresdefault.jpg)
Go to View > Split to divide the screen into four parts. To remove all split screens, select View > Split again.