software

I have a formula in say column D amp; 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: www.excelforum.com/member.php...oamp;userid=32158
View this thread: www.excelforum.com/showthread...hreadid=520186Exactly what keystrokes or mouse actions are you using to copy the formulas?

quot;chrissywhittlequot;
lt;chrissywhittle.24d2ay_1141838101.0849@excelforu m-nospam.comgt; wrote in
message news:chrissywhittle.24d2ay_1141838101.0849@excelfo rum-nospam.com...
gt;
gt; I have a formula in say column D amp; have copied it across to various
gt; other columns, the thing is is that the copied cells do not have the
gt; same formula as in cell D (it adds a column instead of copyin the
gt; formula) thank you in advance
gt;
gt;
gt; --
gt; chrissywhittle
gt; ------------------------------------------------------------------------
gt; chrissywhittle's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32158
gt; View this thread: www.excelforum.com/showthread...hreadid=520186
gt;

edit - copy - paste
right click copy - paste or paste special--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: www.excelforum.com/member.php...oamp;userid=32158
View this thread: www.excelforum.com/showthread...hreadid=520186OK. And, you say it quot;adds a columnquot;. 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?

quot;chrissywhittlequot;
lt;chrissywhittle.24d38a_1141839301.2623@excelforu m-nospam.comgt; wrote in
message news:chrissywhittle.24d38a_1141839301.2623@excelfo rum-nospam.com...
gt;
gt; edit - copy - paste
gt; right click copy - paste or paste special
gt;
gt;
gt; --
gt; chrissywhittle
gt; ------------------------------------------------------------------------
gt; chrissywhittle's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32158
gt; View this thread: www.excelforum.com/showthread...hreadid=520186
gt;

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: www.excelforum.com/member.php...oamp;userid=32158
View this thread: www.excelforum.com/showthread...hreadid=520186OK. When you copy a formula, Excel increments (quot;stepsquot;) cell numbers in a
relative way. In other words, if you type =A1 4 in cell B1, Excel really
sees that as quot;look one cell to the leftquot;, 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.

quot;chrissywhittlequot;
lt;chrissywhittle.24d60a_1141842901.4344@excelforu m-nospam.comgt; wrote in
message news:chrissywhittle.24d60a_1141842901.4344@excelfo rum-nospam.com...
gt;
gt; sorry, the column numbers change:
gt;
gt; say i have an amount i wish to multiply by in row 5B and in colums c,d,
gt; etc have different values, i wish to use row 5b as my mulitipliction
gt; 'master'. the same formula will be used throughout all coloumns the
gt; only change being the different values in columns c,d,etc. thank you
gt;
gt;
gt; --
gt; chrissywhittle
gt; ------------------------------------------------------------------------
gt; chrissywhittle's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32158
gt; View this thread: www.excelforum.com/showthread...hreadid=520186
gt;
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

quot;chrissywhittlequot;
lt;chrissywhittle.24d2ay_1141838101.0849@excelforu m-nospam.comgt; wrote in
message news:chrissywhittle.24d2ay_1141838101.0849@excelfo rum-nospam.com...
gt;
gt; I have a formula in say column D amp; have copied it across to various
gt; other columns, the thing is is that the copied cells do not have the
gt; same formula as in cell D (it adds a column instead of copyin the
gt; formula) thank you in advance
gt;
gt;
gt; --
gt; chrissywhittle
gt; ------------------------------------------------------------------------
gt; chrissywhittle's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32158
gt; View this thread: www.excelforum.com/showthread...hreadid=520186
gt;

thank you all so very much --
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: www.excelforum.com/member.php...oamp;userid=32158
View this thread: www.excelforum.com/showthread...hreadid=520186
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 ($B3amp;d15),b3*e15, b3*f15 etc.... but its not working it will
change the formula--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: www.excelforum.com/member.php...oamp;userid=32158
View this thread: www.excelforum.com/showthread...hreadid=520186
sorry im a complete doughnut! - i was writing the formula incorrectly -
sorry!!!!--
chrissywhittle
------------------------------------------------------------------------
chrissywhittle's Profile: www.excelforum.com/member.php...oamp;userid=32158
View this thread: www.excelforum.com/showthread...hreadid=520186