pasterbravo.blogg.se - Split screen between tabs in excel for mac 2016

#Split screen between tabs in excel for mac 2016 how to

Drag both split bars to the edges of the screen with both bars in this position, the split icon on the ribbon is turned off.

Click on View > Split to turn the split-screen feature off.

To reduce the number of screens to two, drag one of the two split bars to the top or right side of the screen.įor example, to have the screen split horizontally, drag the vertical split bar to the far right or far left of the worksheet, leaving only the horizontal bar to split the screen.

Reposition the split bars by clicking on them and dragging them with the mouse.

Use the scroll bars to move around in each quadrant.

There should also be two vertical scrollbars on the right side of the screen and two horizontal scroll bars at the bottom of the screen.

In each of the four quadrants created by the split bars should be a copy of the worksheet.

Both horizontal and vertical split bars should appear in the middle of the worksheet.

Click Split in the Window group to turn on the split-screen feature.

Remember you can use the fill handle to auto-fill the days of the week and sequential column headings such as Sample1, Sample2, etc.Open a worksheet containing a reasonable amount of data or add several rows of data – such as the data seen in the image above – to a worksheet.

#Split screen between tabs in excel for mac 2016 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. You can split the Excel screen into four panes using the Split icon located on the View tab of the ribbon.