| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to copy rng of cells where (value is met) to anther sheet | Excel Worksheet Functions | |||
| how do i copy formula down columns avoiding hidden cells | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How do you copy a cell's content verses it's formula? | Excel Discussion (Misc queries) | |||
| How do I copy formula cells from one worksheet to another? | Excel Worksheet Functions | |||
Linear Mode
