From: Gord Dibben on
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
<Officeteacher(a)discussions.microsoft.com> 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?