Using Skip blanks in Paste Special

What the Skip blanks does?

Excel Tips - Paste spceial with Skip Blank

Have you ever had this question?  From my experience, 99.9% users (I work with) have no idea what it is or even are not aware of that option in Paste Special.

Are you one of them?  Let’s try to understand what it does through the following imaginary conversation between Excel and you…

Excel: I am going to paste the copied range to the destination, but what do you want me to do with the blank cells in the copied range?

You: Skip them, please. (You tell Excel by checking the “Skip blanks” box)

Is it clear?  Not really??

Again, a screencast tells a thousand words:

Excel Tips - Paste spceial with Skip Blank

Note: A cell with empty space(s) is not “blank”.

Tip: If you want to paste without the formatting, select “Value” under paste option.


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.