Next: 5.17 Copying Data from
Up: 5.16 Moving Data
Previous: 5.16 Moving Data
- When you move a cell that is referenced by a formula,
NExS automatically updates the formula for the new
location, even if the cell reference is absolute.
- When you move a cell in a range that is referenced by
a formula, the formula still references the original
range. However, if you move a corner cell of the
range, NExS extends or contracts the range to match
the new location.
-
If you move a cell range that has been named, or one
referenced in a formula, NExS automatically updates
the definition of the range name or the formula
reference to reflect the new location.
- If you move part of a cell range that has been named
or referenced in a formula, it can cause problems.
NExS updates range names and references only when you
move one or more corner cells of the range. If you
move cells in the interior of the range, NExS will not
change the range name or any references to it.
Note: If you make a mistake when copying or moving data, you can
use Undo from the Edit menu to restore the spreadsheet to its
state prior to the copy or move operation.
Next: 5.17 Copying Data from
Up: 5.16 Moving Data
Previous: 5.16 Moving Data
NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999