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:
    • Shift cell > Down: Shifts the existing values down by the specified number of rows.
    • Shift cell > Right: Shifts the existing values right by the specified number of columns.