Delete columns or rows

Application: Spreadsheet Education

Delete columns and rows of a sheet

To delete one or more columns or rows on a sheet, select the columns or rows in their entirety or select the cells within them and do one of the following:

–On the Home tab, in the Cells group, click the arrow to the right of the editor_delete_row_icon Delete cell, column or row button and select Delete row or editor_delete_column_icon Delete column.

The appearance of the editor_delete_row_icon

Delete cell, column, or row button depends on the last command invoked using it and may differ from the one shown here.

–Right-click anywhere in the selected range and run the Delete > Row / Column command from the context menu.

If a cell in a table is selected, the Delete row or Delete column commands on the Toolbar will be renamed to Delete entire sheet row and Delete entire sheet column, respectively, and the Delete > Row / Column commands in the context menu will be renamed to Delete > Entire sheet row / Entire sheet column, respectively.

–If you have selected columns or rows in their entirety, press Ctrl+-.

If there is filtered data or manually hidden columns or rows, only visible columns or rows will be deleted with the following exceptions:

–If you delete a column in its entirety, the cells from the hidden rows will be deleted along with it.

–If you delete a row in its entirety, the cells from the hidden columns will be deleted along with it.

Delete columns and rows of the table

To delete one or more columns or rows of a table, select the cells located in them and do one of the following:

–On the Home tab, in the Cells group, click the arrow to the right of the editor_delete_row_icon Delete cell, column or row button and select smart_table_delete_row_icon Delete table row or smart_table_delete_column_icon Delete table column.

–Right-click anywhere in the selected range and run the Delete > Table row / Table column command from the context menu.

You cannot delete rows of the table when filtering is enabled.

Deletion of rows and columns of a table does not affect cells beyond it.

Delete cells with shift

When deleting cells with a shift, adjacent cells are automatically shifted left or up, depending on the selected delete option, by the number of cells to be deleted. All links and formulas that use the cells shifted as a result of the deletion are automatically updated.

To delete a cell or range of cells with a shift, follow these steps:

1.Select a single cell or a range.

2.Do one of the following:

•On the Home tab, in the Cells group, click the arrow to the right of the editor_delete_row_icon Delete cell, column or row button and select editor_delete_cell_left_offset Delete cells and shift left or editor_delete_cell_bottom_offset Delete cells and shift up.

•Right-click anywhere in the selected range and run the Delete > Cells and shift left / Cells and shift up command from the context menu.

In the current version of MyOffice Spreadsheet, shift deletion is not available when working with a document in the View and Collaboration modes, as well as for cells of tables.

Was this helpful?

Yes