copy formula on a huge spreadsheet

I have a spreadsheet that is 40,000 rows longs.  A simple formula is on line 1.  I want to copy this all the way down the column to the last row.   I know how to drag it.  But dragging for 40,000 row...