Excel: Applying a formula to an entire column

Factual Questions
1

How does one apply a formula to an entire column in Excel? Normally I’d put the formula in one cell and drag it to the bottom. But I have a file with 50,000+ records and that’s really slow. Is there a way to just tell it ‘Apply this formula to the whole column.’?

2

Select the first cell, scroll down, shift-click the last cell, and then select “copy down.”

3

Double-click the little box that you’d use to drag the formula to the bottom.

4

[QUOTE=InvisibleWombat]
Select the first cell, scroll down, shift-click the last cell, and then select “copy down.”
[/QUOTE]

Where is ‘copy down’?

Double-clicking the little black box in the lower-right corner of the cell has no effect.

5

Copy the cell you want to paste. Select the next one down. Then use the scrollbar to get to the bottom. Shift-click the bottom cell. Paste.

6

How about copy->paste special->formulas? Pick up the formula in the first cell, do Ctrl-C, highlight all the cells you want to copy into, choose Paste special from the Edit menu, and click “Formulas.”

7

[QUOTE=Johnny L.A.]
Double-clicking the little black box in the lower-right corner of the cell has no effect.
[/QUOTE]

It’ll only work if the adjacent column is filled in. YMMV.

8

[QUOTE=Sal Ammoniac]
How about copy->paste special->formulas?
[/QUOTE]

Aha! This worked.

Thanks.

9

[QUOTE=Terminus Est]
It’ll only work if the adjacent column is filled in. YMMV.
[/QUOTE]
Double clicking only works if an adjacent column is filled and all cells in the column that are below the column are blank.