Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi:
I have this formula in C5:=$A$4*8*C4 What is difference between: copy and paste special, formula in other cells from row 5 and drag it as it is; I do not see any difference in the result but I think the right way is to copy and paste special; any comments? Thanks, Dan |
#2
![]() |
|||
|
|||
![]()
You are right that the result returned will be the same either way. I think
that the difference is that if you paste (not paste special) then formats, fonts, borders, cell comments and validation also get copied. -- Return email address is not as DEEP as it appears "D" wrote in message ... Hi: I have this formula in C5:=$A$4*8*C4 What is difference between: copy and paste special, formula in other cells from row 5 and drag it as it is; I do not see any difference in the result but I think the right way is to copy and paste special; any comments? Thanks, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
How do I copy a formula in excel where part remains absolute the . | Excel Discussion (Misc queries) | |||
Copy a Formula down with a Twist Q | Excel Worksheet Functions | |||
How do I copy a formula? | Excel Worksheet Functions | |||
Copy formula to every 12th cell | Excel Worksheet Functions |