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

7/11 Completed! Learn much more about ranges >
Go to Next Chapter: Formulas and Functions   |   Become an Excel Pro: 300 Examples