It is possible to split the spreadsheet screen into vertical or horizontal sections. These sections are different views of the same spreadsheet and not separate spreadsheets. The advantage of this is that when a spreadsheet contains a large amount of data, you can view data that would normally be off-screen in one section, while working with the data of your choice in another section.
To split the screen horizontally, depress and hold down the left mouse button over the bar attached to the vertical scrollbar. A horizontal axis will be displayed. Move this to where you want the screen to be split and release the mouse button.
To split the screen vertically, depress and hold down the left mouse button over the bar attached to the horizontal scrollbar. A vertical axis will be displayed. Move this to where you want the screen to be split and release the mouse button.
Both horizontal and vertical splits can be applied at the same time to the one spreadsheet.
Scroll through the views as required, till you have located the data you want to remain visible on screen while you are working. You can choose to work in any or all of the sections, since anything you add, edit or delete in a particular section applies to the whole spreadsheet.
To clear a horizontal or vertical split, just double-click on one or both of the axes as appropriate.
You can also use the Split command from the Window menu to split the screen.
See also: