automatically copy formulas down columns or copy formulas all the

[Guest]

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!

 

[Gord Dibben]

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