If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




How do I create a formula repeated on the adjacentt columns?
I am trying to make the same operation for each column  the only difference
is in the rows, e.g. C3=A3*B* C4=A4*B4, etc. I don't want to have to reenter a similar formula for each added row. Thanks. 
Ads 
#2




How do I create a formula repeated on the adjacentt columns?
Select cell C3.
Move your curser to the fill handle (lower right of cell). When the curser becomes a black cross, leftclick and drag down as far as you wish. George Gee "Excelless" > wrote in message ... >I am trying to make the same operation for each column  the only >difference > is in the rows, e.g. > C3=A3*B* > C4=A4*B4, etc. > > I don't want to have to reenter a similar formula for each added row. > > Thanks. 
#3




How do I create a formula repeated on the adjacentt columns?
But how do I create the formula itself? This just overwrote all the previous data cells with the top cell's value  thx. "Excelless" wrote: > I am trying to make the same operation for each column  the only difference > is in the rows, e.g. > C3=A3*B* > C4=A4*B4, etc. > > I don't want to have to reenter a similar formula for each added row. > > Thanks. 
#4




How do I create a formula repeated on the adjacentt columns?
If you want to multiply A3 by B3, then in C3 type: =A3*B3
and copy down as previously described! If you require anything other than this, I suggest you try to explain exactly what it is that you want, in more detail. Also it would be prudent to use a *copy* of your workbook to try anything new. George Gee "Excelless" > wrote in message ... > > But how do I create the formula itself? This just overwrote all the > previous > data cells with the top cell's value  thx. > > "Excelless" wrote: > >> I am trying to make the same operation for each column  the only >> difference >> is in the rows, e.g. >> C3=A3*B* >> C4=A4*B4, etc. >> >> I don't want to have to reenter a similar formula for each added row. >> >> Thanks. 
#5




How do I create a formula repeated on the adjacentt columns?
Tools>Options>Calculation.
Make sure you are set for "Automatic". Also be sure you don't have absolute references in the first cell. C3 should have =A3*B3 which will increment to =A4*B4 as you copy down. You may have =$A$3*$B$3 which fixes the references to just those two cells. Remove the $ signs from C3 formula and try again with the copy down. Don't forget the = sign Gord Dibben MS Excel MVP On Mon, 1 Oct 2007 14:34:00 0700, Excelless > wrote: > >But how do I create the formula itself? This just overwrote all the previous >data cells with the top cell's value  thx. > >"Excelless" wrote: > >> I am trying to make the same operation for each column  the only difference >> is in the rows, e.g. >> C3=A3*B* >> C4=A4*B4, etc. >> >> I don't want to have to reenter a similar formula for each added row. >> >> Thanks. 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Merging adjacent repeated columns with a macro  [email protected]  Excel Discussion (Misc queries)  2  April 3rd 07 07:44 PM 
how do I create a formula in excel with using 2 columns of info?  Sloth  Excel Worksheet Functions  0  August 17th 06 08:35 PM 
Printing text in a repeated cell/row that is longer than repeated  Valerie Dyet  Excel Discussion (Misc queries)  1  February 13th 06 04:27 AM 
Repeated Columns Don't look same on all pages...  Al Franz  New Users to Excel  1  February 24th 05 03:59 PM 
repeated transpose from rows to columns with unequal groups  kraymond  Excel Discussion (Misc queries)  3  December 20th 04 03:39 PM 