How to replicate formulas

How can I replicate a formula from, say, A1 thrugh A1000, without having to
physically drag all the way from row 1 to 1000?

Enter the formula in cell A1
Copy cell A1
Hit function key F5
Type A2:A1000
Hit Enter or click on OK
Then EditPaste

Biff

"Crisco Kid" wrote in message
...
How can I replicate a formula from, say, A1 thrugh A1000, without having
to
physically drag all the way from row 1 to 1000?

Another way to play it ..

Type A1:A1000 in the namebox*, press ENTER
This selects A1:A1000 with A1 active
*the box with the droparrow just above the "A" col header,
to the left of the formula bar

Then enter** your formula into the formula bar, press CTRL+ENTER
This will fill the entire range as desired
**if you have the formula already in A1,
just click inside the formula, then press CTRL+ENTER
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Crisco Kid" wrote:
How can I replicate a formula from, say, A1 thrugh A1000, without having to
physically drag all the way from row 1 to 1000?

One further trick, which doesn't work for column A, but can be very useful in
other columns:

If the column to the left is populated for the entire range, just double-click
on the fill handle.

For example, if you have data in a1:a1000, and enter a formula in b1,
double-clicking on b1's fill handle will fill in formulas down to b1000.

--
Regards,
Fred


"Crisco Kid" wrote in message
...
How can I replicate a formula from, say, A1 thrugh A1000, without having to
physically drag all the way from row 1 to 1000?

Fred.

Info only.

Also..........If the column to the right is populated, the double-click will
copy down.

i.e. if B is populated, double-click will fill A


Gord Dibben MS Excel MVP

On Sun, 18 Mar 2007 06:12:14 -0600, "Fred Smith" wrote:

One further trick, which doesn't work for column A, but can be very useful in
other columns:

If the column to the left is populated for the entire range, just double-click
on the fill handle.

For example, if you have data in a1:a1000, and enter a formula in b1,
double-clicking on b1's fill handle will fill in formulas down to b1000.