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.’?
Select the first cell, scroll down, shift-click the last cell, and then select “copy down.”
Double-click the little box that you’d use to drag the formula to the bottom.
Where is ‘copy down’?
Double-clicking the little black box in the lower-right corner of the cell has no effect.
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.
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.”
It’ll only work if the adjacent column is filled in. YMMV.
Aha! This worked.
Thanks.
Double clicking only works if an adjacent column is filled and all cells in the column that are below the column are blank.