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.