Delete columns or rows
Delete columns and rows
To delete one or more columns or rows, 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 > Row / Column. •On the Toolbar, in the Cells section, click the arrow •Right-click anywhere in the selected range and run Delete > Row / Column command from the context menu. 2.Select these columns/rows in their entirety and 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. |
to the right of 
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 •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.
|
