Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

How To Skip Blanks Using Paste in Excel

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:   Count Cells with Text in Excel

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

Worked Example:   How To Create Budget 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. Required fields are marked *