Splitting the screen
Another way to change the view is by splitting the screen your spreadsheet is displayed in (also known as splitting the window). The screen can be split horizontally, vertically, or both, giving you up to four portions of the spreadsheet in view at any one time. An example of splitting the screen is shown in Figure 17 where a split is indicated by a black line.
Why would you want to do this? For example, a large spreadsheet in which one cell has a number in it that is used by three formulas in other cells. Using the split-screen technique, you can position the cell containing the number in one section and each of the cells with formulas in the other sections. This allows you to change the number in one cell and watch how it affects each of the formulas.
Figure 17: Split screen example
Splitting horizontally or vertically
To split rows only, click on the row header below the rows you want to split.
To split columns only, click on the column header to the right of the columns where you want to split.
To split rows and columns, select the cell below the rows and to the right of the columns that you want to split.
Go to Window on the main menu bar and select Split. A thick line appears between the rows or columns indicating where the split has been placed as shown in Figure 17.
Alternatively for a horizontal split, click on the thick black line at the top of the vertical scroll bar (Figure 18) and drag the split line below the row where you want the horizontal split positioned.
Alternatively for a vertical split, click on the thick black line at the right of the horizontal scroll bar (Figure 18) and drag the split line to the right of the column where you want the vertical split positioned.
Figure 18: Split screen bars
Removing split views
To remove a split view, do any of the following:
Double-click on each split line.
Click on and drag the split lines back to their places at the ends of the scroll bars.
Go to Window on the main menu bar and uncheck Split.