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.

Right Click Copy

3. Select cell A1.

4. Right click, and then click Paste Special.

5. Check Skip Blanks.

Check Skip Blanks

6. Click OK.

Paste Special Skip Blanks in Excel

Do you like this free website? Please follow us on Google+