Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Using Delete action for rows or columns

  • Updated: 1/15/2021
    • Automation 360 v.x
    • Build
    • RPA Workspace

Using Delete action for rows or columns

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

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

Procedure

  1. Double-click or drag Office 365 Excel > Delete.
  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(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.
      2. 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.
    • Column operations
      1. 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.
      2. 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.
  4. Click Save.
Send Feedback