Next: 5.15 Tailoring Copy Options
Up: 5 Manipulating the Spreadsheet
Previous: 5.13 Copying Formulas
The Copy Values operation copies the current values of a
cell or range of cells to a new location. When copying a
cell that contains a formula, NExS copies the calculated
result of that formula, not the original formula. The
value is copied to the new location and treated
thereafter as a constant value.
If you have used formulas to build part of your
spreadsheet and no longer need the formulas themselves,
converting the formulas to values can save memory and
reduce recalculation times.
To copy values from one part of the spreadsheet to
another:
- Select a cell or range of cells whose values are to
be copied. For example select A1 through A10.
- Select Copy from the Edit menu (or [ctrl-V]) and
display its submenu.
- Select Copy Values from the Copy submenu. NExS
displays the message copying values from A1..A10, select
destination Range/Address... in the Message Line.
Using the mouse, click on a cell or select a range to
which the values should be copied. For example,
click on cell C1 to copy the values to cells C1
through C10, or select the range E1..G1 to copy three
columns of the values in cells E1 through G10. NExS
copies the values from the source range to the
destination range, overwriting any existing data.
Alternatively, use the the Select Range dialog box from
the Edit menu to select a destination range.
CAUTION: Plan carefully before you copy values, to avoid mistakes
in spreadsheet structure. Remember that when the originally
displayed values are the results of calculations, they are dynamic
and will change later when interrelated data changes. However,
when values are copied, they become static and will not change
upon recalculation.
Next: 5.15 Tailoring Copy Options
Up: 5 Manipulating the Spreadsheet
Previous: 5.13 Copying Formulas
NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999