Hanging out in these news groups is where I learned most of the tips and
tricks.


Gord

On Thu, 3 Sep 2009 21:02:04 -0700, YESHWANT
wrote:

HI Gord,

"in Name Box enter A1:A2345 and Enter Then CTRL + D"

you are genius .......... great
from where did u learn such great things to do in short ??


"Gord Dibben" wrote:

If an adjacent column is filled, just double-click on the fill handle to
copy down.

Or in Name Box enter A1:A2345 and Enter

Then CTRL + D


Gord Dibben MS Excel MVP

On Thu, 3 Sep 2009 15:03:01 -0700, Harvey
wrote:

how to execute the fill function down a long column with out having to drag
the mouse all the way down??