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 paste data and formats in multiple ways! From Transpose to pasting as an image. There is so much available in Excels Paste Special.
It is even possible to carry out a mathematical operation ( add, subtract, multiply or divide) on values that you have pasted using Paste Special.
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 in Excel.
In this video, we will look at a number of the paste options such as paste values, paste formats, paste images, paste links, transpose. You will learn how you can quickly paste data and formats the way you want them. And you will learn how to paste with operations carried out on the values.
In the video above, there is an error in the example of Pasting with Operators. Did you spot the mistake? If you did you are an Eagle Excellier ! Well done you!
In the video below we will walk through the mistake made when using paste special to paste with mathematical operators applied. We will then look at the solutions available so you don’t hit the same problem. Finally we will look at another example of the use of Paste Special with operators.
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