{"id":6429,"date":"2023-05-12T01:28:03","date_gmt":"2023-05-12T01:28:03","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=6429"},"modified":"2024-05-14T07:35:59","modified_gmt":"2024-05-14T07:35:59","slug":"how-to-delete-blank-rows-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-delete-blank-rows-in-excel\/","title":{"rendered":"How to Delete Blank Rows in Excel?"},"content":{"rendered":"<p>Delete Blank Rows in Excel effortlessly streamlines your data cleaning process, ensuring optimal spreadsheet organization and efficiency. With Delete Blank Rows in Excel, you can say goodbye to cluttered worksheets and hello to a streamlined, professional presentation of your data. Eliminate the hassle of manual deletion and let this powerful tool do the work for you, saving you time and effort. Whether you&#8217;re working with large datasets or smaller tables, Delete Blank Rows in Excel provides a seamless solution for tidying up your spreadsheets. Take control of your data and enhance your productivity with Delete Blank Rows in Excel, the essential tool for maintaining clean and organized Excel files. Say farewell to unnecessary blank rows and hello to a more polished, professional presentation of your data. Experience the convenience and efficiency of Delete Blank Rows in Excel today and unlock the full potential of your spreadsheet management tasks.<\/p>\n<ol>\n<li><strong>This Content Covers:<\/strong><\/li>\n<li><a href=\"#how-to-delete-blank-rows-in-excel-with-options-and-tools?\"><strong> How to Delete Blank Rows in Excel with Options and Tools?<\/strong><\/a>\n<ul>\n<li><strong>Using Go to Special Dialogue Box <\/strong><\/li>\n<li><strong>Using Find Option<\/strong><\/li>\n<li><strong>With Filter Option<\/strong><\/li>\n<li><strong>Using Advanced Filter Option<\/strong><\/li>\n<li><strong>With Sort Option<\/strong><\/li>\n<li><strong>Using Power Query<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-delete-blank-rows-in-excel-with-functions?\"><strong> How to Delete Blank Rows in Excel with Functions?<\/strong><\/a>\n<ul>\n<li><strong>Using FILTER Function<\/strong><\/li>\n<li><strong>Using COUNTBLANK Function<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#delete-blank-rows-in-excel-manually\"><strong> Delete Blank Rows in Excel Manually<\/strong><\/a><\/li>\n<li><a href=\"#delete-blank-rows-using-a-vba-code\"><strong> Delete Blank Rows using a VBA Code<\/strong><\/a><\/li>\n<\/ol>\n<h2><strong id=\"how-to-delete-blank-rows-in-excel-with-options-and-tools?\">1. How to Delete Blank Rows in Excel with Options and Tools?<\/strong><\/h2>\n<p>Microsoft Excel provides us with a variety of its in-built tools and options to delete blanks or blank rows if needed. Now we will see some of those options and tools and how to utilize them to remove blank rows. We will use the below-given data for this purpose.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-6430 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-1.png\" alt=\"Delete Blank Rows in Excel\" width=\"492\" height=\"378\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-1.png 492w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-1-300x230.png 300w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><\/p>\n<h3><strong>1.1 Using Go to Special Dialogue Box <\/strong><\/h3>\n<p><strong>Step 1: <\/strong>To delete the blank rows, you can either select the entire data-table or the first column of this data table. In this case we will select column A by clicking on the header. After selecting the column, go to <strong>Home&gt;&gt;Find &amp; Select<\/strong> then click on <strong>Go To Special<\/strong> option from the list to open the dialogue box.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-6431 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-2.png\" alt=\"Delete Blank Rows in Excel\" width=\"638\" height=\"247\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-2.png 638w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-2-300x116.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/p>\n<p><strong>Step 2: <\/strong>From Go To Special dialogue box, click on <strong>Blanks<\/strong> and press OK.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-6432 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-3.png\" alt=\"Delete Blank Rows in Excel\" width=\"359\" height=\"379\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-3.png 359w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-3-284x300.png 284w\" sizes=\"(max-width: 359px) 100vw, 359px\" \/><\/p>\n<p><strong>Step 3: <\/strong>This will select the blank cells, now press <strong>CTRL<\/strong>+<strong>Minus (-) <\/strong>shortcut keys to open the <strong>Delete<\/strong> box. Select <strong>Entire Row<\/strong> option and press OK. The blank rows from this datasheet will be deleted.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6433 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-4.png\" alt=\"Delete Blank Rows in Excel\" width=\"639\" height=\"358\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-4.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-4-300x168.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<h3><strong>1.2 Using Find Option<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>Select the data-table and press <strong>CTRL+F<\/strong> shortcut keys to open the <strong>Find<\/strong> box in <strong>Find and Replace<\/strong> dialogue box. Or you can go to <strong>Home&gt;&gt;Find &amp; Select&gt;&gt;Find<\/strong> to open this dialogue box. Click on <strong>Options<\/strong> to expand the other options available in this dialogue box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6434 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-5.png\" alt=\"Delete Blank Rows in Excel\" width=\"640\" height=\"277\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-5.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-5-300x130.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Keep the <strong>Find What<\/strong> box empty. Check <strong>Match entire cell content<\/strong> box. Select <strong>Sheet<\/strong> from <strong>Within<\/strong> box, <strong>By Rows <\/strong>from <strong>Search<\/strong> box and <strong>Values<\/strong> from <strong>Look in<\/strong> box. Now press <strong>Find All<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6435 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-6.png\" alt=\"Delete Blank Rows in Excel\" width=\"632\" height=\"357\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-6.png 632w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-6-300x169.png 300w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/p>\n<p><strong>Step 3: <\/strong>References to the blank cells will be displayed at the bottom part of this dialogue box. Click on one of the references and press <strong>CTRL+A<\/strong> to select them all. This will also select these cells inside the worksheet. Now close the dialogue box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6436 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-7.png\" alt=\"Delete Blank Rows in Excel\" width=\"639\" height=\"275\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-7.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-7-300x129.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p><strong>Step 4: <\/strong>Press <strong>CTRL+ Minus (-)<\/strong> keys and select <strong>Entire row<\/strong> and press OK to delete the blank rows.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6437 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-8.png\" alt=\"Delete Blank Rows in Excel\" width=\"609\" height=\"347\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-8.png 609w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-8-300x171.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/p>\n<h3><strong>1.3 With Filter Option<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>Select the dataset and go to <strong>Data <\/strong>tab and select <strong>Filter<\/strong> option. Or you can use <strong>CTRL+SHIFT+L<\/strong> shortcut keys to add filters to them.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6438 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-9.png\" alt=\"Delete Blank Rows in Excel\" width=\"640\" height=\"377\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-9.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-9-300x177.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Click on the filter button and check only <strong>Blanks<\/strong> from the list, then press OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6439 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-10.png\" alt=\"Delete Blank Rows in Excel\" width=\"508\" height=\"436\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-10.png 508w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-10-300x257.png 300w\" sizes=\"(max-width: 508px) 100vw, 508px\" \/><\/p>\n<p><strong>Step 3: <\/strong>All the blank cells are now visible only. Select them or select the blanks from the first column only and press <strong>CTRL+ Minus (-)<\/strong> keys. This message will pop-up, press Ok and the blank rows will be removed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6440 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-11.png\" alt=\"Delete Blank Rows in Excel\" width=\"639\" height=\"202\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-11.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-11-300x95.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p><strong>Step 4: <\/strong>Click on the filter button again and check <strong>Select All<\/strong>, then press OK. If you don\u2019t want the filter buttons now, you can remove them by selecting the filtered cells again and pressing <strong>CTRL+SHIFT+L<\/strong> keys.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6441 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-12.png\" alt=\"Delete Blank Rows in Excel\" width=\"578\" height=\"492\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-12.png 578w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-12-300x255.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/p>\n<h3><strong>1.4 Using Advanced Filter Option<\/strong><\/h3>\n<p>This method is a bit complicated than the previous ones, so follow carefully.<\/p>\n<p><strong>Step 1: <\/strong>Select cell E2 and insert this formula inside the cell, then press Enter key.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6442 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-13.png\" alt=\"Delete Blank Rows in Excel\" width=\"609\" height=\"345\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-13.png 609w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-13-300x170.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Now go to <strong>Data<\/strong> tab and select <strong>Advanced <\/strong>option from <strong>Sort &amp; Filter<\/strong> section.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6443 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-14.png\" alt=\"Delete Blank Rows in Excel\" width=\"632\" height=\"369\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-14.png 632w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-14-300x175.png 300w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Select <strong>Copy to another location<\/strong> option and then insert the <strong>List range<\/strong>, <strong>Criteria range<\/strong> (E1:E2 in this instance) and <strong>Copy to<\/strong> location as shown in the picture below. Then press OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6444 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-15.png\" alt=\"Delete Blank Rows in Excel\" width=\"641\" height=\"270\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-15.png 641w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-15-300x126.png 300w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/p>\n<p><strong>Step 4: <\/strong>A filtered copy of that data will be presented in the copy to location that you have set inside <strong>Advanced Filter<\/strong> dialogue box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6445 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-16.png\" alt=\"Delete Blank Rows in Excel\" width=\"641\" height=\"228\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-16.png 641w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-16-300x107.png 300w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/p>\n<h3><strong>1.5 With Sort Option<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>Select the dataset, then go to <strong>Data<\/strong> tab and click on the ascending or descending button from the <strong>Sort<\/strong> option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6446 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-17.png\" alt=\"Delete Blank Rows in Excel\" width=\"640\" height=\"380\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-17.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-17-300x178.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 2: <\/strong>All the blank rows now will move to the bottom of the table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6447 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-18.png\" alt=\"Delete Blank Rows in Excel\" width=\"640\" height=\"377\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-18.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-18-300x177.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<h3><strong>1.6 Using Power Query<\/strong><\/h3>\n<p>The <strong>Power Query<\/strong> option in excel can also remove blank rows very effectively and the most impressive part is whenever you input any new data in the original table, it will also get updated inside the power query table with a simple refresh.<\/p>\n<p><strong>Step 1: <\/strong>Select the range of data from your worksheet and then press <strong>CTRL+T<\/strong> to open <strong>Create Table<\/strong> dialogue box. Make sure the range is correct and <strong>My table has headers<\/strong> box checked, then press OK. Or select the range and then go to <strong>Insert&gt;&gt;Table<\/strong> to convert this dataset into table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6448 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-19.png\" alt=\"Delete Blank Rows in Excel\" width=\"640\" height=\"447\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-19.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-19-300x210.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Select any cell from this data table then go to <strong>Data<\/strong> tab and select <strong>From Table\/Range. <\/strong>This will open the <strong>Power Query<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6449 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-20.png\" alt=\"Delete Blank Rows in Excel\" width=\"466\" height=\"449\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-20.png 466w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-20-300x289.png 300w\" sizes=\"(max-width: 466px) 100vw, 466px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Go to<strong> Home<\/strong> tab inside <strong>Power Query<\/strong> and click on <strong>Remove Rows&gt;&gt;Remove Blank Rows<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6450 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-21.png\" alt=\"Delete Blank Rows in Excel\" width=\"640\" height=\"362\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-21.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-21-300x170.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 4: <\/strong>The blank rows are now removed. Now click on <strong>Close &amp; Load<\/strong> and select <strong>Close &amp; Load To\u2026<\/strong> option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6451 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-22.png\" alt=\"Delete Blank Rows in Excel\" width=\"640\" height=\"305\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-22.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-22-300x143.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 5: <\/strong>Select <strong>Table<\/strong> option and if you want the table to be displayed in the same worksheet then select <strong>Existing Worksheet<\/strong> option and insert the location where you want it to display. Press OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6452 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-23.png\" alt=\"Delete Blank Rows in Excel\" width=\"570\" height=\"411\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-23.png 570w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-23-300x216.png 300w\" sizes=\"(max-width: 570px) 100vw, 570px\" \/><\/p>\n<p><strong>Step 6: <\/strong>This will return a copy of the table without blank rows in the same worksheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6453 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-24.png\" alt=\"Delete Blank Rows in Excel\" width=\"639\" height=\"258\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-24.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-24-300x121.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<h2><strong id=\"how-to-delete-blank-rows-in-excel-with-functions?\">2. How to Delete Blank Rows in Excel with Functions?<\/strong><\/h2>\n<p>There are some functions and formulas you can use to delete blank rows from your worksheet. Let\u2019s see how they work.<\/p>\n<h3><strong>2.1 Using FILTER Function<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>Select a cell where you want the data to be displayed and insert this FILTER formula inside it.<\/p>\n<p><strong>=FILTER(A2:C10,(A2:A10&lt;&gt;&#8221;&#8221;)*(B2:B10&lt;&gt;&#8221;&#8221;)*(C2:C10&lt;&gt;&#8221;&#8221;))<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6454 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-25.png\" alt=\"Delete Blank Rows in Excel\" width=\"638\" height=\"228\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-25.png 638w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-25-300x107.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Press Enter to see the result. This function is only available in <strong>Excel 365<\/strong> so it will not work in any other versions of Excel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6455 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-26.png\" alt=\"Delete Blank Rows in Excel\" width=\"640\" height=\"256\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-26.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-26-300x120.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<h3><strong>2.2 Using COUNTBLANK Function<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>First add another column in column D to use the COUNTBLANK function in.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6456 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-27.png\" alt=\"Delete Blank Rows in Excel\" width=\"639\" height=\"349\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-27.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-27-300x164.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Now select the total range and press <strong>CTRL+SHIFT+L<\/strong> to turn the <strong>Filter<\/strong> option on. Or you can turn it on from <strong>Data <\/strong>tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6457 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-28.png\" alt=\"Delete Blank Rows in Excel\" width=\"640\" height=\"341\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-28.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-28-300x160.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Select cell D3 and insert the <strong>COUNTBLANK <\/strong>formula shown in the below picture. Then drag the fill-handle down to apply the formula in other cells of this column too.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6458 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-29.png\" alt=\"Delete Blank Rows in Excel\" width=\"639\" height=\"362\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-29.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-29-300x170.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p><strong>Step 4: <\/strong>It will return the number of blank cells in each row.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6459 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-30.png\" alt=\"Delete Blank Rows in Excel\" width=\"602\" height=\"345\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-30.png 602w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-30-300x172.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/p>\n<p><strong>Step 5: <\/strong>Click on the filter button of <strong>Blank Cells<\/strong> column and select the blank cell digit, then press OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6460 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-31.png\" alt=\"Delete Blank Rows in Excel\" width=\"620\" height=\"411\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-31.png 620w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-31-300x199.png 300w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/p>\n<p><strong>Step 6: <\/strong>Now only the blank rows are visible, you can delete them using any of the methods shown before. Here <strong>CTRL+ Minus (-)<\/strong> shortcut has been used to delete the sheet rows after selecting them.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6461 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-32.png\" alt=\"Delete Blank Rows in Excel\" width=\"639\" height=\"305\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-32.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-32-300x143.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p><strong>Step 7: <\/strong>Once the blank rows are deleted, delete the <strong>Blank Cells<\/strong> column too by right clicking on column D header and selecting <strong>Delete<\/strong> option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6462 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-33.png\" alt=\"Delete Blank Rows in Excel\" width=\"633\" height=\"393\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-33.png 633w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-33-300x186.png 300w\" sizes=\"(max-width: 633px) 100vw, 633px\" \/><\/p>\n<p><strong>Step 8: <\/strong>Once you delete the extra column, the data sheet will be visible again without any blank rows. You can now remove the filter button by clicking <strong>CTRL+SHIFT+L.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6463 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-34.png\" alt=\"Delete Blank Rows in Excel\" width=\"598\" height=\"327\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-34.png 598w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-34-300x164.png 300w\" sizes=\"(max-width: 598px) 100vw, 598px\" \/><\/p>\n<h2><strong id=\"delete-blank-rows-in-excel-manually\">3. Delete Blank Rows in Excel Manually<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>To manually delete the blank rows, press and hold the <strong>CTRL<\/strong> button and select the blank cells from column A manually. Then press <strong>CTRL+ Minus (-) <\/strong>to open <strong>Delete <\/strong>box, select <strong>Entire row<\/strong> option, and press OK.<\/p>\n<p>Or after manually selecting the blank cells go to <strong>Home&gt;&gt;Delete&gt;&gt;Delete Sheet Rows.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6464 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-35.png\" alt=\"Delete Blank Rows in Excel\" width=\"594\" height=\"319\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-35.png 594w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-35-300x161.png 300w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/p>\n<p><strong>OR,<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6465 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-36.png\" alt=\"Delete Blank Rows in Excel\" width=\"545\" height=\"320\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-36.png 545w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-36-300x176.png 300w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/p>\n<h2><strong id=\"delete-blank-rows-using-a-vba-code\">4. Delete Blank Rows using a VBA Code<\/strong><\/h2>\n<p><strong>Step 1: <\/strong>Select the range, right click on worksheet name, and select <strong>View Code<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6466 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-36-1.png\" alt=\"Delete Blank Rows in Excel\" width=\"545\" height=\"320\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-36-1.png 545w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-36-1-300x176.png 300w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Insert the below given code inside <strong>VBA<\/strong> module and press the <strong>RUN <\/strong>button or <strong>F5<\/strong> key.<\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>Sub DeleteBlankRows()<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>Dim Rw As Range<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>If WorksheetFunction.CountA(Selection) = 0 Then<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>MsgBox &#8220;No blank rows found&#8221;, vbOKOnly<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>Exit Sub<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>End If<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>With Application<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>.Calculation = xlCalculationManual<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>.ScreenUpdating = False<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>Selection.SpecialCells(xlCellTypeBlanks).Select<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>For Each Rw In Selection.Rows<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>If WorksheetFunction.CountA(Selection.EntireRow) = 0 Then<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>Selection.EntireRow.Delete<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>End If<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>Next Rw<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>.Calculation = xlCalculationAutomatic<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>.ScreenUpdating = True<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>End With<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>MsgBox &#8220;Blank Rows Removed&#8221;<\/strong><\/span><\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #333399;\"><strong>End Sub<\/strong><\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6467 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-37.png\" alt=\"Delete Blank Rows in Excel\" width=\"431\" height=\"420\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-37.png 431w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-37-300x292.png 300w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/p>\n<p><strong>Step 3: <\/strong>The blank rows will be deleted from the selected range and a confirmation message will appear on your screen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6468 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-38.png\" alt=\"Delete Blank Rows in Excel\" width=\"638\" height=\"439\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-38.png 638w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-38-300x206.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/p>\n<p><strong>Step 3: <\/strong>The blank rows will be deleted from the selected range and a confirmation message will appear on your screen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6469 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-39.png\" alt=\"Delete Blank Rows in Excel\" width=\"639\" height=\"254\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-39.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/05\/Delete-Blank-Rows-39-300x119.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<h2>Application of Delete Blank Rows in Excel<\/h2>\n<ul>\n<li><strong>Data Cleaning<\/strong>: Easily remove unnecessary blank rows from your Excel spreadsheets, improving data accuracy and readability.<\/li>\n<li><strong>Streamlined Analysis<\/strong>: Ensure that your data analysis is not skewed by eliminating blank rows that may affect calculations or visualizations.<\/li>\n<li><strong>Improved Presentation<\/strong>: Present your data more professionally by removing blank rows, creating a cleaner and more organized appearance.<\/li>\n<li><strong>Enhanced Efficiency<\/strong>: Save time by automating the process of deleting blank rows, allowing you to focus on analyzing and interpreting your data.<\/li>\n<li><strong>Data Integration<\/strong>: Prepare your data for integration with other software or databases by removing blank rows that could cause compatibility issues.<\/li>\n<li><strong>Consistent Formatting<\/strong>: Maintain consistent formatting throughout your spreadsheet by removing any unnecessary blank rows that disrupt the layout.<\/li>\n<\/ul>\n<p><strong>For ready-to-use Dashboard Templates:<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Delete Blank Rows in Excel effortlessly streamlines your data cleaning process, ensuring optimal spreadsheet organization and efficiency. With Delete Blank Rows in Excel, you can say goodbye to cluttered worksheets and hello to a streamlined, professional presentation of your data. Eliminate the hassle of manual deletion and let this powerful tool do the work for &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-delete-blank-rows-in-excel\/\"> <span class=\"screen-reader-text\">How to Delete Blank Rows in Excel?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[708],"tags":[709,710],"class_list":["post-6429","post","type-post","status-publish","format-standard","hentry","category-delete-blank-rows","tag-delete-blank-rows","tag-delete-empty-rows"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/6429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=6429"}],"version-history":[{"count":4,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/6429\/revisions"}],"predecessor-version":[{"id":9210,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/6429\/revisions\/9210"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=6429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=6429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=6429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}