Paste Special in Excel
Paste in Excel is one of the most commonly used functions. You do it, I do it, everyone using excel will paste something during the day. But did you know that Excel has a paste special option? An options that allows you to paste not only data, but formats, formulas, comments, values and in multiple ways! From Transpose to pasting as an image. There is so many options available when pasting in Excel.
It is even possible to carry out a mathematical operation ( add, subtract, multiply or divide) on values that you have copied using this options.
Paste Special Keyboard Shortcuts
So lets move beyond CTRL + V, the standard paste used in Excel and lets press CTRL + ALT + V and see how much you can really do when Pasting with Paste Special in Excel.
In this video I will demonstrate the use of Paste Special. We will look at a number of the paste options such as paste values, paste formats, transpose. You will learn how you can quickly copy and then paste data and formats the way you want them. And you will learn how to paste with operations carried out on the values. Operations such as adding numbers together by pasting. You gotta see it to believe it.
In return for this tip on Paste Special in Excel, I ask that you share this post or the video with your friends and colleagues
Sign up for my newsletter. Don’t worry, I wont spam. Just useful Excel and Power BI tips and tricks to your inbox
SIGN UP NOW
Do you want to start collecting rewards quickly for learning Excel? Then you should try:
Take A FREE course with us Today!
The Ultimate Excel Formulas Course
* includes XLOOKUP and will soon include Dynamic Arrays
I am having trouble with the Paste Special totaling the 2 Q’s. When I copy and paste special the ADD operation to gain the total of the 2 Q’s, the formula moves down two rows much as it would if you were copying a formula to total each row down a SS. Example if the range of cells in Q2 is B8:B10, the formula copies as B10:B12. I noticed your formula does the same thing but comes up with the correct total…mine does not.
Does that make sense?
Sorry not the 2Q’s but the 2 regions.
Hi Cathie,
Thank you for this, I had not noticed. Yes it makes sense. I will be posing an updated video this week to show how this problem happened and how to resolve it.
Cheers
Paula