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 -> option will give you a list of existing names and let you change KSpread's focus to any of them or let you remove a name.
Named cells are particularly useful in formulae as an alternative to absolute cell references as the names can be used in place of normal cell references and do not change when the cell containing the formula is copied. When a name is used in this way it should be enclosed in single quotation marks.
For example, if cell A1 has been given the name fred
then you can enter a formula such as ='fred' + 2
into another cell which would always give the result of adding
2 to the value in A1 no matter where the formula cell was copied to.
Note that cell and area names are treated as being in lowercase.
A cell can contain a text comment that can be viewed when working on the spreadsheet but which is not printed and not normally seen.
To add a comment select the cell and choose from the mouse button menu or from the -> menu and type your comment into the resulting Cell Comment dialog box.
To see the comment hover the mouse pointer over the top right corner of the cell. The comment will appear as if it were a Tooltip.
If you check the Show comment indicator box of the Sheet Properties dialog, those cells containing comments will be highlighted by a small red triangle in the top right corner.
To open this dialog, click with the from the popup menu. Or select it from the -> menu.
mouse button onto the sheet tab at the bottom of the main window and selectTo remove a comment from a cell, select from the mouse button menu or choose ->->.
Would you like to comment or contribute an update to this page?
Send feedback to the TDE Development Team