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.
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.
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.
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.
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.”
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.
It is best to then see your copied cells pasted into their vacation spot cells with out the blanks overwriting the present knowledge.
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.