×
英语
很抱歉。本文没有你的语言版本。

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.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×