Revision history [back]
 | 1 | initial version |
To delete all rows and columns that are grouped together in a spreadsheet, follow these steps:
Select the row or column group that you want to delete. To do this, click on the row number or column letter of the first row or column in the group, then drag your mouse across to the last row or column in the group.
Right-click on the selected rows or columns and choose "Delete" from the context menu.
In the Delete dialog box, choose the option to "Shift cells up" or "Shift cells left" depending on whether you are deleting rows or columns. Click "OK" to confirm the deletion.
Repeat the process for any additional row or column groups that you want to delete.
Note: Be careful when deleting rows or columns, as this action cannot be undone. Make sure to save a backup copy of your spreadsheet before deleting any data.