Select the cell, hold Shift+Ctrl, then hit the down arrow key. When all
cells are selected, or all adjacent cells are selected (whatever the case may
be), hit Ctrl+D (for down). Ctrl+R works great for filling-right.

--
RyGuy


"Gord Dibben" wrote:

If adjacent column has no blank cells just double-click on the fill handle to
copy all the way down.

OR.............

Assuming formula is in D1, type D1:D50000 in namebox then Enter then CTRL + D to
copy down.


Gord Dibben MS Excel MVP

On Thu, 8 Feb 2007 12:24:02 -0800, Zb Kornecki <zDOTkorneckiATcomcastDOTnet
wrote:

Is there any way to fill down formulas w/o dragging the + cursur. I'm
working on sheets w/ 50K records and dragging is time consuming. Thank-you Zb