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. |