See Biff's reply about using the namebox and CTRL + Enter


Gord Dibben MS Excel MVP

On Mon, 22 Feb 2010 10:13:02 -0800, Officeteacher
wrote:

Is there a way to go fill down to row 3000 quickly if you do NOT have any
information adjacent?

"Eduardo" wrote:

Hi,
if the adjacent column has information up to row 3000, just go to the right
button of the cell where you have the formula, when you see the black cross,
double click the mouse

"Officeteacher" wrote:

How do you quickly fill down a formula without dragging the fill handle for
3000 rows in Microsoft 2007?