{"id":2021,"date":"2017-03-02T00:38:50","date_gmt":"2017-03-02T00:38:50","guid":{"rendered":"http:\/\/www.isumsoft.com\/it\/?p=2021"},"modified":"2019-11-26T02:28:58","modified_gmt":"2019-11-26T02:28:58","slug":"how-to-delete-blank-rows-columns-and-cells-in-excel-2016","status":"publish","type":"post","link":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/","title":{"rendered":"How to Delete Blank Rows, Columns, and Cells in Excel 2016"},"content":{"rendered":"

It\u2019s easy to delete one blank row, column, or cell in an Excel worksheet<\/strong>. Our usual practice is to right click on this blank row\/column\/cell and then select Delete. However, when one Excel sheet contains a large number of blank cells, deleting them one by one will be a big deal and very time-consuming. You don\u2019t have to do that. Actually, you can quickly delete all blank rows, columns, and cells in Excel<\/a> at once. Now, this post will show you how to do that with Excel 2016.<\/p>\n

How to quickly delete blank cells, rows, and columns in Excel 2016<\/h2>\n

Step 1: Open the target Excel worksheet.<\/p>\n

Step 2: Select the area that contains the blank cells, rows, or columns you want to delete.<\/p>\n

\"Select<\/p>\n

Step 3: Press the F5 key on your keyboard to bring up the Go To dialog, and then click Special.<\/p>\n

\"Click<\/p>\n

Alternatively, you can select the Home tab on Excel ribbon, click Find & Select, and then click Go To Special.<\/p>\n

\"Go<\/p>\n

Step 4: After the Go To Special dialog opens, select the Blanks option and click OK.<\/p>\n

\"Select<\/p>\n

Now the cells that contain data are de-selected, and the blank cells are selected, as shown below.<\/p>\n

\"Blank<\/p>\n

Step 5: Now click the Delete<\/strong> button under the Home tab, and then click Delete Cells<\/strong> from the drop-down menu.<\/p>\n

\"Click<\/p>\n

Step 6: When the Delete dialog pops up, with Shift cells up selected, click OK.<\/p>\n

\"Click<\/p>\n

Now all the blank cells in the selection are deleted.<\/p>\n

Notes: By this way, you should use Delete Cells, Delete Sheet Rows, and Delete Sheet Columns with caution. If you click Delete Cells, once the selected cell is deleted, the cells below the deleted cell will shift up by default. If your selected data range contains both blank rows and blank columns, clicking Delete Sheet Rows or Delete Sheet Columns will potentially destroy your data. Only when your selected range only contains blank rows or blank columns, can the Delete Sheet Rows or the Delete Sheet Columns command accurately delete the blank rows or columns.<\/p>\n","protected":false},"excerpt":{"rendered":"

It\u2019s easy to delete one blank row, column, or cell in an Excel worksheet. Our usual practice is to right click on this blank row\/column\/cell and then select Delete. However, when one Excel sheet contains a large number… <\/p>\n","protected":false},"author":2,"featured_media":5993,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-2021","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"yoast_head":"\nHow to Delete Blank Rows, Columns, and Cells in Excel 2016<\/title>\n<meta name=\"description\" content=\"If you are wondering how to delete all blank rows, columns and cells in an Microsoft Excel sheet at once, check out this post for the details.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Delete Blank Rows, Columns, and Cells in Excel 2016\" \/>\n<meta property=\"og:description\" content=\"If you are wondering how to delete all blank rows, columns and cells in an Microsoft Excel sheet at once, check out this post for the details.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/\" \/>\n<meta property=\"og:site_name\" content=\"iSumsoft\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/isumsofthome\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-02T00:38:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-26T02:28:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2017\/03\/delete-blank-row.png\" \/>\n\t<meta property=\"og:image:width\" content=\"476\" \/>\n\t<meta property=\"og:image:height\" content=\"222\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Darren\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:site\" content=\"@iSumsoft\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Darren\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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\":\"Article\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/\"},\"author\":{\"name\":\"Darren\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\"},\"headline\":\"How to Delete Blank Rows, Columns, and Cells in Excel 2016\",\"datePublished\":\"2017-03-02T00:38:50+00:00\",\"dateModified\":\"2019-11-26T02:28:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/\"},\"wordCount\":343,\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/delete-blank-row.png\",\"articleSection\":[\"Office\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/\",\"name\":\"How to Delete Blank Rows, Columns, and Cells in Excel 2016\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/delete-blank-row.png\",\"datePublished\":\"2017-03-02T00:38:50+00:00\",\"dateModified\":\"2019-11-26T02:28:58+00:00\",\"description\":\"If you are wondering how to delete all blank rows, columns and cells in an Microsoft Excel sheet at once, check out this post for the details.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/delete-blank-row.png\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/delete-blank-row.png\",\"width\":476,\"height\":222,\"caption\":\"Delete blank row\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Delete Blank Rows, Columns, and Cells in Excel 2016\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#website\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"name\":\"iSumsoft\",\"description\":\"Tell You More about IT World\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#organization\",\"name\":\"iSumsoft Studio\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/favicon.ico\",\"width\":16,\"height\":16,\"caption\":\"iSumsoft Studio\"},\"image\":{\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/isumsofthome\\\/\",\"https:\\\/\\\/x.com\\\/iSumsoft\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCL9RaYqRcQ0f0buIzXiaNDw\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/#\\\/schema\\\/person\\\/53553bf339aeb82b9c6a240f3b262798\",\"name\":\"Darren\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"contentUrl\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/wp-content\\\/wphb-cache\\\/gravatar\\\/e5e\\\/e5eca2e7a3c501250b3030d7070548bbx96.jpg\",\"caption\":\"Darren\"},\"url\":\"https:\\\/\\\/www.isumsoft.com\\\/it\\\/author\\\/darren-king\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Delete Blank Rows, Columns, and Cells in Excel 2016","description":"If you are wondering how to delete all blank rows, columns and cells in an Microsoft Excel sheet at once, check out this post for the details.","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:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/","og_locale":"en_US","og_type":"article","og_title":"How to Delete Blank Rows, Columns, and Cells in Excel 2016","og_description":"If you are wondering how to delete all blank rows, columns and cells in an Microsoft Excel sheet at once, check out this post for the details.","og_url":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/","og_site_name":"iSumsoft","article_publisher":"https:\/\/www.facebook.com\/isumsofthome\/","article_published_time":"2017-03-02T00:38:50+00:00","article_modified_time":"2019-11-26T02:28:58+00:00","og_image":[{"width":476,"height":222,"url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2017\/03\/delete-blank-row.png","type":"image\/png"}],"author":"Darren","twitter_card":"summary_large_image","twitter_creator":"@iSumsoft","twitter_site":"@iSumsoft","twitter_misc":{"Written by":"Darren","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/#article","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/"},"author":{"name":"Darren","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798"},"headline":"How to Delete Blank Rows, Columns, and Cells in Excel 2016","datePublished":"2017-03-02T00:38:50+00:00","dateModified":"2019-11-26T02:28:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/"},"wordCount":343,"publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2017\/03\/delete-blank-row.png","articleSection":["Office"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/","url":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/","name":"How to Delete Blank Rows, Columns, and Cells in Excel 2016","isPartOf":{"@id":"https:\/\/www.isumsoft.com\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2017\/03\/delete-blank-row.png","datePublished":"2017-03-02T00:38:50+00:00","dateModified":"2019-11-26T02:28:58+00:00","description":"If you are wondering how to delete all blank rows, columns and cells in an Microsoft Excel sheet at once, check out this post for the details.","breadcrumb":{"@id":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/#primaryimage","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2017\/03\/delete-blank-row.png","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2017\/03\/delete-blank-row.png","width":476,"height":222,"caption":"Delete blank row"},{"@type":"BreadcrumbList","@id":"https:\/\/www.isumsoft.com\/it\/how-to-delete-blank-rows-columns-and-cells-in-excel-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.isumsoft.com\/it\/"},{"@type":"ListItem","position":2,"name":"How to Delete Blank Rows, Columns, and Cells in Excel 2016"}]},{"@type":"WebSite","@id":"https:\/\/www.isumsoft.com\/it\/#website","url":"https:\/\/www.isumsoft.com\/it\/","name":"iSumsoft","description":"Tell You More about IT World","publisher":{"@id":"https:\/\/www.isumsoft.com\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.isumsoft.com\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.isumsoft.com\/it\/#organization","name":"iSumsoft Studio","url":"https:\/\/www.isumsoft.com\/it\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/uploads\/2019\/11\/favicon.ico","width":16,"height":16,"caption":"iSumsoft Studio"},"image":{"@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/isumsofthome\/","https:\/\/x.com\/iSumsoft","https:\/\/www.youtube.com\/channel\/UCL9RaYqRcQ0f0buIzXiaNDw"]},{"@type":"Person","@id":"https:\/\/www.isumsoft.com\/it\/#\/schema\/person\/53553bf339aeb82b9c6a240f3b262798","name":"Darren","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","url":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","contentUrl":"https:\/\/www.isumsoft.com\/it\/wp-content\/wphb-cache\/gravatar\/e5e\/e5eca2e7a3c501250b3030d7070548bbx96.jpg","caption":"Darren"},"url":"https:\/\/www.isumsoft.com\/it\/author\/darren-king\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/2021","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/comments?post=2021"}],"version-history":[{"count":0,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/posts\/2021\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media\/5993"}],"wp:attachment":[{"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/media?parent=2021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/categories?post=2021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isumsoft.com\/it\/wp-json\/wp\/v2\/tags?post=2021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}