Sign up for free
Functions

FILL

Fill down a range by copying a row to a number of rows.

Parameter List

Syntax
FILL(range, rows, 
[overwrite]
)
range

The cell or range to be extended down. For example: A1 or A2:D2.

rows

The number of rows to extend the original range by. For example: 33.

[optional] overwrite

The method to overwrite. Choose either:

  • 0 to fill only empty cells

  • 1 (default) to overwrite and recompute only if content is different

  • 2 to overwrite and recompute all cells

More details

Use FILL() in unison with UPDATE(), INSERT() and CLEAR() to automate tables and databases. FILL() will copy the range cell's values/formulas and theirs formats to the selected rows.

Examples

FILL(A2, 3) returns A3=3, A4=4, A5=5