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
by the
Number of sheets open at the beginning:
setting in
the
Interface
page of KSpread's
configuration dialog box.
->
will add another sheet to the document.
If the
Show tabs
box in the
Interface
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.
Left click on one of these tabs to see that sheet.
You can also switch between worksheets by using the
Ctrl
+PageDown
to move to the next sheet,
Ctrl
+PageUp to move to
the previous one.
Worksheets are given the default names of
Sheet1
,
Sheet2
... You can give a sheet a different name by
right 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 right 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
=Sheet2!A2
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
menu.
Selecting this option brings up the
Consolidate
dialog box.
For each of the source sheets, enter a reference to the desired data area
in the
Reference:
box. Press
Add
to
transfer it to the
Entered references:
box. The reference
should include the name of the sheet containing the source data, such as
January!A1:A10
, 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
the
Function:
combo box and press the
OK
button.
If you check the
Copy data
box in the
Consolidate
dialog the values resulting from the consolidation will
be placed into the target cells rather than the formulae to calculate them.
