Tag Archives: Skip Blanks

How to use Skip Blanks in Paste Special and what does the feature do

There is an option Skip blanks in Excel’s Paste Special -dialog. You may have wondered what is the purpose of that feature.

After watching this video, you will know 🙂

The big secret has now been revealed: Skip blanks pastes only non blank cells and leaves other cells untouched.