
If your spreadsheet is so large that you cannot see all of it at once, splitting KSpread's window into two or more views can help you work on it. This is done by selecting → which will split the current view into two parts. → lets you choose between and splitting.
This technique is particularly useful when you want to select an area of the spreadsheet that is larger than can be shown in one view, perhaps to paste a copied cell into it. Use the scrollbars to position the two views to show the top left and bottom right cells of the wanted area, select the top left cell in one view then hold the Shift key pressed while you select the bottom right cell with the mouse button.
If there is more than one sheet in your document, you can show a different sheet in each of the split views.
The relative sizes of the views can be changed by dragging the thick bar separating the views.
To remove a view select →
You can give a name such as foo
to a cell or to
any area of a sheet by selecting the cell or area then selecting from the mouse
button menu. This will bring up the Area Name dialog box
where you can enter any name you wish.
You can also name a cell or area by selecting it then typing the name into the small text box at the left end of the Formula toolbar, overwriting the cell reference that normally appears here.
If you enter a name that has already been used into this text box KSpread's selection will change to show the named cell(s).
The