Tool

---

In Blockpad, you can drag the bottom right corner of a cell selection to create value series or new cells with adjusted cell references.

Drag a cell selection to repeat content:

1. Select the cells.
2. Click and drag the bottom right of the selection.
3. Release the mouse.

Patterns for creating new content:

• Formula offsets: any cell references (C4, AG3, D44) will be adjusted according to the new location of the formula.
  • Any references to names are not adjusted. If a named cell (eg. length = 3 ft) is referenced with the name, then it's not offset. To offset a named cell, use the cell reference in the formula instead of the name.
  • Formula offsets take any dollar signs ($) in a cell reference into account.
• Arithmetic number series: Blockpad will continue an arithmetic series with the drag down tool. (3,6,9 or 1,2,3,4).
• Date series: dates will be continued based on the intervals of the selection.
• Alternating values: if Blockpad doesn't see any of the above patterns, then the selection will be repeated.

See also:

• Spreadsheet
• Table

---