Forum Discussion
Solved
Understanding the specific. Differences between Paste All and Paste all using sourcing theme
Paste and Paste Special Hi, I'm curious what is a differences between Paste All (CTRL+V) and Paste all using sourcing theme? I tried with a few things e.g. copy cells, copy chart it gave ...
- I tried so many things and finally got the answer, this options is used for Copy and Paste in different workbook. If copy and paste in the same workbook, result will be as same as paste all.
Thank you every one for your input.
For example, in source theme default row height is 15 points and default font Trebuchet MS, target them - 12 points and Calibri.
Let say in source you have the cell with some value and yellow background, no other formatting.
Paste All returns yellow cell with same value; row height is 12 and font is Calibri as default in target workbook.
Paste All using Source theme returns yellow cell with same value, but row height with this cell will be changed on 15 points and font on Trebuchet MS.
I tried so many things and finally got the answer, this options is used for Copy and Paste in different workbook. If copy and paste in the same workbook, result will be as same as paste all.
Thank you so much for your input I kinda build up my test from your comment. Cheers!
Thank you so much for your input I kinda build up my test from your comment. Cheers!
M1931 , you are welcome, glad to help