Enters a formula in the range specified or in the current selection. Equivalent to entering a formula in a range of cells while pressing CTRL+ENTER in Microsoft Excel for Windows or OPTION+ENTER in Microsoft Excel for the Macintosh.
Syntax
FORMULA.FILL(formula_text, reference)
Formula_text is the text with which you want to fill the range. For more information on formula_text, see FORMULA.
Reference specifies where formula_text is entered. It can be a reference to a range in the active worksheet or an external reference to a named workbook. If omitted, formula_text is entered in the current selection.
Related Functions
DATA.SERIES Fills a range of cells with a series of numbers or dates
FORMULA Enters values into a cell or range or onto a chart
FORMULA.ARRAY Enters an array
Return to index