Using Delete row or column action

Use the Delete row or column action to remove rows or columns from the current worksheet.

Procedure

To delete rows or columns in a worksheet, do the following:

  1. Double-click or drag Delete row or column.
  2. Enter the name of the session used to open the workbook with the Open action.
  3. Select one of the following:
    • Row Operations
      1. Select the Delete Row 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.
      2. Select the Delete Row 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.
    • Column Operations
      1. Select the Delete Column 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.
      2. Select the Delete Columns 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.
  4. Click Save.