Delete columns or rows – Cells, columns, and rows | How to use MyOffice Spreadsheet Home Edition

Delete columns and rows of a sheet

To delete one or more columns or rows on a sheet, use one of the following methods:

1.Select the rows or columns or cells located in them. Then do one of the following:

•In the Table menu, select Delete > Entire Sheet Row / Entire Sheet Column.

•On the Toolbar, in the Cells section, click the arrow drop_menu_button to the right of Delete Cell, Column, or Row button and select editor_delete_row_icon Delete Entire Sheet Row or editor_delete_column_icon Delete Entire Sheet Column.

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

2.Select the given columns/rows in their entirety. When working in Windows or Linux, press Ctrl+-. When working in macOS, press command Cmd+-.

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:

•In the Table menu, select Delete > Table Row / Table Column.

•On the Toolbar, in the Cells section, click the arrow drop_menu_button to the right of 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 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:

•In the Table menu, select Delete > Cells and Shift Left / Cells and Shift Up.

•On the Toolbar, in the Cells section, click the arrow drop_menu_button to the right of Delete Cell, Column, or Row and select editor_delete_cell_left_offset Delete Cells and Shift Left or editor_delete_cell_bottom_offset Delete Cells and Shift Up from the drop-down 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 MyOffice Spreadsheet, shift deletion is not available when working with a document in the View modes, as well as for cells of tables.