Double-click on the fill handle will fill down to end of data in an adjacent
column.

Or.....with formula in A1, type A1:A2000 in namebox, hit Enter then CTRL + d


Gord Dibben MS Excel MVP

On Mon, 22 Mar 2010 14:20:01 -0700, Ricardo Julio <Ricardo
wrote:

I need to copy formulas in a big range of cells and I'm sure there should be
a way different than dragging until the last cell I want to copy it. I'm
talking of hundreds of cells where I want to copy the formulas.
Thanks,