Skip to main content

Anchoring & Apply Modes

Together, Anchor and Mode decide exactly where a Block Format lands relative to the cell that matched its condition.

Anchor​

  • None — the block's top-left corner lands directly on the matched cell.
  • Row — the block locks to the top of the matched cell's column.
  • Column — the block locks to the start of the matched cell's row.
tip

A Row block can only use a Column anchor, and a Column block can only use a Row anchor.

Mode​

  • Overwrite — paints the block over existing cells.
  • Insert Before — inserts a new row/column before the match and stamps the block into them.
  • Insert After — same as Insert Before, but after the match.
note

Insert Before and Insert After require a Row or Column anchor. Anchor None only supports Overwrite.

Valid combinations​

AnchorOverwriteInsert BeforeInsert After
None✅🚫🚫
Row✅✅✅
Column✅✅✅