One way...

Select the range of cells. For large ranges you can do this quickly by
typing the range address into the name box and then hitting Enter. The name
box is that little "box" immediately above the column A header.

For example, the range in question is A1:A3000

In the name box type A1:A3000 then hit Enter

The range will be selected and cell A1 will be the active cell.

Type your formula then, while holding down the CTRL key, hit Enter.

--
Biff
Microsoft Excel MVP


"Officeteacher" wrote in message
...
How do you quickly fill down a formula without dragging the fill handle
for
3000 rows in Microsoft 2007?