Follow these steps to fill a formula and choose which options to apply:
-
Select the cell that has the formula you want to fill into adjacent cells.
-
Drag the fill handle
If you don’t see the fill handle, it might be hidden. To display it again:
-
Click File > Options
-
Click Advanced.
-
Under Editing Options, check the Enable fill handle and cell drag-and-drop box.
-
-
To change how you want to fill the selection, click the small Auto Fill Options icon
For more information about copying formulas, see Copy and paste a formula to another cell or worksheet.
Fill formulas into adjacent cells
You can use the Fill command to fill a formula into an adjacent range of cells. Simply do the following:
-
Select the cell with the formula and the adjacent cells you want to fill.
-
Click Home > Fill, and choose either Down, Right, Up, or Left.
Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.
Turn workbook calculation on
Formulas won’t recalculate when you fill cells if automatic workbook calculation isn’t enabled.
Here’s how you can enable it:
-
Click File > Options.
-
Click Formulas.
-
Under Workbook Calculation, choose Automatic.
-
Select the cell that has the formula you want to fill into adjacent cells.
-
Drag the fill handle
Keyboard shortcut: You can also press Ctrl+D to fill the formula down a cell in a column, or Ctrl+R to fill the formula to the right in a row.
