Insert Rows
This action inserts one or more rows in a spreadsheet.
Properties
The Insert Rows action can be configured using the following properties:
- Insert Where
-
This option specifies where to insert the rows. Options are:
- First
- Before (Default)
- After
- Last
- Number of Rows
-
The number of rows to insert.
- Set as Named Range
-
Range name options are:
- Auto (Default)
- Named: If you select this option, specify a name of the range.
- 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:
- It is easier to remember what the named range identifies if it has a well-chosen name
- An explicitly named range is not affected if another named range is inserted before it
- If you use the same name again, the name will simply be made to refer to the new range (useful for stateful in-page looping