Using Delete action for rows or columns
Use the Delete action to remove rows or columns from the current worksheet.
Procedure
- Double-click or drag .
- Enter the name of the session used to open the workbook with the Open action.
-
Select one of the following:
- Row operations
- Select the Delete Row(s) at option to delete
all of the cells in a specific row. Specify the row number to delete
in the field. For example, to delete the tenth row in the worksheet,
enter
10
in the field. - Select the Delete Row(s) by option to delete
all of the cells in either:
- the row of the active cell.
- a specific range of cells. Specify the range to delete. For
example, to delete the first five rows, enter
1:5
in the field.
- Select the Delete Row(s) at option to delete
all of the cells in a specific row. Specify the row number to delete
in the field. For example, to delete the tenth row in the worksheet,
enter
- Column operations
- Select the Delete Column(s) at option to
delete all of the cells in a specific column. Specify the address of
the column to delete in the field. For example, to delete column 'D'
in the worksheet, enter
D
in the field. - Select the Delete Columns(s) by option to
delete all of the cells in either:
- the column of the active cell.
- a specific range of cells. Specify the range to delete. For
example, to delete the first five columns, enter
A:E
in the field.
- Select the Delete Column(s) at option to
delete all of the cells in a specific column. Specify the address of
the column to delete in the field. For example, to delete column 'D'
in the worksheet, enter
- Row operations
- Click Save.