Note: When you delete cells, rows or columns, any information they contain is also deleted.
To delete a cell (or cells), select the cell(s) you want to delete. Next, select Delete from the Edit menu (or by right clicking your mouse). The "Delete Cells" dialog will appear. Choose whether you want the deleted cells to be replaced with cells from the same column(s) or row(s). Click on OK to delete the selected cells and shift cells from the same column (up) or row (left).
To delete a row, click on the row bar to select the row you want to delete. The whole of the row is selected, rather than a range. Select Delete from the Edit menu (or by right clicking your mouse). The selected row will be deleted, and all the rows beneath the deleted row will be shifted one row up. Note that the "Delete Cells" dialog does not appear when deleting rows.
To delete a column, click on the column bar to select the column you want to delete. The whole of the column is selected, rather than a range. Select Delete from the Edit menu (or by right clicking your mouse). The selected column will be deleted, and all columns to the right of the deleted column will be shifted one column to the left. Note that the "Delete Cells" dialog does not appear when deleting columns.
It is possible to delete several rows or columns at once by selecting the required number of row or column bars.
Note: Spreadsheet readjusts formulas and range references to compensate for deleted rows and columns.
See also: