Fill down a range by copying a row to a number of rows.
The cell or range to be extended down. For example:
The number of rows to extend the original range by. For example:
The method to overwrite. Choose either:
0to fill only empty cells
1(default) to overwrite and recompute only if content is different
2to overwrite and recompute all cells
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.