insertrows

Insert empty rows above the specified position.

Syntax

insertrows(cr1, cr2, ...)

Description

Inserts new empty rows at the given positions, shifting existing rows downward. The number of rows inserted equals the height of each cell range.

Examples

insertrows(A5)           % insert one row above row 5
insertrows(A5:A7)        % insert three rows above row 5

See also

• deleterows — Delete entire rows.
• insertcols — Insert empty columns at the specified position.
• insertcells — Insert empty cells, shifting existing cells.