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.

Advertisements

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 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:

WordPress.com Logo

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

Google photo

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

Twitter picture

You are commenting using your Twitter 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.