Home 
Excel 2007 Paste Special Skip Blanks
Search MS Office A-Z | Search Web Pages/ Design A-Z
Skip Blanks
Checkmark Skip Blanks if your range of source cells includes some blank cells you don’t want to overwrite existing data. For example, you may have set things up so that you only want to copy over destination data when new data exists. If a cell in the source is blank, you want to keep the destination cell’s data intact. If you choose Skip Blanks, whenever Excel goes to paste a blank cell over a cell that contains data, it stops and leaves the destination data in place.
Home Excel 2007 Paste Special Skip Blanks
Search MS Office A-Z | Search Web Pages/ Design A-Z