Skip to content

deleterows

Delete entire rows.

deleterows(cr, cr2, ...)

Removes the rows containing the given cell ranges, shifting subsequent rows up. Affects the entire row span — for partial-cell deletions use deletecells.

deleterows(A5:A10)
  • insertrows — Insert empty rows above the specified position.
  • deletecols — Delete entire columns.
  • deletecells — Delete cells, shifting remaining cells.
  • clearcells — Clear cell contents while preserving the cells themselves.