Search

AutoFill

Home
Developer Guide
functions
AutoFill

Last Updated: Dec 1, 2020

Articles

Use this function to take the formulas defined in the specified cell range and adapt them to the specified end range.

Syntax

AutoFill (source_range, extend_till_cell)

Parameters

Input Parameter Name Description
source_range Source cell values (first cell and last cell) separated by ‘:’ to copy the formula
extend_till_cell Cell till which the auto extension has to be done

':' is used as separator between the cells.

Sample

AutoFill (A1:A5, A26)

  • Takes the formula defined in the cell range A1:A5 and autofills till the cell A26 with the same formula.

To view all the Excel functions, click here.

Did you find what you were looking for?