The steps above don’t work only for single Excel files. You can repeat the same process for horizontal splitting, and you can reposition the split at any given time.When you split the screen, Excel will copy all of the data into the newly formed pane.Place the line where you want to split the screen and release the mouse button.Drag the pointer up or down, and the line will follow.Hold down the left mouse button, and you will see a dark line appear above the first row in the file.The pointer will then change into a black arrow with two points. Place the pointer just above the vertical scroll bar.Unlike the newer versions, Excel 2010 doesn’t have the split option under the “View” tab, but it’s still easy to set up.

It can split the screen only vertically, which is what most people are looking for. Splitting the Screen into Two in Excel 2010Įxcel 2010 doesn’t have a split-screen feature. If you are using Excel 2010, the setup is a little different. The method works 2013, 2016, and 2019 versions of the software. It will then disappear, and you will only have the horizontal split. After splitting the screen into four panes, click on the vertical dividing line and drag all the way to the right. Let’s say that you need only two horizontal panes. If you need only two panes, you can choose between vertical and horizontal split. However, you can reduce the number of panes to two. However, having four separate panes can sometimes be a little confusing. You can also reposition each pane by clicking and dragging it to a different position. You can move each bar horizontally and vertically until you find the parts you need. That makes it easier to monitor and compare different parts of the sheet at the same time.

The feature includes both vertical and horizontal splitting, and each pane will show you the same worksheet. Select the “Split” icon and divide the screen to split it into four different panes.Open Excel and click on the “View” tab.

You can also choose if you want to split the screen horizontally, vertically, or both. The first one will allow you to see multiple areas of the same file, while the other one will enable you to see different files on your screen at the same time. There are two ways you can use the split-screen feature in Excel.

How to split my screen in google