Using more than one Worksheet
When you start a new, empty, document with KSpread it will create a
number of blank worksheets. The number of sheets it creates is determined
Number of sheets open at the beginning:
page of KSpread's
configuration dialog box.
will add another sheet to the document.
box in the
page of KSpread's configuration dialog box is checked a small
tab will be shown near the bottom left of KSpread's window for each sheet.
click on one of these tabs to see that sheet.
You can also switch between worksheets by using the
to move to the next sheet,
+PageUp to move to
the previous one.
Worksheets are given the default names of
... You can give a sheet a different name by
clicking on the tab and selecting
To remove a sheet from the document use the
option in the
submenu or in the little
menu that pops up when you
click on the tab
for the sheet you want to remove.
Other entries in the
submenu allow you to show or hide a sheet in
much the same way as rows and columns can be hidden.
If you want a formula in one sheet to refer to a cell in another sheet,
the cell reference must start with the sheet name followed by an exclamation
mark (!). For example if you enter
into a cell in Sheet 1, that cell will take the value from A2 of
Sheet2. Note that sheet names are case sensitive.
You may have constructed a document containing several worksheets
containing similar data but for, say, different months of the year, and wish
to have summary sheet containing the consolidated (e.g., sum or average) values
of the corresponding data items in the other sheets.
This task can be made slightly easier by using the
item from the
Selecting this option brings up the
For each of the source sheets, enter a reference to the desired data area
transfer it to the
box. The reference
should include the name of the sheet containing the source data, such as
, and can be entered automatically by
selecting the area in the appropriate sheet.
After entering the references for all of the source data sheets
select the cell in the target sheet where you want the top left corner of the
consolidated results to appear. Then choose the appropriate function from
combo box and press the
If you check the
box in the
dialog the values resulting from the consolidation will
be placed into the target cells rather than the formulae to calculate them.