Insert Rows

This action inserts one or more rows in a spreadsheet.


The Insert Rows action can be configured using the following properties:

Insert Where:
This option specifies where to insert the rows. Options are:
Number of Rows:
The number of rows to insert.
Set as Named Range:
Range name options are:
Range Name:
Has two options, Auto or Named.
Auto gives the range a name which is number. The first Auto-numbered range will have number 1, the next number 2 etc. Note that the number may change if additional Auto-numbered ranges are inserted before this step (on the same page).
Named gives the range a fixed and explicitly stated name, which has several advantages: