Abstract
Transcript
In this video, we’ll review shortcuts and commands for Paste Special.
As you might already know, Paste special is a gateway to many powerful operations in Excel.
In Windows, you might pop in a letter to select options.
On the Mac, you’ll need to punch in the Command key plus a letter.
I’ll run through a few examples.
This table is a mix of regular data and formulas, along with various formatting.
This converts all formulas to values and strips all formatting.
Paste special with U, maintains number formatting, but gets rid of formulas.
Paste special with R keeps formulas and number formats, but drops everything else.
This can be a good way to clean up a table copied in from somewhere else.
When you want to convert to values, and retain all formatting, use Paste Special twice.
The first time, use with V for values.
Then, use it again with T to bring in formatting.
Now you’ll have a replica of the original data without formulas.
you could also use Paste Special with to copy formatting only.
In this example, new data has been pasted below with no formatting.
So, for example if we copy this sheet, then mess up the columns.
This can be a handy way to make one sheet look like another.
Paste Special also gives you a way to perform math on cells without using formulas.
Finally, there are two more interesting options at the bottom of the Paste Special dialog.
