Hi,

Select the cell you want to fill-down and you will see a black square on the
bottom right. Double click it and the column will down as far as the
populated range in the column to the left.

Mike

"KWhamill" wrote:

I'm looking for a foolproof technique to Filldown a formula when I don't know
in advance how many rows i might have to fill. However, the column
Immediately to the left will be populated when the formula is applied. Any
suggestions would be great.
Thanks,
K