Skip to content

deletecells

Delete cells, shifting remaining cells.

deletecells(cr)
deletecells(cr, direction)

Removes the cells in cr, shifting subsequent cells in the chosen direction ('left', 'up', default 'left').

deletecells(B2:B5, 'up')
  • insertcells — Insert empty cells, shifting existing cells.
  • clearcells — Clear cell contents while preserving the cells themselves.
  • deleterows — Delete entire rows.
  • deletecols — Delete entire columns.