Next: 5.18.3 Starting with a
Up: 5.18 Removing Data
Previous: 5.18.1 Clearing Cells
The Delete operations delete rows and columns from the
spreadsheet, along with all formulas and values in the
deleted cells. NExS reassigns addresses for the
remaining rows and columns and adjusts formulas in other
cells as needed so that cell dependencies are preserved.
If the deleted rows or columns were included in named or
reference ranges, NExS contracts those ranges
accordingly.
To delete a row:
-
Use the mouse to select the row(s) you wish to
delete. Place the mouse pointer over the number
which identifies the row, and click the left mouse
button. To select more than one row, place the
mouse pointer over the number, drag the mouse
(holding down the left mouse button) to the desired
ending number, and release the left mouse button.
-
Select Delete from the Edit menu, and display its
submenu.
- Select Delete Row from the Delete submenu. NExS
deletes the row(s) and all data contained in that
row. NExS re-addresses the remaining rows and
rewrites cell references where necessary to be
consistent with the new row numbering.
To delete a column:
- Use the mouse to select the column(s) you wish to
delete. Place the mouse pointer over the letter
which identifies the column, and click the left mouse
button. To select more than one column, place the
mouse pointer over the letter, drag the mouse
(holding down the left mouse button) to the desired
ending letter, and release the left mouse button.
- Select Delete from the Edit menu and display its
submenu.
- Select Delete Column, from the Delete submenu. NExS
deletes the column(s) and all data contained in that
column. NExS re-addresses the remaining columns and
rewrites cell references where necessary to be
consistent with the new column lettering.
If you delete a row or column that contains a cell which is
referenced by a formula in another cell, the formula reference
will not be modified. Range references will be updated when rows
or columns are deleted within a range specification.
Next: 5.18.3 Starting with a
Up: 5.18 Removing Data
Previous: 5.18.1 Clearing Cells
NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999