next up previous contents index
Next: 5.18.3 Starting with a Up: 5.18 Removing Data Previous: 5.18.1 Clearing Cells

5.18.2 Deleting Rows and Columns

     

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:

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

  2. Select Delete from the Edit menu, and display its submenu.

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

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

  2. Select Delete from the Edit menu and display its submenu.

  3. 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 up previous contents index
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