{"id":370363,"date":"2021-11-21T19:00:53","date_gmt":"2021-11-21T16:00:53","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-skip-pasting-blank-cells-when-copying-in-microsoft-excel\/"},"modified":"2021-11-21T19:00:53","modified_gmt":"2021-11-21T16:00:53","slug":"how-to-skip-pasting-blank-cells-when-copying-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-skip-pasting-blank-cells-when-copying-in-microsoft-excel\/","title":{"rendered":"#How to Skip Pasting Blank Cells When Copying in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a27af22ae658\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a27af22ae658\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-skip-pasting-blank-cells-when-copying-in-microsoft-excel\/#How_to_Skip_Blank_Cells_When_Pasting_in_Excel\" >How to Skip Blank Cells When Pasting in Excel<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Skip Pasting Blank Cells When Copying in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you paste data you\u2019ve 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.<\/p>\n<p>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\u2019s already there and simply replace the rest.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Highlight Blanks or Errors in Microsoft Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Skip_Blank_Cells_When_Pasting_in_Excel\"><\/span>How to Skip Blank Cells When Pasting in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To best illustrate how to skip blanks when you paste in Excel, we\u2019ll 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.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761486\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PreviousUpdated-ExcelSkipBlanks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Cell ranges to copy and paste in Excel\" width=\"650\" height=\"107\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>But as you can see, the updated amounts include blanks because those particular sales didn\u2019t change. So, we want to keep the existing amounts in those cases as-is. We\u2019ve highlighted a particular example in the screenshot below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761487\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PreviousUpdatedHighlighted-ExcelSkipBlanks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Highlighted cell ranges to copy and paste in Excel\" width=\"650\" height=\"107\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>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 <em>except<\/em> the blanks.<\/p>\n<p>Select the cells you want to copy and either right-click and select \u201cCopy\u201d or go to the Home tab and click \u201cCopy\u201d in the Clipboard section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761488\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/CopyUpdated-ExcelSkipBlanks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click and pick Copy\" width=\"650\" height=\"299\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select the destination cells where you want to paste the copied cells. Either right-click, select Paste Special, and pick \u201cPaste Special\u201d in the pop-out menu or go to the Home tab, click \u201cPaste\u201d from the ribbon, and pick \u201cPaste Special.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761490\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PasteUpdated-ExcelSkipBlanks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click and pick Paste Special\" width=\"650\" height=\"374\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>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 \u201cOK\u201d when you finish.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761489\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PasteSpecial-ExcelSkipBlanks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Check the box to Skip Blanks\" width=\"547\" height=\"414\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Add or Multiply Values with Paste Special in Microsoft Excel<\/em><\/strong><\/p>\n<p>You should then see your copied cells pasted into their destination cells without the blanks overwriting the existing data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-761491\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/10\/PreviousUpdatedSkippedBlanks-ExcelSkipBlanks.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Skipped blanks in pasted cells\" width=\"650\" height=\"107\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The Paste Special option to Skip Blanks doesn\u2019t just work with cell ranges. You can also use it if you\u2019re pasting columns or rows that include empty cells.<\/p>\n<p>If you\u2019re working with a spreadsheet that has hidden cells, check out how to copy and paste only visible cells in Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/761484\/how-to-skip-pasting-blank-cells-when-copying-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Skip Pasting Blank Cells When Copying in Microsoft Excel&#8221; When you paste data you\u2019ve 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&#8230;<\/p>\n","protected":false},"author":1,"featured_media":370364,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-370363","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/370363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=370363"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/370363\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/370364"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=370363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=370363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=370363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}