Equivalent to copying cells or automatically filling a selection by dragging the fill selection handle with the mouse (the AutoFill feature).
Syntax
FILL.AUTO(destination_ref, copy_only)
Destination_ref is the range of cells into which you want to fill data. The top, bottom, left, or right end of destination_ref must include all of the cells in the source reference (the current selection).
Copy_only is a number specifying whether to copy cells or perform an AutoFill operation.
| Value | Result |
| 0 or omitted | Normal AutoFill |
| 1 or TRUE | Copy cells |
| 2 | Copy formats |
| 3 | Fill values |
| 4 | Increment |
| 5 | Increment by day |
| 6 | Increment by weekday |
| 7 | Increment by month |
| 8 | Increment by year |
| 9 | Linear trend |
| 10 | Growth trend |
Related Functions
COPY Copies and pastes data or objects
DATA.SERIES Fills a range of cells with a series of numbers or dates
Return to index