Search

AutoFill

Last Updated: Sep 13, 2021

Articles

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

Syntax

AutoFill ( range, cell_identifier)

Parameters

Input Parameter Name Description
range Range of cells (first cell and last cell) separated by : to copy the formula
cell_identifier Range of cells (first cell and last cell) separated by : to which the autofill has to be applied

Sample

AutoFill (A1:A5, A1:A26)

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

To view all the Excel functions, click here.

Did you find what you were looking for?