{"id":31569,"date":"2023-10-20T23:03:11","date_gmt":"2023-10-20T21:03:11","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=31569"},"modified":"2024-05-08T13:34:47","modified_gmt":"2024-05-08T11:34:47","slug":"delete-every-other-row","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/delete-every-other-row\/","title":{"rendered":"How to Delete Every Other Row in Excel &#8211; Top 3 Methods"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Copy-of-Copy-of-MICROSOFT-365-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-31644\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Copy-of-Copy-of-MICROSOFT-365-1-1024x576.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Copy-of-Copy-of-MICROSOFT-365-1-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Copy-of-Copy-of-MICROSOFT-365-1-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Copy-of-Copy-of-MICROSOFT-365-1-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Copy-of-Copy-of-MICROSOFT-365-1.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><a class=\"wpil_keyword_link\" title=\"Microsoft Excel\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">Microsoft Excel<\/a> is a powerful tool for data analysis and management, and sometimes you may find yourself the need to clean up your data. When you <strong>import data from different sources<\/strong>, you may want to<strong> delete every other row<\/strong> in Excel. This could be because you have <strong>unwanted or repeated rows after each relevant row<\/strong>.<\/p>\n<p>While the<strong> manual method of selecting rows and deleting them<\/strong> is an option, it can be both<strong> time-consuming and prone to errors<\/strong>, especially with large datasets. In this article, we will cover the following<strong> 3 approaches<\/strong> that can be used to delete every other row in Excel &#8211;<\/p>\n<h4>Download the Excel Workbook below to follow along and understand How to Delete Every Other Row in Excel &#8211; <a class=\"IRPP_minimalist icon-download hiddenmode replaced-link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-in-Excel.xlsm\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Delete-Every-Other-Row-in-Excel.xlsm<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/delete-every-other-row\/#Method_1_%E2%80%93_Using_Table_Format\" title=\"Method 1 &#8211; Using Table Format\">Method 1 &#8211; Using Table Format<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/delete-every-other-row\/#Method_2_%E2%80%93_Using_MOD_Format\" title=\"Method 2 &#8211; Using MOD Format\">Method 2 &#8211; Using MOD Format<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/delete-every-other-row\/#Method_3_%E2%80%93_Using_VBA\" title=\"Method 3 &#8211; Using VBA\">Method 3 &#8211; Using VBA<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/delete-every-other-row\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_%E2%80%93_Using_Table_Format\"><\/span><strong><span id=\"1\" style=\"color: #ff0000\">Method 1 &#8211; Using Table Format<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this method, you need to<strong> format data to resemble a table with banded rows<\/strong>. This will automatically <strong>apply alternating colors to each row<\/strong>, making it visually distinct. After that, you can effortlessly apply a<strong> filter to identify and select the specific rows you want to delete<\/strong>.<\/p>\n<p>Follow the steps below to know how &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Press <strong>Ctrl + T<\/strong> to create a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/excel-tables\/\" target=\"_blank\" rel=\"nofollow noopener\">table<\/a>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31585\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-1.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1193\" height=\"567\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-1.png 1193w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-1-300x143.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-1-1024x487.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-1-768x365.png 768w\" sizes=\"(max-width: 1193px) 100vw, 1193px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> In the Create Table dialog box, <strong>double-check the range<\/strong> selected and check the <strong>My table has headers<\/strong> option.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31586\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-2.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1214\" height=\"668\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-2.png 1214w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-2-300x165.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-2-1024x563.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-2-768x423.png 768w\" sizes=\"(max-width: 1214px) 100vw, 1214px\" \/><\/a><\/p>\n<p>The data will be converted into a table with banded rows.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31587\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-3.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1295\" height=\"661\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-3.png 1295w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-3-300x153.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-3-1024x523.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-3-768x392.png 768w\" sizes=\"(max-width: 1295px) 100vw, 1295px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span><\/strong> Go to<strong> the Table Design<\/strong> tab &gt;<strong> Convert to Range<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31588\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-4.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1789\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-4.png 1789w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-4-300x27.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-4-1024x93.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-4-768x70.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-4-1536x140.png 1536w\" sizes=\"(max-width: 1789px) 100vw, 1789px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4: <\/span><\/strong>In the dialog box, select <strong>Yes<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31589\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-5.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"396\" height=\"142\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-5.png 396w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-5-300x108.png 300w\" sizes=\"(max-width: 396px) 100vw, 396px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5: <\/span><\/strong>Click on the <strong>Filter button,<\/strong> go to <strong>Filter by color,<\/strong> and <strong>select Light Blue<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31591\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-7.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1257\" height=\"669\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-7.png 1257w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-7-300x160.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-7-1024x545.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-7-768x409.png 768w\" sizes=\"(max-width: 1257px) 100vw, 1257px\" \/><\/a><\/p>\n<p>All the rows with no fill will be filtered.<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5: <\/span><\/strong>Right-click and select <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-or-delete-rows-and-columns-in-excel\/\" target=\"_blank\" rel=\"nofollow noopener\">Delete Row<\/a>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31592\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1228\" height=\"668\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8.png 1228w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8-300x163.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8-1024x557.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8-768x418.png 768w\" sizes=\"(max-width: 1228px) 100vw, 1228px\" \/><\/a><\/p>\n<p>The rows with light blue fill will be deleted. Only the rows with no fill will remain in the data table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31593\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-9.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1260\" height=\"665\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-9.png 1260w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-9-300x158.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-9-1024x540.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-9-768x405.png 768w\" sizes=\"(max-width: 1260px) 100vw, 1260px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_%E2%80%93_Using_MOD_Format\"><\/span><strong><span id=\"2\" style=\"color: #ff0000\">Method 2 &#8211; Using MOD Format<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this method, you need to use the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getting-the-remainder-with-excels-mod-formula\/\" target=\"_blank\" rel=\"nofollow noopener\">MOD<\/a> function to determine if a row number is even or odd. If a row is even-numbered, Excel will display a result of 1 and it will display 0 when the row is odd-numbered.<\/p>\n<p>You will also have to use the ROW function to get the current row for each cell. Now let&#8217;s look at the step-by-step tutorial to know more.<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Insert a<strong> helper column<\/strong> next to your data.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31594\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-10.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1391\" height=\"648\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-10.png 1391w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-10-300x140.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-10-1024x477.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-10-768x358.png 768w\" sizes=\"(max-width: 1391px) 100vw, 1391px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Enter the <strong>MOD<\/strong> function.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31595\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-11.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1365\" height=\"714\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-11.png 1365w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-11-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-11-1024x536.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-11-768x402.png 768w\" sizes=\"(max-width: 1365px) 100vw, 1365px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span><\/strong> Enter the <strong>ROW<\/strong> function.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31596\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-12.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1374\" height=\"731\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-12.png 1374w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-12-300x160.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-12-1024x545.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-12-768x409.png 768w\" sizes=\"(max-width: 1374px) 100vw, 1374px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span><\/strong> Enter the <strong>argument for the row function i.e. reference<\/strong>. Here, you can select <strong>any cell in the same row<\/strong> where you are typing the <a class=\"wpil_keyword_link\" title=\"formula\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">formula<\/a>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31597\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-13.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1407\" height=\"683\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-13.png 1407w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-13-300x146.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-13-1024x497.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-13-768x373.png 768w\" sizes=\"(max-width: 1407px) 100vw, 1407px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5:<\/span><\/strong> Enter the<strong> argument of the MOD function i.e. divider<\/strong>. Here, it is <strong>2<\/strong> as you will have to know whether the row is odd-numbered or even.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31598\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-14.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1402\" height=\"687\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-14.png 1402w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-14-300x147.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-14-1024x502.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-14-768x376.png 768w\" sizes=\"(max-width: 1402px) 100vw, 1402px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6:<\/span><\/strong> Copy the formula down.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31599\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-15.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1436\" height=\"687\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-15.png 1436w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-15-300x144.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-15-1024x490.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-15-768x367.png 768w\" sizes=\"(max-width: 1436px) 100vw, 1436px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 7:<\/span><\/strong> Click on the<strong> Filter button<\/strong> and select <strong>0<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31600\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-16.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1396\" height=\"646\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-16.png 1396w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-16-300x139.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-16-1024x474.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-16-768x355.png 768w\" sizes=\"(max-width: 1396px) 100vw, 1396px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 8: <\/span><\/strong>Right-click and select<strong> Delete Row<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31592\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1228\" height=\"668\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8.png 1228w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8-300x163.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8-1024x557.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-8-768x418.png 768w\" sizes=\"(max-width: 1228px) 100vw, 1228px\" \/><\/a><\/p>\n<p>All the even-numbered rows will be deleted.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-17.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31601\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-17.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1437\" height=\"662\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-17.png 1437w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-17-300x138.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-17-1024x472.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-17-768x354.png 768w\" sizes=\"(max-width: 1437px) 100vw, 1437px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_3_%E2%80%93_Using_VBA\"><\/span><strong><span id=\"3\" style=\"color: #ff0000\">Method 3 &#8211; Using VBA<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this method, you need to use a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/free-excel-macros-and-vba-training-2021\/\" target=\"_blank\" rel=\"nofollow noopener\"><strong>VBA<\/strong><\/a> code that can be employed to automate the process. Here are the steps to incorporate the same &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1: <\/span><\/strong>Go to the <strong>Developer<\/strong> Tab and select <strong>Visual Basic<\/strong> to open the VBA editor.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31602\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-18.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1199\" height=\"162\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-18.png 1199w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-18-300x41.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-18-1024x138.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-18-768x104.png 768w\" sizes=\"(max-width: 1199px) 100vw, 1199px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2: <\/span><\/strong>Go to <strong>Insert<\/strong> &gt; <strong>Module<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-19.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31603\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-19.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"426\" height=\"383\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-19.png 426w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-19-300x270.png 300w\" sizes=\"(max-width: 426px) 100vw, 426px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3: <\/span><\/strong>Copy and paste the following VBA code:<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">\r\nSub DeleteEveryOtherRow()\r\nDim i As Long\r\nFor i = ActiveSheet.UsedRange.Rows.Count To 1 Step -2\r\nActiveSheet.Rows(i).Delete\r\nNext i\r\nEnd Sub\r\n<\/pre>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-20.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31604\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-20.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1436\" height=\"481\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-20.png 1436w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-20-300x100.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-20-1024x343.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-Other-Row-20-768x257.png 768w\" sizes=\"(max-width: 1436px) 100vw, 1436px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4: <\/span> <\/strong>Press\u00a0<strong>Ctrl + S<\/strong>\u00a0to save the module.<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5: <\/span><\/strong>In the dialog box, select <strong>No<\/strong>\u00a0to save the file as a macro-enabled workbook.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-210.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31661\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-210.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"701\" height=\"224\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-210.png 701w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-210-300x96.png 300w\" sizes=\"(max-width: 701px) 100vw, 701px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6: <\/span><\/strong>In the Save As dialog box, select <strong>Excel Macro-Enabled Workbook<\/strong>. Press <strong>Save<\/strong>.<\/p>\n<div id=\"AdThrive_Content_2_desktop\" class=\"adthrive-ad adthrive-content adthrive-content-2 adthrive-ad-cls\" data-google-query-id=\"CLOTzNTq84EDFQ6lZgIdEHUEAw\">\n<div id=\"google_ads_iframe_\/18190176\/AdThrive_Content_2\/6470e2eda0585044d0ec8741_0__container__\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-22.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31608\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-22.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"937\" height=\"621\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-22.png 937w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-22-300x199.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-22-768x509.png 768w\" sizes=\"(max-width: 937px) 100vw, 937px\" \/><\/a><\/div>\n<\/div>\n<p><strong><span style=\"color: #ff0000\">STEP 7: <\/span><\/strong>Go to <strong>Developer<\/strong> Tab &gt; <strong>Macro<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-23.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31607\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-23.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1081\" height=\"159\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-23.png 1081w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-23-300x44.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-23-1024x151.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-23-768x113.png 768w\" sizes=\"(max-width: 1081px) 100vw, 1081px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 8<\/span><\/strong><strong><span style=\"color: #ff0000\">: <\/span><\/strong>In the Macro dialog box, select <strong>Delete Every Other Row,<\/strong>\u00a0and press\u00a0<strong>Run<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-24.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31609\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-24.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"545\" height=\"466\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-24.png 545w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-24-300x257.png 300w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/a><\/p>\n<p>Once you run this macro, all the odd-numbered rows will be deleted.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-25.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-31611\" title=\"How to Delete Every Other Row in Excel - Top 3 Methods\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-25.png\" alt=\"How to Delete Every Other Row in Excel - Top 3 Methods\" width=\"1232\" height=\"614\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-25.png 1232w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-25-300x150.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-25-1024x510.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/10\/Delete-Every-other-row-25-768x383.png 768w\" sizes=\"(max-width: 1232px) 100vw, 1232px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong><span style=\"color: #ff0000\">Conclusion<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In conclusion, whether you prefer a simple table format, a formula-based approach, or VBA automation, Excel offers multiple ways <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/print-top-row-in-excel\/\" target=\"_blank\" rel=\"noopener\">to delete every other<\/a> row. Choose the method that best suits your workflow and data requirements.<\/p>\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/troubleshoot\/excel\/delete-every-other-row\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> to learn more about How to delete every other row on an Excel worksheet!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is a powerful tool for data analysis and management, and sometimes you may find yourself the need to clean up your data. When you import data from different sources, you may want to delete every other row in Excel. This could be because you have unwanted or repeated rows after each relevant row. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":31644,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Delete Every Other Row in Excel - Top 3 Methods","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,56,36,287],"tags":[1412,1411],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/31569"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=31569"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/31569\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/31644"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=31569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=31569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=31569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}