{"id":33877,"date":"2024-01-17T01:16:18","date_gmt":"2024-01-17T00:16:18","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=33877"},"modified":"2024-05-08T13:34:49","modified_gmt":"2024-05-08T11:34:49","slug":"highlight-every-other-row-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-every-other-row-in-excel\/","title":{"rendered":"How to Highlight Every Other Row in Excel &#8211; 3 Detailed Methods"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-30-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33957 size-large\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-30-1-1024x576.png\" alt=\"Highlight Every Other Row\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-30-1-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-30-1-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-30-1-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-30-1.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\"><strong>Microsoft Excel<\/strong><\/a> offers a variety of tools and features to enhance the visual appeal of your data. One common <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/formatting-excel-spreadsheets\/\" target=\"_blank\" rel=\"noopener\"><strong>formatting technique<\/strong><\/a> is to highlight every other row in Excel. This will increase the readability of the dataset and help you in analyzing large datasets.<\/p>\n<p>In this article, we will cover the following methods to achieve this &#8211;<\/p>\n<div class=\"contents\">\n<h2>Table of Contents<\/h2>\n<ul>\n<li><a href=\"#1\"><strong>Method 1 &#8211; Use Ctrl button<\/strong><\/a><\/li>\n<li><a href=\"#2\"><strong>Method 2 &#8211; Format as Table<\/strong><\/a><\/li>\n<li><a href=\"#3\"><strong>Method 3 &#8211; Conditional Formatting<\/strong><\/a><\/li>\n<\/ul>\n<\/div>\n<p>Let us look at each of these methods in detail.<\/p>\n<p>Download the Excel Workbook below to follow along and understand How to Highlight Every Other Row in Excel \u2013<br \/>\n<a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row.xlsx\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">Highlight-Every-Other-Row.xlsx<\/span><\/a><\/p>\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\/highlight-every-other-row-in-excel\/#Method_1_%E2%80%93_Use_CTRL_button\" title=\"Method 1 \u2013 Use CTRL button\">Method 1 \u2013 Use CTRL button<\/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\/highlight-every-other-row-in-excel\/#Method_2_%E2%80%93_Format_as_Table\" title=\"Method 2 \u2013 Format as Table\">Method 2 \u2013 Format as Table<\/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\/highlight-every-other-row-in-excel\/#Method_3_%E2%80%93_Conditional_Formatting\" title=\"Method 3 \u2013 Conditional Formatting\">Method 3 \u2013 Conditional Formatting<\/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\/highlight-every-other-row-in-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_%E2%80%93_Use_CTRL_button\"><\/span><strong><span id=\"1\" style=\"color: #ff0000\">Method 1 \u2013 Use CTRL button<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If your worksheet <strong>does not have many rows<\/strong>, you can<strong> hold the CTRL button to highlight the rows <\/strong>that you want. Follow the <strong>steps<\/strong> below to learn how to highlight every other row in Excel using the CTRL button &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1: <\/span><\/strong> You can select the row number to highlight an entire row.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33881 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-7.png\" alt=\"Highlight Every Other Row\" width=\"469\" height=\"288\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-7.png 469w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-7-300x184.png 300w\" sizes=\"(max-width: 469px) 100vw, 469px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Press <strong>CTRL<\/strong> to select additional rows.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33882 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-8.png\" alt=\"Highlight Every Other Row\" width=\"474\" height=\"331\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-8.png 474w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-8-300x209.png 300w\" sizes=\"(max-width: 474px) 100vw, 474px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span><\/strong> Go to <strong>Home<\/strong> &gt; <strong>Fill Color<\/strong> &gt; Select an appropriate <strong>color<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33883 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-9.png\" alt=\"Highlight Every Other Row\" width=\"558\" height=\"564\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-9.png 558w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-9-297x300.png 297w\" sizes=\"(max-width: 558px) 100vw, 558px\" \/><\/a><\/p>\n<p>The alternate highlighted rows will be filled with light green color.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33884 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-10.png\" alt=\"Highlight Every Other Row\" width=\"462\" height=\"316\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-10.png 462w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-10-300x205.png 300w\" sizes=\"(max-width: 462px) 100vw, 462px\" \/><\/a><\/p>\n<p>Even though this is one of the easiest methods to highlight every other row, using it with a large dataset is not practical.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_%E2%80%93_Format_as_Table\"><\/span><strong><span id=\"2\" style=\"color: #ff0000\">Method 2 \u2013 Format as Table<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another easy way to highlight every other row is to <strong>format the data as a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-an-excel-table\/\" target=\"_blank\" rel=\"noopener\">table<\/a><\/strong>. This will allow you to<strong> quickly format a range of cells<\/strong> as a table with a predefined style, including<strong> banded rows or columns<\/strong>.<\/p>\n<p>Follow the steps below to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-alternate-row-in-excel\/\" target=\"_blank\" rel=\"noopener\">highlight alternate rows in Excel<\/a> by using the Table Format &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1: <\/span><\/strong>Press<strong> CTRL + A<\/strong> to <strong>highlight<\/strong> the entire data.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33885 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-11.png\" alt=\"Highlight Every Other Row\" width=\"452\" height=\"690\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-11.png 452w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-11-197x300.png 197w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2: <\/span><\/strong>Go to Insert &gt; Table.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33886 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-12.png\" alt=\"Highlight Every Other Row\" width=\"1086\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-12.png 1086w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-12-300x45.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-12-1024x154.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-12-768x115.png 768w\" sizes=\"(max-width: 1086px) 100vw, 1086px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3: <\/span><\/strong>In the Create Table dialog box, check the <strong>My table has headers<\/strong> box and click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33887 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-13.png\" alt=\"Highlight Every Other Row\" width=\"271\" height=\"177\" \/><\/a><\/p>\n<p>The default blue and white banded rows will be applied to the table range.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33888 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-14.png\" alt=\"Highlight Every Other Row\" width=\"488\" height=\"629\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-14.png 488w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-14-233x300.png 233w\" sizes=\"(max-width: 488px) 100vw, 488px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3: <\/span><\/strong>To <strong>highlight every other column<\/strong> instead of rows, go to the Tabel Design tab<strong> uncheck the Banded Rows<\/strong> option, and <strong>check the Banded Columns<\/strong> option.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33890 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-16.png\" alt=\"Highlight Every Other Row\" width=\"1141\" height=\"885\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-16.png 1141w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-16-300x233.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-16-1024x794.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-16-768x596.png 768w\" sizes=\"(max-width: 1141px) 100vw, 1141px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4: <\/span><\/strong>If you don&#8217;t like the default color, you can easily change it by clicking on the <strong>arrow button<\/strong> next to the <strong>Table Style<\/strong> option.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33889 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-15.png\" alt=\"Highlight Every Other Row\" width=\"1802\" height=\"165\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-15.png 1802w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-15-300x27.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-15-1024x94.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-15-768x70.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-15-1536x141.png 1536w\" sizes=\"(max-width: 1802px) 100vw, 1802px\" \/><\/a><\/p>\n<p>You can select the color option available from the list.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-20.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33894\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-20.png\" alt=\"Highlight Every Other Row\" width=\"459\" height=\"601\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-20.png 635w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-20-229x300.png 229w\" sizes=\"(max-width: 459px) 100vw, 459px\" \/><\/a><\/p>\n<p>The selected table design will be applied to the data range.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33901 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-3.png\" alt=\"Highlight Every Other Row\" width=\"501\" height=\"713\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-3.png 501w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-3-211x300.png 211w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5: <\/span><\/strong>To apply <strong>custom<\/strong> formatting, select <strong>New Table Style<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-21.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33895 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-21.png\" alt=\"Highlight Every Other Row\" width=\"635\" height=\"832\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-21.png 635w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-21-229x300.png 229w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6: <\/span><\/strong>In the New Table Style dialog box, select the <strong>Table Element<\/strong> that you want to format and press the <strong>Format<\/strong> button.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-27.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33906 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-27.png\" alt=\"Highlight Every Other Row\" width=\"735\" height=\"486\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-27.png 735w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-27-300x198.png 300w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 7: <\/span><\/strong>In the Format Cells dialog box, go to <b>Border <\/b>and select the color and pattern that you want. Press<strong> OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-24.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33903 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-24.png\" alt=\"Highlight Every Other Row\" width=\"669\" height=\"670\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-24.png 669w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-24-300x300.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-24-150x150.png 150w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 8: <\/span><\/strong>Double-check the formatting in the <strong>Preview<\/strong> section and press <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-25.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33904 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-25.png\" alt=\"Highlight Every Other Row\" width=\"738\" height=\"487\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-25.png 738w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-25-300x198.png 300w\" sizes=\"(max-width: 738px) 100vw, 738px\" \/><\/a><\/p>\n<p>The new formatting will <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-rows-that-starts-with-d\/\" target=\"_blank\" rel=\"noopener\">highlight every other row<\/a> with the selected border.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-26.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33905 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-26.png\" alt=\"Highlight Every Other Row\" width=\"435\" height=\"663\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-26.png 435w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-26-197x300.png 197w\" sizes=\"(max-width: 435px) 100vw, 435px\" \/><\/a><\/p>\n<p>This is how you can easily highlight rows in Excel.<\/p>\n<p>You should know that the formatting that has been applied will adjust automatically even if you sort, remove, or insert new rows. If you<strong> filter by the first name starting with &#8220;J,&#8221;<\/strong> you will notice that the result still displays banded rows.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-22.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33899 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-22.png\" alt=\"Highlight Every Other Row\" width=\"491\" height=\"249\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-22.png 491w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-22-300x152.png 300w\" sizes=\"(max-width: 491px) 100vw, 491px\" \/><\/a><\/p>\n<p>To convert the Table to data range, you can <strong>right-click<\/strong> on the table and select <strong>Table<\/strong> &gt; <strong>Convert to Range<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-23.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33900 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-23.png\" alt=\"Highlight Every Other Row\" width=\"883\" height=\"951\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-23.png 883w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-23-279x300.png 279w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-23-768x827.png 768w\" sizes=\"(max-width: 883px) 100vw, 883px\" \/><\/a><\/p>\n<p>Even though the table has been converted to range, the formatting remains intact. But, two disadvantages will be faced &#8211;<\/p>\n<ul>\n<li>The formatting will no longer to applied to new rows that you add.<\/li>\n<li>If you sort or filter data, the formatting will not adjusted and the cells will have the old color only.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Using this method, you can easily highlight alternate rows and columns in Excel. But what if you want to <strong>highlight every 3rd or 4th row<\/strong>? This is achievable by following the next method &#8211; <strong>Conditional Formatting.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_3_%E2%80%93_Conditional_Formatting\"><\/span><strong><span id=\"3\" style=\"color: #ff0000\">Method 3 \u2013 Conditional Formatting<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/conditional-format-a-cells-value\/\" target=\"_blank\" rel=\"noopener\"><strong>Conditional formatting<\/strong><\/a> is a feature in Microsoft Excel that allows you to <strong>format cells based on specific conditions or criteria<\/strong>. Using this feature, you can <strong>highlight every <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/print-top-row-in-excel\/\" target=\"_blank\" rel=\"noopener\">other row<\/a> or column<\/strong> with colors in Excel.<\/p>\n<p>The <strong><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><\/strong> to be used to highlight<strong> every even row<\/strong> using conditional formatting &#8211;<\/p>\n<p><strong>=MOD(ROW(),2)=0<\/strong><\/p>\n<p>where,<\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/row-vs-column-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>ROW<\/strong><\/a> &#8211; This function returns the row number of the cell in which the formula is entered.<\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getting-the-remainder-with-excels-mod-formula\/\" target=\"_blank\" rel=\"noopener\"><strong>MOD<\/strong><\/a> &#8211; This function calculates the remainder when one number is divided by another. In this case, it calculates the remainder when the row number is divided by 2.<\/li>\n<li><strong>=0<\/strong> &#8211; This part of the formula checks if the result of the MOD function is equal to zero. If the remainder is zero, it means the row number is divisible evenly by 2, indicating an even row.<\/li>\n<\/ul>\n<p>This formula is used in conditional formatting to apply a particular format to <strong>every other row<\/strong> in a range, creating a <strong>banded or striped effect<\/strong> for better visualization of data in tables or lists.<\/p>\n<p>Follow the steps below to highlight every other row in Excel &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1: <\/span><\/strong>Press<strong> CTRL + A<\/strong> to <strong>highlight<\/strong> the entire data.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33885 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-11.png\" alt=\"Highlight Every Other Row\" width=\"452\" height=\"690\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-11.png 452w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-11-197x300.png 197w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2: <\/span><\/strong>Go to <strong>Home<\/strong> &gt; <strong>Conditional Formatting<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-28.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33907 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-28.png\" alt=\"Highlight Every Other Row\" width=\"1419\" height=\"167\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-28.png 1419w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-28-300x35.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-28-1024x121.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-28-768x90.png 768w\" sizes=\"(max-width: 1419px) 100vw, 1419px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3: <\/span><\/strong>From the submenu, choose <strong>New Rule<\/strong> to open the New Formatting Rule dialog box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-29.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33908 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-29.png\" alt=\"Highlight Every Other Row\" width=\"1415\" height=\"604\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-29.png 1415w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-29-300x128.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-29-1024x437.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-29-768x328.png 768w\" sizes=\"(max-width: 1415px) 100vw, 1415px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4: <\/span><\/strong>In the New Formatting Rule dialog box,<\/p>\n<ul>\n<li>Select <strong>Use a formula to determine which cells to format<\/strong>.<\/li>\n<li>Type the formula &#8211;<strong> MOD(ROW(),2)=0<\/strong><\/li>\n<li>Select <strong>Format<\/strong>.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-30.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33909 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-30.png\" alt=\"Highlight Every Other Row\" width=\"640\" height=\"459\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-30.png 640w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-30-300x215.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5: <\/span><\/strong>Under the <strong>Fill<\/strong> section, select the light green color and press <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-31.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33910 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-31.png\" alt=\"Highlight Every Other Row\" width=\"674\" height=\"675\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-31.png 674w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-31-300x300.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-31-150x150.png 150w\" sizes=\"(max-width: 674px) 100vw, 674px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5: <\/span><\/strong>Double-check the format in the <strong>Sample<\/strong> section and press <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-32.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33911 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-32.png\" alt=\"Highlight Every Other Row\" width=\"639\" height=\"460\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-32.png 639w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-32-300x216.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/a><\/p>\n<p>The selected formatting will be applied to the table range.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-33.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33912 size-full\" title=\"Highlight Every Other Row\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-33.png\" alt=\"Highlight Every Other Row\" width=\"471\" height=\"678\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-33.png 471w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Highlight-Every-Other-Row-33-208x300.png 208w\" sizes=\"(max-width: 471px) 100vw, 471px\" \/><\/a><\/p>\n<ul>\n<li>To highlight odd rows, you can use the formula: MOD(ROW(),2)=1<\/li>\n<li>To highlight alternate columns, you can use the formula: MOD(COLUMN(),2)=0<\/li>\n<li>To highlight every nth row in Excel, use the formula: MOD(ROW(),n)=0.<\/li>\n<\/ul>\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><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Microsoft Excel<\/strong><\/a> provides various methods to enhance data presentation, and one common <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/formatting-excel-spreadsheets\/\" target=\"_blank\" rel=\"noopener\"><strong>formatting technique<\/strong><\/a> is to<a href=\"https:\/\/support.microsoft.com\/en-au\/office\/apply-color-to-alternate-rows-or-columns-30002ce0-7a1c-4d70-a70c-4b6232f09f5e\" target=\"_blank\" rel=\"nofollow noopener\"><strong> highlight every other row<\/strong><\/a> for improved readability. The article covered three methods for achieving this &#8211; holding the CTRL button to manually highlight rows, formatting data as a table for banded rows or columns, and using conditional formatting to highlight every nth row or column.<\/p>\n<p><span style=\"font-weight: 400\">\u00a0Learn our <\/span><span style=\"font-weight: 400\"><strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-interview-questions\/\" target=\"_blank\" rel=\"noopener\">Top 7 Excel Interview Questions to Land Your Dream Job<\/a><\/strong>!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel offers a variety of tools and features to enhance the visual appeal of your data. One common formatting technique is to highlight every other row in Excel. This will increase the readability of the dataset and help you in analyzing large datasets. In this article, we will cover the following methods to achieve [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33957,"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 Highlight Every Other Row in Excel - 3 Detailed Methods","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[35,36],"tags":[1530,1529],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33877"}],"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=33877"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33877\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33957"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=33877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=33877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=33877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}