formula wont copy across to other cells correctly
 

I have a formula in say column D & have copied it across to various
other columns, the thing is is that the copied cells do not have the
same formula as in cell D (it adds a column instead of copyin the
formula) thank you in advance


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186

formula wont copy across to other cells correctly
 

Exactly what keystrokes or mouse actions are you using to copy the formulas?

"chrissywhittle"
<chrissywhittle.24d2ay_1141838101.0849@excelforu m-nospam.com wrote in
message news:chrissywhittle.24d2ay_1141838101.0849@excelfo rum-nospam.com...

I have a formula in say column D & have copied it across to various
other columns, the thing is is that the copied cells do not have the
same formula as in cell D (it adds a column instead of copyin the
formula) thank you in advance


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile:
http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186

formula wont copy across to other cells correctly
 

edit - copy - paste
right click copy - paste or paste special


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186

formula wont copy across to other cells correctly
 

OK. And, you say it "adds a column". Do you mean that (for instance), if you
had column F and column G, an actual column is inserted between them, as if
you had used the Insert, Column menu commands? Or, that the column numbers
are changing when you copy the formulae across?

"chrissywhittle"
<chrissywhittle.24d38a_1141839301.2623@excelforu m-nospam.com wrote in
message news:chrissywhittle.24d38a_1141839301.2623@excelfo rum-nospam.com...

edit - copy - paste
right click copy - paste or paste special


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile:
http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186

formula wont copy across to other cells correctly
 

sorry, the column numbers change:

say i have an amount i wish to multiply by in row 5B and in colums c,d,
etc have different values, i wish to use row 5b as my mulitipliction
'master'. the same formula will be used throughout all coloumns the
only change being the different values in columns c,d,etc. thank you


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186

formula wont copy across to other cells correctly
 

OK. When you copy a formula, Excel increments ("steps") cell numbers in a
relative way. In other words, if you type =A1+4 in cell B1, Excel really
sees that as "look one cell to the left", not necessarily as A1. When you
copy the formula across the row, it'll change the A1 to B1, C1, etc. To stop
this behavior, add a dollar sign to the original formula: =$A1+4. This is
called an absolute reference.

"chrissywhittle"
<chrissywhittle.24d60a_1141842901.4344@excelforu m-nospam.com wrote in
message news:chrissywhittle.24d60a_1141842901.4344@excelfo rum-nospam.com...

sorry, the column numbers change:

say i have an amount i wish to multiply by in row 5B and in colums c,d,
etc have different values, i wish to use row 5b as my mulitipliction
'master'. the same formula will be used throughout all coloumns the
only change being the different values in columns c,d,etc. thank you


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile:
http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186

formula wont copy across to other cells correctly
 

Hi chrissywhittle,

To add to Doug's replies. Type a formula in any cell such as =A1. You can
use F4 to toggle through the different styles of absolute references. =$A1,
=A$1, =$A$1.

HTH
Regards,
Howard

"chrissywhittle"
<chrissywhittle.24d2ay_1141838101.0849@excelforu m-nospam.com wrote in
message news:chrissywhittle.24d2ay_1141838101.0849@excelfo rum-nospam.com...

I have a formula in say column D & have copied it across to various
other columns, the thing is is that the copied cells do not have the
same formula as in cell D (it adds a column instead of copyin the
formula) thank you in advance


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile:
http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186

formula wont copy across to other cells correctly
 

thank you all so very much :)


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186

formula wont copy across to other cells correctly
 

thank you all so very much it worked for a while yet it is still doing
it
the formula has changed the original column say my original formula is
=sum($B3*C15) I would like the same formula along the rest of the row
being ($B3&d15),b3*e15, b3*f15 etc.... but its not working it will
change the formula


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186

formula wont copy across to other cells correctly
 

sorry im a complete doughnut! - i was writing the formula incorrectly -
sorry!!!!


--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: http://www.excelforum.com/member.php...o&userid=32158
View this thread: http://www.excelforum.com/showthread...hreadid=520186

formula wont copy across to other cells correctly
 

"chrissywhittle"
<chrissywhittle.24dnlm_1141865701.6365@excelforu m-nospam.com wrote in
message news:chrissywhittle.24dnlm_1141865701.6365@excelfo rum-nospam.com...

sorry im a complete doughnut! - i was writing the formula incorrectly -
sorry!!!!

I was about to say "THINK!", but you got it. :-)