next up previous contents index
Next: 5.15 Tailoring Copy Options Up: 5 Manipulating the Spreadsheet Previous: 5.13 Copying Formulas

5.14 Copying Values

 

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:

  1. Select a cell or range of cells whose values are to be copied. For example select A1 through A10.

  2. Select Copy from the Edit menu (or [ctrl-V]) and display its submenu.

  3. 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 up previous contents index
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