Using Insert row or column action

Use the Insert row or column action in Microsoft 365 Excel package to create rows or columns in the current worksheet.

Procedure

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

  1. From the Microsoft 365 Excel package, double-click or drag Insert row or column action.
  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.