Paste Special Skip Blanks In #Excel

Paste special skip blanks can be confusing. Here is a simple explanation as to how it works:

Here I have a small graphic with numbers 1 through 8 in column F, but 5 and 6 are missing and those cells are blank. I’m going to paste them into column G using the standard method of Ctrl + V, and also paste them into column H using Paste Special, Skip Blanks to show you the difference:

ps1

First, I’ll highlight the cells in column F and use Ctrl + C to copy them. Then, when I paste them using Ctrl + V into column G, here is the result:

ps2

Notice that it exactly duplicated what was in the copied cells, including the blanks.

Now, to choose Paste Special, Skip Blanks, I’ll right click on the first cell where I want to paste the copied cells, click on Paste Special, then check the box for Skip Blanks:

ps3

Now, when I click on OK, here is the result:

ps4

Notice how it copied all the cells into the destination range EXCEPT where there were blanks in the originating cells. In that case, it didn’t paste those blanks, but SKIPPED them and left the data that was in the destination cells.

I hope that made sense! Thanks for checking out this post. Please feel free to comment and share this information.

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , ,

No comments yet.

Leave a Reply