Fred.

Info only.

Also..........If the column to the right is populated, the double-click will
copy down.

i.e. if B is populated, double-click will fill A


Gord Dibben MS Excel MVP

On Sun, 18 Mar 2007 06:12:14 -0600, "Fred Smith" wrote:

One further trick, which doesn't work for column A, but can be very useful in
other columns:

If the column to the left is populated for the entire range, just double-click
on the fill handle.

For example, if you have data in a1:a1000, and enter a formula in b1,
double-clicking on b1's fill handle will fill in formulas down to b1000.