Apply formula to entire column using numbers app in osx

I use osx numbers app. I have a large CSV file. And I want to apply a formula for an entire column. Adding formula to a cell and then dragging is not practical. Isn't there any other way?


Answer is as @creidhne mentioned in the comments:

Copy the first cell with the formula. Type shift+command+down_arrow to select the column. Paste.

P.s. I'm placing this as the answer to help others see the answer right away. @creidhne if you answer it here I'll remove mine so you can get credit.