# Formula Copying- Continue All The Way Down A Column

Feb 13, 2009How do you make a formula continue all the way down a column, so i haven't got to drag or copy it down all the time?

Lets say I have a formula in row Z, which is =SUM(A1:T1) If I want that formual to be in every cell of row Z, I would have to copy it down. However, if I do that, the spreadsheet becomes huge. I just want that formula (in fact my formula is much more complicated) to always be in row Z, for evermore, as the spreadsheet in time will have more and more rows in it.