If you have data in an adjacent column, double-clicking on the fill handle of
the cell with the formula will copy it down as far as the end of data in the
adjacent column.

Maybe that will do the trick for you?


Gord Dibben MS Excel MVP

On Fri, 16 Mar 2007 15:22:12 -0700, HowlingBlue wrote:

is there a way to make excel remember to copy formulas down by itself, so I
don't have to do it when I reach the bottom of how far I copied the first
time?

or, is there a way to copy the formula down to the bottom (65535, I guess)
without taking a performance/size hit?

Thanks!