Using Insert row or column action
- Updated: 2023/12/07
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:
- From the Microsoft 365 Excel package, double-click or drag Insert row or column action.
- Enter the name of the session used to open the workbook with the Open action.
-
Select one of the following:
- Row operations
- 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. - 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.
- 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
- Column operations
- 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. - 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.
- 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
- Row operations
- Click Save.