Skip Blanks

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

1. Select the range B1:B12.

2. Right click, and then click Copy.

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.