excel - 将公式应用于Excel中的整个列的快捷方式[关闭](Shortcut to Apply a Formula to an Entire Column in Excel [closed])

Question

If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column.

(如果我选择一个包含公式的单元格，我知道我可以将右下角的小方框向下拖动以将公式应用于列的更多单元格。)

Unfortunately, I need to do this for 300,000 rows!

(不幸的是，我需要为300,000行做到这一点！)

Is there a shortcut, similar to CTRL + SPACE , that will apply a formula to the entire column, or to a selected part of the column?

(是否存在类似于CTRL + SPACE的快捷方式，它将公式应用于整个列或列的选定部分？)

  ask by John Shedletsky translate from so

Answer 1

尝试双击单元格的右下角（即在您要拖动的框中）。