Worksheet

Built-in functions › Sheets › Worksheet

30 functions in this category.

Function	What it does
applycxf	Apply conditional formatting to a range.
applyxf	Apply a cell style (named or property-pair) to a range.
clearcells	Clear cell contents while preserving the cells themselves.
copycells	Copy a cell range, optionally to a destination range.
deletecells	Delete cells, shifting remaining cells.
deletecols	Delete entire columns.
deleterows	Delete entire rows.
dissociate	Reverse a cell merge.
groupcols	Group columns so they can be collapsed / expanded as a unit.
grouprows	Group rows so they can be collapsed / expanded as a unit.
hidecols	Hide columns.
hiderows	Hide rows.
insertcells	Insert empty cells, shifting existing cells.
insertcols	Insert empty columns at the specified position.
insertrows	Insert empty rows above the specified position.
mergecells	Merge cells in a rectangular range into a single cell.
mergehorz	Merge each row of a range into a single horizontal cell.
mergevert	Merge each column of a range into a single vertical cell.
movecells	Move (cut) a cell range to a destination.
movetable	Move a table or variable cell block to a new position.
pincol	Pin (freeze) a column at the left of the worksheet view.
pinrow	Pin (freeze) a row at the top of the worksheet view.
removecxf	Remove all conditional formatting from a range.
sortcells	Sort a cell range.
ungroupcols	Remove column grouping.
ungrouprows	Remove row grouping.
unhidecols	Show previously hidden columns.
unhiderows	Show previously hidden rows.
unpincol	Unfreeze a previously pinned column.
unpinrow	Unfreeze a previously pinned row.