Microsoft Excel logo on a green background

When you paste data you’ve copied in Microsoft Excel, content in the destination cells is automatically overwritten. This may be the intent in many cases, but probably not if the copied cells include blanks.

With a couple of extra clicks, you can skip blanks when you paste in Microsoft Excel. By pasting everything except cells that are empty, you can keep the data that’s already there and simply replace the rest.

RELATED: How to Highlight Blanks or Errors in Microsoft Excel

How to Skip Blank Cells When Pasting in Excel

To best illustrate how to skip blanks when you paste in Excel, we’ll use an example. On the left side of our sheet are the previous sales amounts and on the right are the updated amounts. We need to replace the previous with the updated.

Cell ranges to copy and paste in Excel

But as you can see, the updated amounts include blanks because those particular sales didn’t change. So, we want to keep the existing amounts in those cases as-is. We’ve highlighted a particular example in the screenshot below.

Highlighted cell ranges to copy and paste in Excel

If we copy and paste the updated cell range, the blanks will overwrite our existing amounts. We can certainly copy and paste one cell at a time or even a few adjacent cells at once. But, to eliminate that extra work, we can copy and paste the entire range and replace everything except the blanks.

Advertisement

Select the cells you want to copy and either right-click and select “Copy” or go to the Home tab and click “Copy” in the Clipboard section of the ribbon.

Right-click and pick Copy

Select the destination cells where you want to paste the copied cells. Either right-click, select Paste Special, and pick “Paste Special” in the pop-out menu or go to the Home tab, click “Paste” from the ribbon, and pick “Paste Special.”

Right-click and pick Paste Special

When the Paste Special window opens, check the box at the bottom for Skip Blanks. You can adjust any other options in the Paste and Operation sections as needed. Click “OK” when you finish.

Check the box to Skip Blanks

RELATED: How to Add or Multiply Values with Paste Special in Microsoft Excel

You should then see your copied cells pasted into their destination cells without the blanks overwriting the existing data.

Skipped blanks in pasted cells

The Paste Special option to Skip Blanks doesn’t just work with cell ranges. You can also use it if you’re pasting columns or rows that include empty cells.

If you’re working with a spreadsheet that has hidden cells, check out how to copy and paste only visible cells in Excel.

Profile Photo for Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio ยป

The above article may contain affiliate links, which help support How-To Geek.