Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replicate formulas
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replicate formulas
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replicate formulas
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replicate formulas
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What's the VBA syntax to replicate this? | Excel Discussion (Misc queries) | |||
Replicate right from A2,A3,A4 TO B1,B2,B3 etcetera | Excel Worksheet Functions |