Shortcut to Apply a Formula to an Entire Column in Excel [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to 开发者_如何学Cexplain where the question may be able to be answered.

Closed 8 years ago.

Locked. This question and its answers are locked because the question is off-topic but has historical significance. It is not currently accepting new answers or interactions.

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!

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?

---

Try double-clicking on the bottom right hand corner of the cell (ie on the box that you would otherwise drag).

---

If the formula already exists in a cell you can fill it down as follows:

• Select the cell containing the formula and press CTRL+SHIFT+DOWN to select the rest of the column (CTRL+SHIFT+END to select up to the last row where there is data)
• Fill down by pressing CTRL+D
• Use CTRL+UP to return up

On Mac, use CMD instead of CTRL.

An alternative if the formula is in the first cell of a column:

• Select the entire column by clicking the column header or selecting any cell in the column and pressing CTRL+SPACE
• Fill down by pressing CTRL+D

---

Select a range of cells (the entire column in this case), type in your formula, and hold down Ctrl while you press Enter. This places the formula in all selected cells.