next up previous contents index
Next: 5.13 Copying Formulas Up: 5.12 Copying Data Previous: 5.12.1 Copying with the

5.12.2 Using the Copy Menu

     

To copy formulas, use the Copy Formulas operation from the Edit menu. To copy values, use the Copy Values operation from the Edit menu.

Copy Formulas Copies formulas from a selected cell or cell range into a selected cell or range, overwriting existing data in the destination range. NExS changes cell references to reflect the new location, unless the cell references are absolute (marked with a dollar sign, $), which indicates that they should not change.
Copy Values Copies values from an active cell or cell range into a designated cell or range, overwriting existing data in the destination range. When copying cells that contain formulas, NExS copies the present value of the cell, not the formula, and enters it into the destination cell or range as a constant.

For Copy Formulas and Copy Values, NExS follows these rules for distributing the copies to the destination cell or range:


Note: You can make multiple copies of cells or cell ranges in one operation, simply by making the destination range longer or wider than the source destination.


next up previous contents index
Next: 5.13 Copying Formulas Up: 5.12 Copying Data Previous: 5.12.1 Copying with the

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999