Thursday, 21 February 2013

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 :-)


Tip: If you have difficulties to see the video, try to maximise it from lower right corner:



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

No comments:

Post a Comment