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:   How to test for all values in a range are at least in Excel

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

Worked Example:   Hide and Unhide Columns or Rows in Excel

1. Select the range B1:B12.

2. Right click, and then click Copy.

Worked Example:   3D-reference example 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.