FILL.AUTO

Macro Sheets Only

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

List of Command-Equivalent Functions