next up previous contents index
Next: 5.14 Copying Values Up: 5 Manipulating the Spreadsheet Previous: 5.12.2 Using the Copy

5.13 Copying Formulas

 

The Copy Formulas operation duplicates a cell or range of cells (along with all formatting) and places these formulas in a new location, overwriting existing data in the destination range. NExS automatically translates relative cell references in the copied formulas to reflect their new locations. For example, if cell A10 contains the formula =@SUM(A1..A9) and is copied to cell B10, then B10 will contain the formula =@SUM(B1..B9).


To create an absolute cell reference - one that NExS will not translate if the cell contents are copied or moved - insert a dollar sign ( $ ) before each component of the cell reference (e.g., $A$1). For more information, refer to section 6.2.5, Absolute Cell References in Chapter 6, Calculations.

To copy formulas from one cell or range to another:

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

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

  3. Select Copy Formulas from the Copy submenu. NExS displays the message Copying formulas from A1..A10, select destination Range/Address... in the Message Line.

  4. Using the mouse, click on a cell or select a range to which the formulas should be copied. For example, click on cell E1 to copy the formulas to cells E1 through E10, or select the range E1..G1 to copy three columns of the formulas in cells E1 through G10. NExS copies the formulas and their 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.

Remember that copying with the mouse is usually an easier operation.

Copy Formulas can be use to copy cells with repeating characters or graphs that are store in the sheet.


WARNING: NExS overwrites any existing data in destination ranges, so plan carefully before carrying out Copy and Move operations. If you overwrite data by mistake during a Copy or Move, you can put it back like it was using Undo.


next up previous contents index
Next: 5.14 Copying Values Up: 5 Manipulating the Spreadsheet Previous: 5.12.2 Using the Copy

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