automatically copy formulas down columns or copy formulas all the

H

HowlingBlue

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!
 
G

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
 
Top