{"id":117,"date":"2018-12-27T17:16:13","date_gmt":"2018-12-27T17:16:13","guid":{"rendered":"https:\/\/www.howtoexcel.info\/Excel\/?p=117"},"modified":"2021-09-29T06:03:21","modified_gmt":"2021-09-29T06:03:21","slug":"paste-non-blanks","status":"publish","type":"post","link":"https:\/\/www.howtoexcel.info\/Excel\/paste-non-blanks\/","title":{"rendered":"How to copy and paste only non blank cells in Excel?"},"content":{"rendered":"\r\n<p><span style=\"color: #000000;\">Easiest way to do this is by the use of a filter. Please refer to the following excel spreadsheet for example.<\/span><\/p>\r\n<p><span style=\"color: #000000;\">1. Before filtering<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Filter_Blanks\/excel_to_filter_blanks1.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\"> 2. Select Filter option under Data tab.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Filter_Blanks\/excel_to_filter_blanks2.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\"> 3. In the filter checkbox list, uncheck the item &#8216;blanks&#8217;<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/paste_non_blanks\/paste_non_blanks2a.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\"> 4. After filtering. There are no blanks in the filtered list.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/paste_non_blanks\/paste_non_blanks3.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\"> 5. Simply copy and paste the cells to required location on the sheet.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/paste_non_blanks\/paste_non_blanks4.JPG\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000; font-size: 12px;\"><strong>Search engine keywords for this question:<\/strong><\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">Cannot copy paste non blank cells in Excel 2007, 2010<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">Pasting non blank cells do not work<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">How to avoid blanks in excel<\/span><\/p>\r\n<p><span style=\"color: #000000; font-size: 10px;\">How to eliminate blank cells while pasting data<\/span><\/p>\r\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/117"}],"collection":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/comments?post=117"}],"version-history":[{"count":6,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/117\/revisions"}],"predecessor-version":[{"id":267,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/117\/revisions\/267"}],"wp:attachment":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/media?parent=117"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/categories?post=117"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/tags?post=117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}