Read and Review Automation Anywhere Documentation

Automation 360

Close Contents

Contents

Open Contents

Using Insert action for rows or columns

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

Using Insert action for rows or columns

Use the Insert action to create rows or columns in the current worksheet.

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

Procedure

  1. Double-click or drag Office 365 Excel > Insert.
  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 Insert Row(s) at option to insert a row and specify the location where to insert the row in the field. For example, to insert a row of cells in the tenth row in the worksheet, enter 10 in the field.
      2. Select the Insert Row(s) by option to insert all of the cells in either:
        • the row of the active cell.
        • a specific range of cells. Specify the range where to insert the row. For example, to insert a row of cells in the first five rows in the worksheet, enter 1:5 in the field.
    • Column operations
      1. Select the Insert Column(s) at option to insert a column and specify the location where to insert the row in the field. For example, to insert a column of cells in column 'D' in the worksheet, enter D in the field.
      2. Select the Insert Columns(s) by option to insert all of the cells in either:
        • the column of the active cell.
        • a specific range of cells. Specify the range to insert the column. For example, to insert a row of cells in the first five columns, enter A:E in the field.
  4. Click Save.
Send Feedback