Fill a formula down into adjacent cells

To quickly copy and paste formulas into adjacent cells, use the fill handle fill handle . When you fill formulas down, relative references are used to ensure formulas adjust for each row (unless you include absolute references or mixed references before you fill the formula down).

  1. Select the cell that has the formula you want to fill into adjacent cells.

  2. Drag the fill handle fill handle down or to the right of the column you want to fill.

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.

For more information about copying and pasting formulas, see Copy and paste a formula to another cell or Move a formula.

To learn more about using formulas, see Overview of formulas.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.