Shortcut to Apply a Formula to an Entire Column in Excel

Question

I am aware that if I choose a cell with a formula, I may apply the formula to more cells in the column by dragging the small box in the right-hand corner downward. Sadly, I must perform this task for 300,000 rows!

Is there a keyboard shortcut that, like CTRL+SPACE, will apply a formula to either the full column or a specific area inside it?

Answer 1

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