Lesson#130: Paste special with skip blanks

Here I am having an example to show you the Paste Special with skip blanks.

Serials are incomplete in both columns. In column A even numbers are absent and in column B odd numbers are absent. If you have to paste and merge both columns then follow these steps.

Select any of the ranges and copy it then right click on the other column and click on Paste Special.

Select the Skip blanks option and click on OK.

here how it works. I hope you liked this small post.

Puspendu is the founder author of Excelabcd. He is a creative person, blogger and Excel-maniac guy.

Tagged with:

Leave a Reply

Your email address will not be published. Required fields are marked *

*