Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pasting formulas to different rows
attempting to copy and paste a formula from one row to another.
When I paste I use the Paste special command and select formulas. The data in the newly pasted cell shows the calculation from the copied cell, even though the formula window shows the correct formula for the new cell. EX Cell Q2 has the formula =I2/150, I2 =15973 brings back a value of 106 I paste the formula from Q2 to Q3, the formula is =I3/150. where I3 = 23826 I still get back a value of 106. When I retype =I3/150 into Q3 I get the correct value. I have the cells formatted to General. Please help Thanks |
#2
|
|||
|
|||
The only way I was able to duplicate your issue was to turn off the
automatic calculation option, otherwise, I was able to copy and paste the formula with no problem. Go to ToolsOptions. Under the Calculation tab, ensure that the Automatic option is checked. If you would rather leave it off, then pressing F9 after you copy and paste will manually recalc the sheet and will provide the desired result. HTH "herbertgroover" wrote in message ... attempting to copy and paste a formula from one row to another. When I paste I use the Paste special command and select formulas. The data in the newly pasted cell shows the calculation from the copied cell, even though the formula window shows the correct formula for the new cell. EX Cell Q2 has the formula =I2/150, I2 =15973 brings back a value of 106 I paste the formula from Q2 to Q3, the formula is =I3/150. where I3 = 23826 I still get back a value of 106. When I retype =I3/150 into Q3 I get the correct value. I have the cells formatted to General. Please help Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Pasting formulas problem | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
pasting formulas into a selection | Excel Worksheet Functions |