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:   To count total rows in a range in Excel

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

Worked Example:   How to Separate Text Strings in Excel

1. Select the range B1:B12.

2. Right click, and then click Copy.

Worked Example:   How to calculate decrease by percentage 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 *