Delete columns or rows

Product: MyOffice Professional, MyOffice Education

Application: Spreadsheet Desktop version

Delete columns and rows of a sheet

To delete one or more columns or rows on a sheet, select the columns/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.

If a cell in a table is selected, Delete row or Delete column commands will be named Delete entire sheet row and Delete entire sheet column, respectively.

•When working in macOS, select the Table > Delete > Row / Column command from the command menu.

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

If a cell in a table is selected, Delete > Row / Column commands will be named Delete > Entire sheet row / Entire sheet column respectively.

•If you have selected columns or rows in their entirety, press Ctrl+- (Windows, Linux) or command Cmd+- (macOS).

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.

•When working in macOS, select the Table > Delete > Table row / Table column command from the command menu.

•Right-click anywhere in the selected range and run 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.

•When working in macOS, select the Table > Delete > Cells and shift left / Cells and shift up command from the command menu.

•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 MySpreadsheet, 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