The Spread | Delete menu can be used to delete rows, columns and other attributes associated with a spreadsheet. Multiple rows or columns can be deleted by making a multiple selection. In addition to the Delete menu cells, rows or columns can be deleted by selecting the Edit | Delete menu.
Deletes the current row from the spreadsheet.
Deletes all currently selected rows from the spreadsheet.
Deletes any rows on the spreadsheet where all the cells contain missing values (*) or have empty cells. The remaining rows will be renumbered.
Deletes the current column from the spreadsheet.
Deletes all currently selected columns from the spreadsheet.
Deletes any columns on the spreadsheet where all the cells contain missing values (*) or have empty cells.
Empty Rows + Columns
Deletes any rows or columns on the spreadsheet where all the cells is the rows or columns contain missing values (*) or have empty cells. The remaining rows will be renumbered. This option is useful to reduce the size of a spreadsheet to contain only the rows or columns that contain the data.
All excluded rows in a restriction/filter are deleted. Excluded rows are usually hidden from view, but you can make them visible by clicking the button at the top-right of the spreadsheet or by selecting Spread | Restrict/Filter | Display Excluded Rows. When you display excluded rows they will display in red (unless the default colour has been changed in the Tools | Spreadsheet Options | Appearance tab).
All rows included in a restriction/filter are deleted. When included rows are deleted the remaining excluded rows are automatically made visible. Included rows are the visible rows after the restriction/filter has been applied.
For a Table spreadsheet with margins, this item will delete the rows and columns displaying the margins of the table, leaving just the body of the table.
This opens a dialog which displays a list of the currently defined pointers for a spreadsheet. You can use this dialog to delete one or all of the pointers. You can create a pointer for a spreadsheet by selecting the Spread | Sheet | Pointers menu item.
Deletes the workbook sheet that currently has focus.