How to apply a formula to the entire column in Excel other than draging it down?

Hi, I am working with a mega huge excel worksheet with more than 40000 rows and I want to apply a formula to a column for all these rows. But the only way I know is to insert the formula in the first cell and then drag it down to the end of the list and you can imagine how long it takes. Does anyone have any ideas... show more Hi, I am working with a mega huge excel worksheet with more than 40000 rows and I want to apply a formula to a column for all these rows. But the only way I know is to insert the formula in the first cell and then drag it down to the end of the list and you can imagine how long it takes. Does anyone have any ideas how to do it fast?
2 answers 2