1. Home
  2. Spreadsheet Delete Menu

Spreadsheet Delete Menu

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.

Current Row

Deletes the current row from the spreadsheet.

Selected Rows

Deletes all currently selected rows from the spreadsheet.

Empty Rows

Deletes any rows on the spreadsheet where all the cells contain missing values (*) or have empty cells. The remaining rows will be renumbered.

Current Column

Deletes the current column from the spreadsheet.

Selected Columns

Deletes all currently selected columns from the spreadsheet.

Empty Columns

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.

Excluded Rows

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

Included Rows

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.

Table Margins

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.

Pointers

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.

Current Sheet

Deletes the workbook sheet that currently has focus.

See also

Updated on March 19, 2019

Was this article helpful?