Fill a formula down into adjacent cells (2024)

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 across the cells that you want to fill.

If you don’t see the fill handle, it might be hidden. To display it again:
1. Click File > Options
2. Click Advanced.
  See Also
  Filter data in a range or table Range object (Excel)How to find or select cells based on certain criteria in Excel?Find named ranges - Microsoft Support
3. 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 that appears after you finish dragging, and choose the option that want.

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.
See Also
Excel random selection: how to get random sample from dataset

Formulas won’t recalculate when you fill cells if automatic workbook calculation isn’t enabled.

Here’s how you can enable it:

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.