January 23, 2022

Easy methods to Skip Pasting Clean Cells When Copying in Microsoft Excel

Microsoft Excel logo on a green background

If you paste knowledge you’ve copied in Microsoft Excel, content material within the vacation spot cells is robotically overwritten. This can be the intent in lots of circumstances, however in all probability not if the copied cells embody blanks.

With a few further clicks, you’ll be able to skip blanks once you paste in Microsoft Excel. By pasting every little thing besides cells that are empty, you’ll be able to hold the info that’s already there and easily change the remainder.

RELATED: How to Highlight Blanks or Errors in Microsoft Excel

Easy methods to Skip Clean Cells When Pasting in Excel

To greatest illustrate how you can skip blanks once you paste in Excel, we’ll use an instance. On the left facet of our sheet are the earlier gross sales quantities and on the precise are the up to date quantities. We have to change the earlier with the up to date.

Cell ranges to copy and paste in Excel

However as you’ll be able to see, the up to date quantities embody blanks as a result of these specific gross sales didn’t change. So, we need to hold the present quantities in these circumstances as-is. We’ve highlighted a specific instance within the screenshot beneath.

Highlighted cell ranges to copy and paste in Excel

If we copy and paste the up to date cell vary, the blanks will overwrite our current quantities. We are able to actually copy and paste one cell at a time or perhaps a few adjoining cells without delay. However, to get rid of that further work, we will copy and paste the complete vary and change every little thing besides the blanks.

Select the cells you need to copy and both right-click and choose “Copy” or go to the House tab and click on “Copy” within the Clipboard part of the ribbon.

Right-click and pick Copy

Choose the vacation spot cells the place you need to paste the copied cells. Both right-click, choose Paste Particular, and decide “Paste Particular” within the pop-out menu or go to the House tab, click on “Paste” from the ribbon, and decide “Paste Particular.”

Right-click and pick Paste Special

When the Paste Particular window opens, test the field on the backside for Skip Blanks. You possibly can modify some other choices within the Paste and Operation sections as wanted. Click on “OK” once you end.

Check the box to Skip Blanks

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

It is best to then see your copied cells pasted into their vacation spot cells with out the blanks overwriting the present knowledge.

Skipped blanks in pasted cells

The Paste Particular choice to Skip Blanks doesn’t simply work with cell ranges. You can too use it when you’re pasting columns or rows that embody empty cells.

Should you’re working with a spreadsheet that has hidden cells, try how you can copy and paste only visible cells in Excel.