{"id":180,"date":"2016-06-01T11:39:47","date_gmt":"2016-06-01T10:39:47","guid":{"rendered":"https:\/\/doctorcarparts.com\/blog\/?p=180"},"modified":"2023-09-20T12:01:16","modified_gmt":"2023-09-20T11:01:16","slug":"delete-empty-columns-in-excel","status":"publish","type":"post","link":"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/","title":{"rendered":"How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values"},"content":{"rendered":"

On the net you will find lots of info on how to delete empty columns in excel, using ‘go to special’. These are useless if you have some columns which have ‘some <\/strong>blanks’<\/em> and are looking for columns which have ‘only<\/strong> blanks’<\/em>, because the method will delete the entire column even if it contains one blank cell.<\/p>\n

I prefer instead to use the COUNTBLANK formula. Simply go to the last row\/column of the data, and use countblank to find how many cells are empty\/blank. then combine it with an IF statement, so that if the number of blanks is greater than the total number of columns\/rows, then mark ‘delete’, and if not leave blank.<\/p>\n

After this you simply sort your data by the column\/row where you did the formula, and delete the relevant columns\/rows. (Remember, when trying to delete empty columns, you will need to sort the data by the row<\/strong> which contains the formula. You\u00a0do this by opening the ‘sort’ box and then\u00a0pressing ‘options’ button)<\/p>\n

Formula:<\/p>\n

IF(COUNTBLANK(R[-27110]C:R[-1]C)>27109,”delete”,””)<\/p>\n

in the above example, 27109 was the number of rows of data in my<\/strong> data – yours will be a different number.<\/p>\n

\"delete<\/a><\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

On the net you will find lots of info on how to delete empty columns in excel, using ‘go to special’. These are useless if you have some columns which have ‘some blanks’ and are looking for columns which have ‘only blanks’, because the method will delete the entire column even if it contains one … Continue reading How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[13],"tags":[69],"class_list":["post-180","post","type-post","status-publish","format-standard","hentry","category-random","tag-delete-empty-columns-in-excel"],"yoast_head":"\nHow to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values - Doctor Car Parts Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values - Doctor Car Parts Blog\" \/>\n<meta property=\"og:description\" content=\"On the net you will find lots of info on how to delete empty columns in excel, using ‘go to special’. These are useless if you have some columns which have ‘some blanks’ and are looking for columns which have ‘only blanks’, because the method will delete the entire column even if it contains one … Continue reading How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values\" \/>\n<meta property=\"og:url\" content=\"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Doctor Car Parts Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-01T10:39:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-20T11:01:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/doctorcarparts.com\/blog\/wp-content\/uploads\/2016\/06\/countblank-delete-empty-columns.jpg\" \/>\n<meta name=\"author\" content=\"Moiz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Moiz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/\",\"url\":\"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/\",\"name\":\"How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values - Doctor Car Parts Blog\",\"isPartOf\":{\"@id\":\"https:\/\/doctorcarparts.com\/blog\/#website\"},\"datePublished\":\"2016-06-01T10:39:47+00:00\",\"dateModified\":\"2023-09-20T11:01:16+00:00\",\"author\":{\"@id\":\"https:\/\/doctorcarparts.com\/blog\/#\/schema\/person\/421d943e6d3e0ad36aca109ee2ca4ee7\"},\"breadcrumb\":{\"@id\":\"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/doctorcarparts.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/doctorcarparts.com\/blog\/#website\",\"url\":\"https:\/\/doctorcarparts.com\/blog\/\",\"name\":\"Doctor Car Parts Blog\",\"description\":\"Car Parts and Motor Trade Banter\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/doctorcarparts.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/doctorcarparts.com\/blog\/#\/schema\/person\/421d943e6d3e0ad36aca109ee2ca4ee7\",\"name\":\"Moiz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/doctorcarparts.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/36af9ae8c4644b3fae095f3a0c14a0be6f03d6fa3dbcfafc5370014aaac12721?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/36af9ae8c4644b3fae095f3a0c14a0be6f03d6fa3dbcfafc5370014aaac12721?s=96&d=mm&r=g\",\"caption\":\"Moiz\"},\"url\":\"https:\/\/doctorcarparts.com\/blog\/author\/moiz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values - Doctor Car Parts Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/","og_locale":"en_GB","og_type":"article","og_title":"How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values - Doctor Car Parts Blog","og_description":"On the net you will find lots of info on how to delete empty columns in excel, using ‘go to special’. These are useless if you have some columns which have ‘some blanks’ and are looking for columns which have ‘only blanks’, because the method will delete the entire column even if it contains one … Continue reading How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values","og_url":"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/","og_site_name":"Doctor Car Parts Blog","article_published_time":"2016-06-01T10:39:47+00:00","article_modified_time":"2023-09-20T11:01:16+00:00","og_image":[{"url":"https:\/\/doctorcarparts.com\/blog\/wp-content\/uploads\/2016\/06\/countblank-delete-empty-columns.jpg"}],"author":"Moiz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Moiz","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/","url":"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/","name":"How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values - Doctor Car Parts Blog","isPartOf":{"@id":"https:\/\/doctorcarparts.com\/blog\/#website"},"datePublished":"2016-06-01T10:39:47+00:00","dateModified":"2023-09-20T11:01:16+00:00","author":{"@id":"https:\/\/doctorcarparts.com\/blog\/#\/schema\/person\/421d943e6d3e0ad36aca109ee2ca4ee7"},"breadcrumb":{"@id":"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/doctorcarparts.com\/blog\/delete-empty-columns-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/doctorcarparts.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Delete Empty Columns in Excel with all Empty \/ Blank Cell Values"}]},{"@type":"WebSite","@id":"https:\/\/doctorcarparts.com\/blog\/#website","url":"https:\/\/doctorcarparts.com\/blog\/","name":"Doctor Car Parts Blog","description":"Car Parts and Motor Trade Banter","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/doctorcarparts.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/doctorcarparts.com\/blog\/#\/schema\/person\/421d943e6d3e0ad36aca109ee2ca4ee7","name":"Moiz","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/doctorcarparts.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/36af9ae8c4644b3fae095f3a0c14a0be6f03d6fa3dbcfafc5370014aaac12721?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/36af9ae8c4644b3fae095f3a0c14a0be6f03d6fa3dbcfafc5370014aaac12721?s=96&d=mm&r=g","caption":"Moiz"},"url":"https:\/\/doctorcarparts.com\/blog\/author\/moiz\/"}]}},"_links":{"self":[{"href":"https:\/\/doctorcarparts.com\/blog\/wp-json\/wp\/v2\/posts\/180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/doctorcarparts.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/doctorcarparts.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/doctorcarparts.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/doctorcarparts.com\/blog\/wp-json\/wp\/v2\/comments?post=180"}],"version-history":[{"count":2,"href":"https:\/\/doctorcarparts.com\/blog\/wp-json\/wp\/v2\/posts\/180\/revisions"}],"predecessor-version":[{"id":184,"href":"https:\/\/doctorcarparts.com\/blog\/wp-json\/wp\/v2\/posts\/180\/revisions\/184"}],"wp:attachment":[{"href":"https:\/\/doctorcarparts.com\/blog\/wp-json\/wp\/v2\/media?parent=180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/doctorcarparts.com\/blog\/wp-json\/wp\/v2\/categories?post=180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/doctorcarparts.com\/blog\/wp-json\/wp\/v2\/tags?post=180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}