Paste without overwriting blank cells

Please purchase the course before starting the lesson.

You can even tell Excel, via Paste Special, to only update the cells that have information in them. If the updated cell is blank ignore it and leave the old information in.

So below we have a report with sales (B6 to B9). We have received information from different teams updating certain cells but leaving the ones they are not responsible for blank. If we copied and pasted, for example, B13 to B16 onto B6 to B9 it would overwrite some sales with a blank.

Paste Special Skip Blanks

To see the full course contents click here.

Back to: Intermediate Excel Course > The Specials- GOTO and Paste