{"id":328808,"date":"2021-08-22T18:00:33","date_gmt":"2021-08-22T15:00:33","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-remove-duplicate-or-blank-rows-from-a-table-in-microsoft-excel\/"},"modified":"2021-08-22T18:00:33","modified_gmt":"2021-08-22T15:00:33","slug":"how-to-remove-duplicate-or-blank-rows-from-a-table-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-remove-duplicate-or-blank-rows-from-a-table-in-microsoft-excel\/","title":{"rendered":"#How to Remove Duplicate or Blank Rows From a Table in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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-6a39b79ad818e\" 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-6a39b79ad818e\" 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-remove-duplicate-or-blank-rows-from-a-table-in-microsoft-excel\/#Remove_Duplicate_Rows_in_an_Excel_Table\" >Remove Duplicate Rows in an Excel Table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-remove-duplicate-or-blank-rows-from-a-table-in-microsoft-excel\/#Remove_Blank_Rows_in_an_Excel_Table\" >Remove Blank Rows in an Excel Table<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Remove Duplicate or Blank Rows From a Table in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?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\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Running into duplicate or missing rows in your spreadsheets can be a big problem. Whether it\u2019s because of data entry errors or import problems, mistakes h<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>en. We\u2019ll show you how to correct these issues in your Excel sheet tables.<\/p>\n<p>It\u2019s possible to find duplicates and highlight blanks in an Excel sheet using conditional formatting. However, when you\u2019re working with a table, handling these issues instead of just highlighting them can actually be a bit easier.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Remove_Duplicate_Rows_in_an_Excel_Table\"><\/span>Remove Duplicate Rows in an Excel Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you would rather highlight your duplicate data so that you can correct it, you\u2019ll want to use the conditional formatting described earlier. But if you want to simply delete all duplicate rows in your table, it takes just a few clicks.<\/p>\n<p>Select a cell in your table. Then, head to the Table Design tab that displays and click \u201cRemove Duplicates\u201d in the Tools section of the ribbon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741740\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/TableDesignRemoveDuplicates-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"On the Table Design tab, click Remove Duplicates\" width=\"650\" height=\"208\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see the Remove Duplicates window open. If your table has headers, check the box for that option. These headers will display as your column selection options below. If you don\u2019t have headers, you\u2019ll just see Column A, Column B, and so on.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741741\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/RemoveDuplicatesHasHeaders-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Mark if your table has headers\" width=\"650\" height=\"280\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then, choose the columns that have the duplicate data you want to remove. By default, all table columns are marked. You can check specific columns by clicking \u201cUnselect All\u201d and then marking the individual columns. Or you can click \u201cSelect All\u201d if you change your mind.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741742\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/RemoveDuplicatesSelectColumns-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the columns containing duplicates\" width=\"433\" height=\"320\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you\u2019re ready, click \u201cOK.\u201d You will not see the duplicates highlighted nor will you have any indication of what\u2019s been removed. But you <em>will<\/em> see the number of duplicates that were found and deleted.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741744\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/RemoveDuplicatesFound-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"An excel prompt with the number of duplicates found\" width=\"462\" height=\"145\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For a simple example using the screenshot below, you can see the duplicates in our table and then the end result after removing them.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741743\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/DuplicatesFoundRemoved-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Duplicates found and removed in an Excel table\" width=\"650\" height=\"275\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Remove_Blank_Rows_in_an_Excel_Table\"><\/span>Remove Blank Rows in an Excel Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To delete blank rows in your Excel table, you\u2019ll use the filter feature. Since tables can already have filter buttons in the headers, you don\u2019t have to take an extra step to enable filters.<\/p>\n<blockquote class=\"admonishment_tip\"><p><strong>Tip:<\/strong> If you don\u2019t see the filter buttons, go to the Table Design tab and check the box for Filter Button.<\/p><\/blockquote>\n<p>Click the filter button in one of your column headers. At the bottom of the pop-up window (below Search), uncheck the box for Select All. Then scroll to the bottom of the items, check the box for Blanks, and click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741747\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/FilterDeselectAllBlanks-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Uncheck Select All and check Blanks\" width=\"610\" height=\"496\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> If you do not see an option for Blanks in the filter settings, then you do not have any in that table column.<\/p><\/blockquote>\n<p>Next, you\u2019ll see the table adjust to display only blank rows with the remaining data hidden from view. You can then delete the blank rows. You\u2019ll notice that the row headers are highlighted in blue, making them easier to see and select.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741748\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/FilteredBlankRows-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Filtered blank rows in an Excel table\" width=\"400\" height=\"145\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select a blank row, right-click, and pick \u201cDelete Row.\u201d You can do this for each blank row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741751\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/DeleteBlankRow-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Right-click and pick Delete Row\" width=\"395\" height=\"470\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<blockquote class=\"admonishment_warning\"><p><strong>Warning:<\/strong> Do not drag through the blank rows to select and delete them. If you do this, that selection may include hidden rows that are not blank.<\/p><\/blockquote>\n<p>Once you\u2019ve removed the blank rows in your table, you can clear the filter. Click the filter button next to the column header again and select \u201cClear Filter From.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-741749 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/ClearFilterFromBlanks-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Clear the filter\" width=\"376\" height=\"497\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see your table back to its normal view and unfiltered with your blank rows gone.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-741750\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/BlankRowsFoundRemoved-ExcelTable.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Blank rows found and removed in an Excel table\" width=\"650\" height=\"280\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For advanced data analysis in Excel, consider creating a pivot table.<\/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\/741738\/how-to-remove-duplicate-or-blank-rows-from-a-table-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Remove Duplicate or Blank Rows From a Table in Microsoft Excel&#8221; Running into duplicate or missing rows in your spreadsheets can be a big problem. Whether it\u2019s because of data entry errors or import problems, mistakes happen. We\u2019ll show you how to correct these issues in your Excel sheet tables. It\u2019s possible to&#8230;<\/p>\n","protected":false},"author":1,"featured_media":328809,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-328808","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\/328808","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=328808"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/328808\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/328809"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=328808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=328808"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=328808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}