Insert range action in Microsoft 365 Excel
- Updated: 2023/02/21
Insert range action in Microsoft 365 Excel
Use the Insert range action in Microsoft 365 Excel to insert a range in the current worksheet without overwriting the existing value.
Settings
- Enter the name of the session used to open the workbook with the Open action.
- Enter the cell range, for example A1:B4. This inserts a range of cells consisting of the first four rows by the first two columns.
- After inserting the cell, you can perform these operations:
- : Shifts the existing values down by the specified number of rows.
- : Shifts the existing values right by the specified number of columns.