After copying data, the Paste Special option provides over a dozen ways to paste results. In this video, learn how to use Paste Special options to paste results in a variety of creative ways.
- [Instructor] When you're copying and pasting data, … sometimes you need to rely on special features. … And many times these are found … in the dialog box called Paste Special … and a quick way to get there is Control + Alt + V. … on this first worksheet called Skip Blanks, … I've got some data in column A. … I want to put that data in the column B … and I got about 10 entries here. … And rather than doing this one by one, … in other words, copying this A1 into B1 … and then A9 into B9, … why not just take all of these? … Let's copy them with control + C. … Now, if I do a simple paste in B1 using Control + V, … I wipe out the numbers that had been there in column B, … and I don't want to do that. … So undo that with Control + Z. … So the data has been copied. … Now I'm going to go to cell B1 … and activate Paste Special, Control + Alt + V. … And what do I want to do? … I don't want to be copying the data from A2, A3, … there's actually nothing there, those are blanks. … So what do I want to do in the Paste Special Dialog Box? …
Author
Dennis Taylor
Updated
3/2/2021Released
1/16/2015Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Intermediate
Duration
Views
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
-
Excel Tips - New This Week
-
Previous Episodes
-
Quick formatting tips8m 9s
-
Create an organization chart8m 56s
-
Auditing9m 1s
-
Adding comments and shapes7m 35s
-
Creating an Excel template7m 57s
-
Adjust banded-row formatting14m 35s
-
Dealing with circular errors8m 20s
-
Sorting tips and shortcuts8m 40s
-
Freeze Panes and Split5m 30s
-
Calculate % of change5m 41s
-
How to adjust names5m 45s
-
Sorting by moving columns4m 16s
-
Using the Solver Add-in4m 29s
-
Create picture links5m 37s
-
Display large values5m 16s
-
Create a powerful macro4m 40s
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Explore Paste Special options: Skip Blanks, Column Widths, Add, Transpose, and more