Next: 5.14 Copying Values
Up: 5 Manipulating the Spreadsheet
Previous: 5.12.2 Using the Copy
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:
- Select a cell or range of cells whose formulas or
values are to be copied. For example, select A1
through A10.
- Select Copy from the Edit menu (or [ctrl-F]), and
display its submenu.
- Select Copy Formulas from the Copy submenu. NExS
displays the message Copying formulas 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 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: 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