Selecting any cell and right-clicking shows the cell edit menu
Cut/Copy/Paste
Cut, Copy and
Paste works pretty much as you might expect in any Windows program
with one exception.
At present Paste pastes
only numeric information and not formatting information, so any
formatting information must be added after pasting.
Paste Link
Paste Link cause
a formula to be entered into the cell that links it's contents to the
contents of the original cell(s).
For example, copying
the 'Task Name' first cell and Paste Linking it in another
spreadsheet causes the formula:
=Project!A5
To be entered. Changes
to the originating cell will propogate instantly to your spreadsheet.
Edit Names...
Clicking the Edit Names... menu item causes the Variables dialog to appear:
This dialog allows you assign a variable name to whatever cell or group
of cells you've selected in
order to make it easier to use in formulas.
With the above example, you could write a formula such as:
=US_TO_CAD_RATE * 10.99
=SUM(MY_RANGE)
Cell Type...
Clicking the Cell Type... menu item causes the Cell Type dialog to appear.
Select a format from
the Formats: list to change the type of cell.
One practical use of this is changing a numeric cell to a Currency format to show
a currency
indicator (such as '$') along with the number. Another is to convert numbers to "string" formatted
cells.
