How To Skip Blanks Using Paste in Excel

by

Normally, when you copy a range of data cells into a new range that contains data already, it overwrites the new range. But, what if you want to add content from new range excluding blanks to the old cell range.

Worked Example:   Find Percentage Change Between Numbers

Use the ‘Paste Special Skip Blanks’ option and Excel will not overwrite existing values with blanks.

Worked Example:   How to calculate percentage of total in Excel

1. Select the range B1:B12.

2. Right click, and then click Copy.

Worked Example:   Check if range contains a value not in another range in Excel

3. Select cell A1.

4. Right click, and then click Paste Special.

5. Check Skip Blanks.

6. Click OK.

Leave a Reply

Your email address will not be published. Required fields are marked *