https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/

スキャンID：: 4907c232-ed41-470e-82f6-8303138909ed終了
送信済みURL：: https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/
レポート終了日：: 2024年10月23日 14:15:37
リンク · 13件検出

ページから特定された発信リンク
リンク	テキスト
https://store.excel-university.com/
https://campus.excel-university.com/login/
https://store.excel-university.com/cart?action=viewcart
https://store.excel-university.com	Training Programs
https://help.excel-university.com	Docs
https://www.linkedin.com/in/jefflenning/	LinkedIn
https://www.youtube.com/c/exceluniversityinc	YouTube
https://www.facebook.com/exceluniversityinc	Facebook
https://www.instagram.com/exceluniversity/	Instagram
https://twitter.com/exceluniversity	X
JavaScript変数 · 106件検出

ページのウィンドウオブジェクトにロードされたグローバルのJavaScript変数は関数以外の場所で宣言された変数で、現在のスコープ内であればコードのどこからでもアクセス可能です
名前	規模
0	object
1	object
2	object
3	object
onbeforetoggle	object
documentPictureInPicture	object
onscrollend	object
gform	object
$	undefined
jQuery	function
コンソールログメッセージ · 3件検出

Webコンソールにログ記録されたメッセージ
規模	分類	ログ
warning	other	URL https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/ テキスト The resource https://securepubads.g.doubleclick.net/tag/js/gpt.js was preloaded using link preload but not used within a few seconds from the window's load event. Please make sure it has an appropriate `as` value and it is preloaded intentionally.
warning	other	URL https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/ テキスト The resource https://securepubads.g.doubleclick.net/tag/js/gpt.js was preloaded using link preload but not used within a few seconds from the window's load event. Please make sure it has an appropriate `as` value and it is preloaded intentionally.
warning	other	URL https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/ テキスト The resource https://securepubads.g.doubleclick.net/tag/js/gpt.js was preloaded using link preload but not used within a few seconds from the window's load event. Please make sure it has an appropriate `as` value and it is preloaded intentionally.
HTML

未加工のHTMLページ本文
<!DOCTYPE html><html lang="en" class="chrome chrome119" style="overflow: visible !important;"><head> <script type="text/javascript" src="https://beacon-v2.helpscout.net/static/js/vendor.5fe8f3bc.js"></script><script type="text/javascript" src="https://beacon-v2.helpscout.net/static/js/main.a4c5e672.js"></script><script type="text/javascript" async="" src="https://beacon-v2.helpscout.net"></script><script src="https://scripts.grow.me/main.js" type="text/javascript"></script><script src="https://keywords.mediavine.com/keyword/web.keywords.js?pageUrl=https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/" type="text/javascript"></script><script src="https://exchange.mediavine.com/usersync.min.js?s2sVersion=production" type="text/javascript"></script><script src="https://scripts.mediavine.com/tags/3.7.6-2330-OptTruedata/wrapper.min.js?bust=-62243801" type="text/javascript"></script><script type="text/javascript" async="" data-scriptid="dfunifiedcode" src="https://a.deadlinefunnel.com/unified/reactunified.bundle.js?userIdHash=eyJpdiI6IkFIcXRjNFJxZ2FIY040N1ZhN0FhM1E9PSIsInZhbHVlIjoibVBRTmRKODdnalF5R0Jzci9xUU9UZz09IiwibWFjIjoiZDczYmUyMTE3ZTY2ZThjZGM5MzVlZDJlZmE2Njk2MzA1YTk3NmQyNzU3YTYyODBjN2MzMWRjYTE3ODczMGQ2OSJ9&amp;pageFromUrl=aHR0cHM6Ly93d3cuZXhjZWwtdW5pdmVyc2l0eS5jb20vZm91ci13YXlzLXRvLXNlbGVjdC1ldmVyeS1vdGhlci1yb3ctaW4tZXhjZWwv&amp;parentPageFromUrl="></script><script src="https://diffuser-cdn.app-us1.com/diffuser/diffuser.js" async=""></script><script type="text/javascript" async="" src="https://static.ads-twitter.com/uwt.js"></script><script type="text/javascript" async="" src="https://www.google-analytics.com/analytics.js"></script><script type="text/javascript" async="" src="https://www.googletagmanager.com/gtag/js?id=G-2WJNQB0XNL&amp;l=dataLayer&amp;cx=c"></script><script src="https://privacy-center.fides.mediavine.com/fides.js?property_id=FDS-F0G1B3&amp;gpp=true&amp;initialize=false" type="text/javascript"></script><script async="" src="https://www.googletagmanager.com/gtm.js?id=GTM-M8T7N66"></script><script>
var gform;gform||(document.addEventListener("gform_main_scripts_loaded",function(){gform.scriptsLoaded=!0}),window.addEventListener("DOMContentLoaded",function(){gform.domLoaded=!0}),gform={domLoaded:!1,scriptsLoaded:!1,initializeOnLoaded:function(o){gform.domLoaded&&gform.scriptsLoaded?o():!gform.domLoaded&&gform.scriptsLoaded?window.addEventListener("DOMContentLoaded",o):document.addEventListener("gform_main_scripts_loaded",o)},hooks:{action:{},filter:{}},addAction:function(o,n,r,t){gform.addHook("action",o,n,r,t)},addFilter:function(o,n,r,t){gform.addHook("filter",o,n,r,t)},doAction:function(o){gform.doHook("action",o,arguments)},applyFilters:function(o){return gform.doHook("filter",o,arguments)},removeAction:function(o,n){gform.removeHook("action",o,n)},removeFilter:function(o,n,r){gform.removeHook("filter",o,n,r)},addHook:function(o,n,r,t,i){null==gform.hooks[o][n]&&(gform.hooks[o][n]=[]);var e=gform.hooks[o][n];null==i&&(i=n+"_"+e.length),gform.hooks[o][n].push({tag:i,callable:r,priority:t=null==t?10:t})},doHook:function(n,o,r){var t;if(r=Array.prototype.slice.call(r,1),null!=gform.hooks[n][o]&&((o=gform.hooks[n][o]).sort(function(o,n){return o.priority-n.priority}),o.forEach(function(o){"function"!=typeof(t=o.callable)&&(t=window[t]),"action"==n?t.apply(null,r):r[0]=t.apply(null,r)})),"filter"==n)return r[0]},removeHook:function(o,n,t,i){var r;null!=gform.hooks[o][n]&&(r=(r=gform.hooks[o][n]).filter(function(o,n,r){return!!(null!=i&&i!=o.tag||null!=t&&t!=o.priority)}),gform.hooks[o][n]=r)}});
</script>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<link rel="profile" href="https://gmpg.org/xfn/11">
<meta name="robots" content="index, follow, max-image-preview:large, max-snippet:-1, max-video-preview:-1">

<title>Four Ways to Select Every Other Row in Excel - Excel University</title><link rel="preload" data-rocket-preload="" as="style" href="https://fonts.googleapis.com/css?family=Open%20Sans%3A300%2C400%2C700%2C400%7CMerriweather%20Sans%3A700&amp;display=swap"><link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Open%20Sans%3A300%2C400%2C700%2C400%7CMerriweather%20Sans%3A700&amp;display=swap" media="all" onload="this.media='all'"><noscript><link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Open%20Sans%3A300%2C400%2C700%2C400%7CMerriweather%20Sans%3A700&#038;display=swap" /></noscript><link rel="preload" data-rocket-preload="" as="image" href="https://www.excel-university.com/wp-content/uploads/Path-1.svg" fetchpriority="high">
<meta name="description" content="Need to delete duplicates or apply specific formatting? Here are four different ways to select every other row in Excel.">
<link rel="canonical" href="https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/">
<meta property="og:locale" content="en_US">
<meta property="og:type" content="article">
<meta property="og:title" content="Four Ways to Select Every Other Row in Excel - Excel University">
<meta property="og:description" content="Need to delete duplicates or apply specific formatting? Here are four different ways to select every other row in Excel.">
<meta property="og:url" content="https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/">
<meta property="og:site_name" content="Excel University">
<meta property="article:published_time" content="2023-01-03T15:00:00+00:00">
<meta property="article:modified_time" content="2022-12-20T18:23:28+00:00">
<meta property="og:image" content="https://www.excel-university.com/wp-content/uploads/Four-Ways-to-Select-Every-Other-Row-in-Excel-Featured-2.jpg">
<meta property="og:image:width" content="300">
<meta property="og:image:height" content="300">
<meta property="og:image:type" content="image/jpeg">
<meta name="author" content="Excel University">
<meta name="twitter:card" content="summary_large_image">
<meta name="twitter:label1" content="Written by">
<meta name="twitter:data1" content="Excel University">
<meta name="twitter:label2" content="Est. reading time">
<meta name="twitter:data2" content="6 minutes">
<script type="application/ld+json" class="yoast-schema-graph">{"@context":"https://schema.org","@graph":[{"@type":"WebPage","@id":"https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/","url":"https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/","name":"Four Ways to Select Every Other Row in Excel - Excel University","isPartOf":{"@id":"https://www.excel-university.com/#website"},"primaryImageOfPage":{"@id":"https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/#primaryimage"},"image":{"@id":"https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/#primaryimage"},"thumbnailUrl":"https://www.excel-university.com/wp-content/uploads/Four-Ways-to-Select-Every-Other-Row-in-Excel-Featured-2.jpg","datePublished":"2023-01-03T15:00:00+00:00","dateModified":"2022-12-20T18:23:28+00:00","author":{"@id":"https://www.excel-university.com/#/schema/person/6ee2ed458a7c8cb139cae28e203c7f9e"},"description":"Need to delete duplicates or apply specific formatting? Here are four different ways to select every other row in Excel.","breadcrumb":{"@id":"https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/#primaryimage","url":"https://www.excel-university.com/wp-content/uploads/Four-Ways-to-Select-Every-Other-Row-in-Excel-Featured-2.jpg","contentUrl":"https://www.excel-university.com/wp-content/uploads/Four-Ways-to-Select-Every-Other-Row-in-Excel-Featured-2.jpg","width":300,"height":300,"caption":"Women holding her glasses up close to a computer screen and reading about how to select every other row in Excel"},{"@type":"BreadcrumbList","@id":"https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://www.excel-university.com/"},{"@type":"ListItem","position":2,"name":"Blog","item":"https://www.excel-university.com/blog/"},{"@type":"ListItem","position":3,"name":"Four Ways to Select Every Other Row in Excel"}]},{"@type":"WebSite","@id":"https://www.excel-university.com/#website","url":"https://www.excel-university.com/","name":"Excel University","description":"Online Microsoft Excel Training","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://www.excel-university.com/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Person","@id":"https://www.excel-university.com/#/schema/person/6ee2ed458a7c8cb139cae28e203c7f9e","name":"Excel University","image":{"@type":"ImageObject","inLanguage":"en","@id":"https://www.excel-university.com/#/schema/person/image/","url":"https://www.excel-university.com/wp-content/uploads/cropped-Excel_u-logo_for_Favicon-96x96.png","contentUrl":"https://www.excel-university.com/wp-content/uploads/cropped-Excel_u-logo_for_Favicon-96x96.png","caption":"Excel University"},"description":"We love sharing the things we've learned about Excel, and we built Excel University to help us do that. Our motto is: Learn Excel. Work Faster.","url":"https://www.excel-university.com/author/excel-writer/"}]}</script>

<link rel="dns-prefetch" href="//scripts.mediavine.com">
<link rel="dns-prefetch" href="//stats.wp.com">
<link rel="dns-prefetch" href="//cdnjs.cloudflare.com">
<link rel="dns-prefetch" href="//fonts.googleapis.com">
<link rel="dns-prefetch" href="//v0.wordpress.com">
<link href="https://fonts.gstatic.com" crossorigin="" rel="preconnect">
<link rel="alternate" type="application/rss+xml" title="Excel University » Feed" href="https://www.excel-university.com/feed/">
<link rel="alternate" type="application/rss+xml" title="Excel University » Comments Feed" href="https://www.excel-university.com/comments/feed/">
<link rel="alternate" type="application/rss+xml" title="Excel University » Four Ways to Select Every Other Row in Excel Comments Feed" href="https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/feed/">
<link rel="preload" href="https://cdnjs.cloudflare.com/ajax/libs/foundicons/3.0.0/foundation-icons.woff" as="font" type="font/woff2" crossorigin="anonymous">
<link rel="preload" href="https://www.excel-university.com/wp-content/plugins/bb-plugin/fonts/fontawesome/5.15.4/webfonts/fa-solid-900.woff2" as="font" type="font/woff2" crossorigin="anonymous">
<link rel="preload" href="https://www.excel-university.com/wp-content/plugins/bb-plugin/fonts/fontawesome/5.15.4/webfonts/fa-regular-400.woff2" as="font" type="font/woff2" crossorigin="anonymous">
<link rel="stylesheet" id="wp-block-library-css" href="https://www.excel-university.com/wp-includes/css/dist/block-library/style.min.css?ver=6.6.2" media="all">
<style id="wp-block-library-theme-inline-css">
.wp-block-audio :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-audio :where(figcaption){color:#ffffffa6}.wp-block-audio{margin:0 0 1em}.wp-block-code{border:1px solid #ccc;border-radius:4px;font-family:Menlo,Consolas,monaco,monospace;padding:.8em 1em}.wp-block-embed :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-embed :where(figcaption){color:#ffffffa6}.wp-block-embed{margin:0 0 1em}.blocks-gallery-caption{color:#555;font-size:13px;text-align:center}.is-dark-theme .blocks-gallery-caption{color:#ffffffa6}:root :where(.wp-block-image figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme :root :where(.wp-block-image figcaption){color:#ffffffa6}.wp-block-image{margin:0 0 1em}.wp-block-pullquote{border-bottom:4px solid;border-top:4px solid;color:currentColor;margin-bottom:1.75em}.wp-block-pullquote cite,.wp-block-pullquote footer,.wp-block-pullquote__citation{color:currentColor;font-size:.8125em;font-style:normal;text-transform:uppercase}.wp-block-quote{border-left:.25em solid;margin:0 0 1.75em;padding-left:1em}.wp-block-quote cite,.wp-block-quote footer{color:currentColor;font-size:.8125em;font-style:normal;position:relative}.wp-block-quote.has-text-align-right{border-left:none;border-right:.25em solid;padding-left:0;padding-right:1em}.wp-block-quote.has-text-align-center{border:none;padding-left:0}.wp-block-quote.is-large,.wp-block-quote.is-style-large,.wp-block-quote.is-style-plain{border:none}.wp-block-search .wp-block-search__label{font-weight:700}.wp-block-search__button{border:1px solid #ccc;padding:.375em .625em}:where(.wp-block-group.has-background){padding:1.25em 2.375em}.wp-block-separator.has-css-opacity{opacity:.4}.wp-block-separator{border:none;border-bottom:2px solid;margin-left:auto;margin-right:auto}.wp-block-separator.has-alpha-channel-opacity{opacity:1}.wp-block-separator:not(.is-style-wide):not(.is-style-dots){width:100px}.wp-block-separator.has-background:not(.is-style-dots){border-bottom:none;height:1px}.wp-block-separator.has-background:not(.is-style-wide):not(.is-style-dots){height:2px}.wp-block-table{margin:0 0 1em}.wp-block-table td,.wp-block-table th{word-break:normal}.wp-block-table :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-table :where(figcaption){color:#ffffffa6}.wp-block-video :where(figcaption){color:#555;font-size:13px;text-align:center}.is-dark-theme .wp-block-video :where(figcaption){color:#ffffffa6}.wp-block-video{margin:0 0 1em}:root :where(.wp-block-template-part.has-background){margin-bottom:0;margin-top:0;padding:1.25em 2.375em}
</style>
<link data-minify="1" rel="stylesheet" id="activecampaign-form-block-css" href="https://www.excel-university.com/wp-content/cache/min/1/wp-content/plugins/activecampaign-subscription-forms/activecampaign-form-block/build/style-index.css?ver=1729100678" media="all">
<link rel="stylesheet" id="mediaelement-css" href="https://www.excel-university.com/wp-includes/js/mediaelement/mediaelementplayer-legacy.min.css?ver=4.2.17" media="all">
<link rel="stylesheet" id="wp-mediaelement-css" href="https://www.excel-university.com/wp-includes/js/mediaelement/wp-mediaelement.min.css?ver=6.6.2" media="all">
<style id="jetpack-sharing-buttons-style-inline-css">
.jetpack-sharing-buttons__services-list{display:flex;flex-direction:row;flex-wrap:wrap;gap:0;list-style-type:none;margin:5px;padding:0}.jetpack-sharing-buttons__services-list.has-small-icon-size{font-size:12px}.jetpack-sharing-buttons__services-list.has-normal-icon-size{font-size:16px}.jetpack-sharing-buttons__services-list.has-large-icon-size{font-size:24px}.jetpack-sharing-buttons__services-list.has-huge-icon-size{font-size:36px}@media print{.jetpack-sharing-buttons__services-list{display:none!important}}.editor-styles-wrapper .wp-block-jetpack-sharing-buttons{gap:0;padding-inline-start:0}ul.jetpack-sharing-buttons__services-list.has-background{padding:1.25em 2.375em}
</style>
<style id="classic-theme-styles-inline-css">
/*! This file is auto-generated */
.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em + 2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none}
</style>
<style id="global-styles-inline-css">
:root{--wp--preset--aspect-ratio--square: 1;--wp--preset--aspect-ratio--4-3: 4/3;--wp--preset--aspect-ratio--3-4: 3/4;--wp--preset--aspect-ratio--3-2: 3/2;--wp--preset--aspect-ratio--2-3: 2/3;--wp--preset--aspect-ratio--16-9: 16/9;--wp--preset--aspect-ratio--9-16: 9/16;--wp--preset--color--black: #000000;--wp--preset--color--cyan-bluish-gray: #abb8c3;--wp--preset--color--white: #ffffff;--wp--preset--color--pale-pink: #f78da7;--wp--preset--color--vivid-red: #cf2e2e;--wp--preset--color--luminous-vivid-orange: #ff6900;--wp--preset--color--luminous-vivid-amber: #fcb900;--wp--preset--color--light-green-cyan: #7bdcb5;--wp--preset--color--vivid-green-cyan: #00d084;--wp--preset--color--pale-cyan-blue: #8ed1fc;--wp--preset--color--vivid-cyan-blue: #0693e3;--wp--preset--color--vivid-purple: #9b51e0;--wp--preset--color--fl-heading-text: #4f4f4f;--wp--preset--color--fl-body-bg: #f2f2f2;--wp--preset--color--fl-body-text: #2e2e2e;--wp--preset--color--fl-accent: #066e00;--wp--preset--color--fl-accent-hover: #066e00;--wp--preset--color--fl-topbar-bg: #ffffff;--wp--preset--color--fl-topbar-text: #371420;--wp--preset--color--fl-topbar-link: #371420;--wp--preset--color--fl-topbar-hover: #066e00;--wp--preset--color--fl-header-bg: #ffffff;--wp--preset--color--fl-header-text: #371420;--wp--preset--color--fl-header-link: #371420;--wp--preset--color--fl-header-hover: #066e00;--wp--preset--color--fl-nav-bg: #ffffff;--wp--preset--color--fl-nav-link: #428bca;--wp--preset--color--fl-nav-hover: #428bca;--wp--preset--color--fl-content-bg: #ffffff;--wp--preset--color--fl-footer-widgets-bg: #ffffff;--wp--preset--color--fl-footer-widgets-text: #000000;--wp--preset--color--fl-footer-widgets-link: #428bca;--wp--preset--color--fl-footer-widgets-hover: #428bca;--wp--preset--color--fl-footer-bg: #371420;--wp--preset--color--fl-footer-text: #ffffff;--wp--preset--color--fl-footer-link: #ffffff;--wp--preset--color--fl-footer-hover: #f2f2f2;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple: linear-gradient(135deg,rgba(6,147,227,1) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan: linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange: linear-gradient(135deg,rgba(252,185,0,1) 0%,rgba(255,105,0,1) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red: linear-gradient(135deg,rgba(255,105,0,1) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray: linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);--wp--preset--gradient--cool-to-warm-spectrum: linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple: linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux: linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk: linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean: linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass: linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight: linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--font-size--small: 13px;--wp--preset--font-size--medium: 20px;--wp--preset--font-size--large: 36px;--wp--preset--font-size--x-large: 42px;--wp--preset--spacing--20: 0.44rem;--wp--preset--spacing--30: 0.67rem;--wp--preset--spacing--40: 1rem;--wp--preset--spacing--50: 1.5rem;--wp--preset--spacing--60: 2.25rem;--wp--preset--spacing--70: 3.38rem;--wp--preset--spacing--80: 5.06rem;--wp--preset--shadow--natural: 6px 6px 9px rgba(0, 0, 0, 0.2);--wp--preset--shadow--deep: 12px 12px 50px rgba(0, 0, 0, 0.4);--wp--preset--shadow--sharp: 6px 6px 0px rgba(0, 0, 0, 0.2);--wp--preset--shadow--outlined: 6px 6px 0px -3px rgba(255, 255, 255, 1), 6px 6px rgba(0, 0, 0, 1);--wp--preset--shadow--crisp: 6px 6px 0px rgba(0, 0, 0, 1);}:where(.is-layout-flex){gap: 0.5em;}:where(.is-layout-grid){gap: 0.5em;}body .is-layout-flex{display: flex;}.is-layout-flex{flex-wrap: wrap;align-items: center;}.is-layout-flex > :is(*, div){margin: 0;}body .is-layout-grid{display: grid;}.is-layout-grid > :is(*, div){margin: 0;}:where(.wp-block-columns.is-layout-flex){gap: 2em;}:where(.wp-block-columns.is-layout-grid){gap: 2em;}:where(.wp-block-post-template.is-layout-flex){gap: 1.25em;}:where(.wp-block-post-template.is-layout-grid){gap: 1.25em;}.has-black-color{color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color: var(--wp--preset--color--white) !important;}.has-pale-pink-color{color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color: var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color: var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color: var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color: var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color: var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color: var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color: var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color: var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color: var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color: var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color: var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color: var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color: var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color: var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color: var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background: var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background: var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background: var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background: var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background: var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background: var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background: var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background: var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background: var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background: var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background: var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size: var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size: var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size: var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size: var(--wp--preset--font-size--x-large) !important;}
:where(.wp-block-post-template.is-layout-flex){gap: 1.25em;}:where(.wp-block-post-template.is-layout-grid){gap: 1.25em;}
:where(.wp-block-columns.is-layout-flex){gap: 2em;}:where(.wp-block-columns.is-layout-grid){gap: 2em;}
:root :where(.wp-block-pullquote){font-size: 1.5em;line-height: 1.6;}
</style>
<link data-minify="1" rel="stylesheet" id="font-awesome-5-css" href="https://www.excel-university.com/wp-content/cache/min/1/wp-content/plugins/bb-plugin/fonts/fontawesome/5.15.4/css/all.min.css?ver=1729100678" media="all">
<link data-minify="1" rel="stylesheet" id="ultimate-icons-css" href="https://www.excel-university.com/wp-content/cache/min/1/wp-content/uploads/bb-plugin/icons/ultimate-icons/style.css?ver=1729100678" media="all">
<link data-minify="1" rel="stylesheet" id="foundation-icons-css" href="https://www.excel-university.com/wp-content/cache/min/1/ajax/libs/foundicons/3.0.0/foundation-icons.css?ver=1729100678" media="all">
<link data-minify="1" rel="stylesheet" id="fl-builder-layout-bundle-cf81b0210b159aabe534e04459b2786f-css" href="https://www.excel-university.com/wp-content/cache/min/1/wp-content/uploads/bb-plugin/cache/cf81b0210b159aabe534e04459b2786f-layout-bundle.css?ver=1729100678" media="all">
<link data-minify="1" rel="stylesheet" id="searchwp-forms-css" href="https://www.excel-university.com/wp-content/cache/min/1/wp-content/plugins/searchwp/assets/css/frontend/search-forms.css?ver=1729100678" media="all">
<link rel="stylesheet" id="jquery-magnificpopup-css" href="https://www.excel-university.com/wp-content/plugins/bb-plugin/css/jquery.magnificpopup.min.css?ver=2.8.4.1" media="all">
<link data-minify="1" rel="stylesheet" id="bootstrap-css" href="https://www.excel-university.com/wp-content/cache/min/1/wp-content/themes/bb-theme/css/bootstrap.min.css?ver=1729100678" media="all">
<link data-minify="1" rel="stylesheet" id="fl-automator-skin-css" href="https://www.excel-university.com/wp-content/cache/min/1/wp-content/uploads/bb-theme/skin-6672f93b61474.css?ver=1729100678" media="all">
<link rel="stylesheet" id="fl-child-theme-css" href="https://www.excel-university.com/wp-content/themes/bb-theme-child/style.css?ver=6.6.2" media="all">
<script async="async" data-noptimize="1" data-cfasync="false" src="https://scripts.mediavine.com/tags/excel-university.js?ver=6.6.2" id="mv-script-wrapper-js"></script>
<script src="https://www.excel-university.com/wp-includes/js/jquery/jquery.min.js?ver=3.7.1" id="jquery-core-js"></script>
<link rel="https://api.w.org/" href="https://www.excel-university.com/wp-json/"><link rel="alternate" title="JSON" type="application/json" href="https://www.excel-university.com/wp-json/wp/v2/posts/21967"><link rel="alternate" title="oEmbed (JSON)" type="application/json+oembed" href="https://www.excel-university.com/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.excel-university.com%2Ffour-ways-to-select-every-other-row-in-excel%2F">
<link rel="alternate" title="oEmbed (XML)" type="text/xml+oembed" href="https://www.excel-university.com/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fwww.excel-university.com%2Ffour-ways-to-select-every-other-row-in-excel%2F&amp;format=xml">


<style>img#wpstats{display:none}</style>
<link rel="icon" href="https://www.excel-university.com/wp-content/uploads/cropped-Excel_u-logo_for_Favicon-32x32.png" sizes="32x32">
<link rel="icon" href="https://www.excel-university.com/wp-content/uploads/cropped-Excel_u-logo_for_Favicon-192x192.png" sizes="192x192">
<link rel="apple-touch-icon" href="https://www.excel-university.com/wp-content/uploads/cropped-Excel_u-logo_for_Favicon-180x180.png">
<meta name="msapplication-TileImage" content="https://www.excel-university.com/wp-content/uploads/cropped-Excel_u-logo_for_Favicon-270x270.png">
<style id="wp-custom-css">
			.fl-page-content {
	padding-top: 200px;
} 
/*add underline to blog post content BR 031022*/
body.single .fl-node-5ed6bc0dd6725 a:not(a.fl-button,a.wp-block-button__link.has-background) {text-decoration:underline;}


/* store, login, cart icons */
.secondary_nav {
	color: #2e2e2e; !important;
	padding: 0px 2.5px 2.5px 2.5px;
}
.secondary_nav a:link{
	color: #2e2e2e !important;
}
.secondary_nav a:hover{
	color: #c4c4c4 !important;
}


/* Hide "Posts" heading and separator on /blog page */
.blog .fl-node-5ee92d5544cac {
	display: none;
}
.blog .fl-node-5ee92dfd7bb17{
	display: none;
}

/* Hide additional title and Edit link from top of each page */
.fl-post-header{
	display:none !important;
}

/* hide WP default header and footer for marketing LANDING PAGE */
.page-id-14963 .fl-page-header {
	display: none;
}
.page-id-14963 .fl-page-footer-wrap {
	display: none;
}


/* Mediavine CSS */
@media only screen and (min-width: 1200px) {
     .blog #fl-main-content .fl-row-fixed-width .fl-node-content > .fl-col-group > .fl-col:not(.fl-col-small), .archive #fl-main-content .fl-col-group-nested.fl-col-group > .fl-col:not(.fl-col-small), .fl-has-sidebar #fl-main-content .fl-node-content > .fl-col-group > .fl-col:not(.fl-col-small) {
         max-width: calc(100% - 330px) !important;
    }
     body:not(.home):not(.single-articles):not(.page) #fl-main-content .fl-node-content > .fl-col-group > .fl-col-small {
         min-width: 330px !important;
    }
}

@media only screen and (max-width: 399px) {
#fl-main-content > div .fl-row-content-wrap {
    padding-left: 17px !important;
    padding-right: 17px !important;
  }
}

@media only screen and (max-width: 359px) {
  #fl-main-content .fl-row-content-wrap {
     padding-left: 0px !important;
     padding-right: 0px !important;
    }
  #fl-main-content .fl-module-fl-post-content  .fl-module-content.fl-node-content {
     min-width: 100% !important;
     margin-left:auto !important;
     margin-right: auto !important;
     padding-left: 10px !important;
     padding-right: 10px !important;
    }
}  
/* End of MV CSS *		</style>
<noscript><style id="rocket-lazyload-nojs-css">.rll-youtube-player, [data-lazy-src]{display:none !important;}</style></noscript>
<script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
})(window,document,'script','dataLayer','GTM-M8T7N66');</script>

<link rel="preload" href="https://securepubads.g.doubleclick.net/tag/js/gpt.js" as="script"><style id="fit-vids-style">.fluid-width-video-wrapper{width:100%;position:relative;padding:0;}.fluid-width-video-wrapper iframe,.fluid-width-video-wrapper object,.fluid-width-video-wrapper embed {position:absolute;top:0;left:0;width:100%;height:100%;}</style><style type="text/css">:root{--fides-overlay-primary-color:#8243f2;--fides-overlay-background-color:#f7fafc;--fides-overlay-embed-background-color:transparent;--fides-overlay-font-color:#4a5568;--fides-overlay-font-color-dark:#2d3748;--fides-overlay-hover-color:#edf2f7;--fides-overlay-gpc-applied-background-color:#38a169;--fides-overlay-gpc-applied-text-color:#fff;--fides-overlay-gpc-overridden-background-color:#e53e3e;--fides-overlay-gpc-overridden-text-color:#fff;--fides-overlay-background-dark-color:#e2e8f0;--fides-overlay-width:680px;--fides-overlay-primary-button-background-color:var(
    --fides-overlay-primary-color
  );--fides-overlay-primary-button-background-hover-color:#9569f4;--fides-overlay-primary-button-text-color:#fff;--fides-overlay-primary-button-border-color:transparent;--fides-overlay-secondary-button-background-color:var(
    --fides-overlay-background-color
  );--fides-overlay-secondary-button-background-hover-color:var(
    --fides-overlay-hover-color
  );--fides-overlay-secondary-button-text-color:#2d3748;--fides-overlay-secondary-button-border-color:var(
    --fides-overlay-primary-color
  );--fides-overlay-title-font-color:var(--fides-overlay-font-color);--fides-overlay-body-font-color:var(--fides-overlay-font-color);--fides-overlay-link-font-color:var(--fides-overlay-font-color-dark);--fides-overlay-primary-active-color:var(--fides-overlay-primary-color);--fides-overlay-inactive-color:#e2e8f0;--fides-overlay-inactive-font-color:#a0aec0;--fides-overlay-disabled-color:#e1e7ee;--fides-overlay-row-divider-color:#e2e8f0;--fides-overlay-row-hover-color:var(--fides-overlay-hover-color);--fides-overlay-badge-background-color:#718096;--fides-overlay-badge-border-radius:4px;--fides-overlay-select-border-color:#e2e8f0;--fides-overlay-language-button-border-radius:4px;--fides-overlay-font-family:Inter,sans-serif;--12px:0.75rem;--14px:0.875rem;--15px:0.9375rem;--16px:1rem;--fides-overlay-font-size-body-small:var(--12px);--fides-overlay-font-size-body:var(--14px);--fides-overlay-font-size-title:var(--16px);--fides-overlay-font-size-buttons:var(--14px);--fides-overlay-padding:24px;--fides-overlay-button-border-radius:6px;--fides-overlay-button-padding:8px 16px;--fides-overlay-link-v-padding:4px;--fides-overlay-link-h-padding:4px;--fides-overlay-link-padding:var(--fides-overlay-link-v-padding) var(--fides-overlay-link-h-padding);--fides-overlay-container-border-radius:12px;--fides-overlay-container-border-width:1px;--fides-overlay-component-border-radius:4px;--fides-overlay-banner-offset:48px;--fides-banner-font-size-title:var(--16px);--fides-overlay-language-loading-indicator-speed:5s}@keyframes spin{0%{transform:rotate(0deg)}to{transform:rotate(1turn)}}div.fides-overlay{position:fixed;z-index:1000}div#fides-overlay-wrapper *{box-sizing:border-box}.fides-banner,.fides-modal-container{-webkit-font-smoothing:antialiased;font-family:var(--fides-overlay-font-family);font-size:var(--fides-overlay-font-size-body);line-height:calc(1em + .4rem);white-space:pre-line}#fides-modal-link{cursor:pointer;display:none}#fides-modal-link.fides-modal-link-shown{display:inline}div#fides-banner-container:not(.fides-embedded){display:flex;justify-content:center;position:fixed;transform:translateY(0);transition:transform 1s,visibility 1s;visibility:visible;width:100%;z-index:1}div#fides-banner{align-items:center;background:var(--fides-overlay-background-color);border-top:var(--fides-overlay-container-border-width) solid var(--fides-overlay-primary-color);color:var(--fides-overlay-body-font-color);display:flex;flex-direction:row;flex-wrap:wrap;font-size:var(--fides-overlay-font-size-body);justify-content:space-between;overflow-y:hidden;padding:24px;position:relative}.fides-embedded div#fides-banner{border:none}div#fides-banner-inner{width:100%}div#fides-banner-container.fides-banner-bottom{bottom:0;left:0}div#fides-banner-container.fides-banner-hidden{visibility:hidden}div#fides-banner-container.fides-banner-hidden.fides-embedded{display:none}div#fides-banner-container.fides-banner-bottom.fides-banner-hidden{transform:translateY(150%)}div#fides-banner-container.fides-banner-top{left:0;top:0}div#fides-banner-container.fides-banner-top.fides-banner-hidden{transform:translateY(-150%)}div#fides-banner-inner div#fides-button-group{align-items:center;flex-direction:row-reverse;margin-bottom:0;margin-top:0;padding-bottom:0;padding-top:0;width:100%}.fides-modal-footer div#fides-button-group{align-items:center;flex-direction:column;gap:12px;margin-inline:var(--fides-overlay-padding)}div#fides-banner-heading{align-items:center;display:flex;margin-right:13px}.fides-banner-title{color:var(--fides-overlay-title-font-color);font-size:var(--fides-banner-font-size-title);font-weight:600;line-height:1.5em;margin:0}.fides-banner-description{flex:1;font-size:var(--fides-overlay-font-size-body);margin-bottom:24px;margin-top:16px}.fides-banner-description a,.fides-modal-description a{color:var(--fides-overlay-primary-color)}div#fides-banner-notices{margin-top:16px}div#fides-button-group{background-color:var(--fides-overlay-background-color);display:flex;justify-content:space-between;margin-bottom:var(--fides-overlay-padding);margin-top:8px;z-index:5}button.fides-banner-button{align-items:center;background:var(--fides-overlay-primary-button-background-color);border:1px solid;border-radius:var(--fides-overlay-button-border-radius);color:var(--fides-overlay-primary-button-text-color);cursor:pointer;display:flex;font-family:var(--fides-overlay-font-family);font-size:var(--fides-overlay-font-size-buttons);font-weight:600;justify-content:center;margin:4px 0 0;padding:var(--fides-overlay-button-padding);text-decoration:none}button.fides-banner-button:focus,button.fides-banner-button:hover,button.fides-banner-button[disabled]{background:var(--fides-overlay-primary-button-background-hover-color)}button.fides-banner-button.fides-banner-button-primary{background:var(--fides-overlay-primary-button-background-color);border:none;color:var(--fides-overlay-primary-button-text-color)}button.fides-banner-button.fides-banner-button-primary:focus,button.fides-banner-button.fides-banner-button-primary:hover,button.fides-banner-button.fides-banner-button-primary[disabled]{background:var(--fides-overlay-primary-button-background-hover-color)}button.fides-banner-button.fides-banner-button-secondary{background:var(--fides-overlay-secondary-button-background-color);border:1px solid var(--fides-overlay-primary-button-background-color);color:var(--fides-overlay-secondary-button-text-color)}button.fides-banner-button.fides-banner-button-secondary:focus,button.fides-banner-button.fides-banner-button-secondary:hover,button.fides-banner-button.fides-banner-button-secondary[disabled]{background:var(--fides-overlay-secondary-button-background-hover-color)}button.fides-banner-button.fides-banner-button-tertiary{background:none;border:none;color:var(--fides-overlay-link-font-color);cursor:pointer;font-size:var(--fides-overlay-font-size-body);font-weight:500;line-height:1.25em;padding:0;text-decoration:underline}button.fides-banner-button.fides-acknowledge-button{min-width:160px}.fides-spinner{animation:spin 1s linear infinite;border-color:currentcolor currentcolor transparent transparent;border-radius:50%;border-style:solid;border-width:2px;border-right:2px solid var(--fides-overlay-primary-color);border-top:2px solid var(--fides-overlay-primary-color);height:1em;margin-left:8px;width:1em}.fides-banner-button-primary .fides-spinner{border-right-color:var(--fides-overlay-primary-button-text-color);border-top-color:var(--fides-overlay-primary-button-text-color)}.fides-banner-button-secondary .fides-spinner{border-right-color:var(--fides-overlay-secondary-button-border-color);border-top-color:var(--fides-overlay-secondary-button-border-color)}div.fides-modal-content{background-color:var(--fides-overlay-background-color);border:var(--fides-overlay-container-border-width) solid var(--fides-overlay-primary-color);border-radius:var(--fides-overlay-container-border-radius);color:var(--fides-overlay-body-font-color);display:flex;flex-direction:column;font-family:var(--fides-overlay-font-family);font-size:var(--fides-overlay-font-size-body);left:50%;max-height:680px;overflow:hidden;padding:0;position:fixed;top:50%;transform:translate(-50%,-50%);width:var(--fides-overlay-width);z-index:2}.fides-modal-container,.fides-modal-overlay{background-color:rgba(0,0,0,.25);bottom:0;left:0;position:fixed;right:0;top:0}div#fides-embed-container div#fides-consent-content .fides-modal-footer{position:inherit}div#fides-embed-container .fides-modal-body{padding-top:16px}div#fides-embed-container div#fides-consent-content{background-color:var(--fides-overlay-background-color);border:none;border-radius:var(--fides-overlay-container-border-radius);border-bottom-left-radius:0;border-bottom-right-radius:0;color:var(--fides-overlay-body-font-color);display:flex;flex-direction:column;font-family:var(--fides-overlay-font-family);font-size:var(--fides-overlay-font-size-body);left:50%;max-height:none;overflow:hidden;padding:0;position:static;top:50%;transform:none;width:var(--fides-overlay-width)}.fides-modal-container{display:flex;z-index:2}.fides-modal-container[aria-hidden=true]{display:none}div#fides-modal .fides-modal-header{display:flex;justify-content:end}div#fides-consent-content{overflow:auto;scrollbar-gutter:stable}div#fides-consent-content .fides-modal-title{color:var(--fides-overlay-title-font-color);font-size:var(--fides-overlay-font-size-title);font-weight:600;margin:0;text-align:center}div#fides-consent-content .fides-modal-body{height:100%;overflow-y:auto;padding-inline:var(--fides-overlay-padding)}.fides-modal-footer{background-color:var(--fides-overlay-background-color);border-bottom-left-radius:var(--fides-overlay-component-border-radius);border-bottom-right-radius:var(--fides-overlay-component-border-radius);bottom:0;display:flex;flex-direction:column;max-width:var(--fides-overlay-width);position:relative;width:100%;z-index:5}div#fides-consent-content .fides-modal-description{margin:8px 0 24px}.fides-banner-button-group{align-items:center;display:flex;gap:12px}.fides-modal-button-group{display:flex;flex-direction:row;gap:12px;margin-inline:var(--fides-overlay-padding);width:100%}.fides-modal-primary-actions .fides-banner-button{flex:1}.fides-banner-secondary-actions{justify-content:space-between}.fides-modal-secondary-actions{justify-content:center}.fides-banner-secondary-actions{gap:36px}.fides-no-scroll{overflow:hidden}@media (max-width:768px){div#fides-consent-content,div.fides-modal-content{width:100%!important}.fides-modal-button-group{flex-direction:column}button.fides-banner-button{margin:0 8px 12px 0}}div#fides-banner .fides-close-button{background:none;border:none;cursor:pointer;display:flex;position:absolute;right:3px;top:8px}.fides-modal-header .fides-close-button{background:none;border:none;cursor:pointer;padding-right:8px;padding-top:8px}.fides-close-button:hover{background:var(--fides-overlay-hover-color)}.fides-embedded .fides-close-button{display:none!important}.fides-modal-notices{margin-bottom:16px}.fides-privacy-policy{color:var(--fides-overlay-primary-color);display:block;font-family:var(--fides-overlay-font-family);text-align:center}.fides-privacy-policy,button.fides-banner-button.fides-banner-button-tertiary,div.fides-i18n-pseudo-button{line-height:1;margin:0;padding:var(--fides-overlay-link-padding)}@media (prefers-reduced-motion:reduce){.fides-toggle-display{transition-duration:0ms}}.fides-toggle{align-items:center;display:inline-flex;flex-wrap:wrap;gap:1ch;position:relative}.fides-toggle .fides-toggle-input{cursor:pointer;height:100%;opacity:0;position:absolute;width:100%;z-index:4}.fides-toggle .fides-toggle-display{--offset:4px;--diameter:16px;align-items:center;background-color:var(--fides-overlay-inactive-color);border-radius:100vw;box-sizing:content-box;color:var(--fides-overlay-inactive-font-color);display:inline-flex!important;height:24px;justify-content:space-around;justify-content:end;padding-inline:8px;position:relative;transition:.25s;width:34px}div#fides-overlay-wrapper .fides-toggle .fides-toggle-display{box-sizing:content-box}.fides-toggle .fides-toggle-display:before{background-color:#fff;border-radius:50%;box-shadow:0 1.3px 2.7px rgba(0,0,0,.25);box-sizing:border-box;content:"";height:var(--diameter);left:var(--offset);position:absolute;top:50%;transform:translateY(-50%);transition:inherit;width:var(--diameter);z-index:3}.fides-toggle .fides-toggle-input:checked+.fides-toggle-display{background-color:var(--fides-overlay-primary-active-color);color:var(--fides-overlay-primary-button-text-color);justify-content:start}.fides-toggle .fides-toggle-input:checked+.fides-toggle-display:before{transform:translate(26px,-50%)}.fides-toggle .fides-toggle-input:disabled{cursor:not-allowed}.fides-toggle .fides-toggle-input:disabled+.fides-toggle-display,.fides-toggle .fides-toggle-input:disabled:checked+.fides-toggle-display{background-color:var(--fides-overlay-disabled-color)}.fides-toggle .fides-toggle-input:focus+.fides-toggle-display{outline:1px auto Highlight;outline:1px auto -webkit-focus-ring-color}.fides-toggle .fides-toggle-input:focus:not(:focus-visible)+.fides-toggle-display{outline:0}.fides-divider{border-color:var(--fides-overlay-row-divider-color);border-width:0 0 1px;margin:0}.fides-disclosure-hidden{display:flex;height:0;margin-bottom:0;margin-top:0;overflow:hidden;visibility:hidden}.fides-notice-toggle .fides-notice-toggle-title{align-items:center;border-bottom:1px solid var(--fides-overlay-row-divider-color);display:flex;justify-content:space-between;padding-inline:12px 12px}.fides-notice-toggle .fides-notice-toggle-trigger{align-items:center;display:flex;justify-content:flex-end;min-height:40px}.fides-notice-toggle .fides-notice-toggle-trigger svg{flex-shrink:0}.fides-notice-toggle .fides-notice-toggle-title:hover{background-color:var(--fides-overlay-row-hover-color);cursor:pointer}.fides-notice-toggle .fides-notice-toggle-trigger:before{border-style:solid;border-width:2px 2px 0 0;content:"";display:inline-block;height:8px;margin-right:calc(.5rem + 2px);min-width:8px;transform:translateY(-2px) rotate(135deg);transition:transform .12s ease-in-out}.fides-notice-toggle.fides-notice-toggle-expanded .fides-notice-toggle-trigger:before{transform:translateY(2px) rotate(-45deg)}.fides-notice-toggle .fides-disclosure-visible{display:flex;flex-direction:column;gap:12px;overflow:auto;padding:12px}.fides-notice-toggle p{margin:0 0 18px}.fides-notice-toggle p:last-child{margin:0}.fides-notice-toggle-title .fides-flex-center{align-items:center;display:flex;white-space:wrap;width:100%}.fides-notice-toggle-expanded{background-color:var(--fides-overlay-row-hover-color)}.fides-notice-toggle-header{font-weight:600}.fides-gpc-banner{border:1px solid var(--fides-overlay-primary-color);border-radius:var(--fides-overlay-component-border-radius);display:flex;margin-bottom:16px;padding:18px}.fides-gpc-banner p{margin:0}.fides-gpc-warning{color:var(--fides-overlay-primary-color);margin-right:8px}.fides-gpc-header{font-weight:700}.fides-gpc-label{display:inline-flex;font-size:var(--fides-overlay-font-size-body);font-weight:600;padding:0 8px;white-space:nowrap}.fides-gpc-badge{border-radius:var(--fides-overlay-badge-border-radius);display:inline-flex;font-weight:700;margin-left:4px;padding:0 4px;text-transform:uppercase}.fides-gpc-badge-applied,.fides-gpc-badge-detected{background:var(--fides-overlay-gpc-applied-background-color);color:var(--fides-overlay-gpc-applied-text-color)}.fides-gpc-badge-overridden{background:var(--fides-overlay-gpc-overridden-background-color);color:var(--fides-overlay-gpc-overridden-text-color)}.fides-tab-list{display:flex;list-style-type:none;padding:0}.fides-tab-list>li{width:100%}.fides-tab-button{background:none;border-width:0 0 1px;border-bottom:1px solid var(--fides-overlay-row-divider-color);color:var(--fides-overlay-body-font-color);cursor:pointer;font-weight:500;padding:10px 20px;width:100%}.fides-tab-button[aria-selected=true]{border-bottom-width:2px;border-color:var(--fides-overlay-primary-active-color);color:var(--fides-overlay-primary-active-color);font-weight:600}.fides-tab-button::focus-visible{outline:1px auto Highlight;outline:1px auto -webkit-focus-ring-color}.fides-tab-button:focus:not(:focus-visible){outline:0}.fides-notice-badge{align-items:center;background:var(--fides-overlay-badge-background-color);border-radius:var(--fides-overlay-badge-border-radius);color:#fff;display:inline-flex;font-size:var(--fides-overlay-font-size-body-small);font-weight:600;height:18px;margin-left:4px;margin-right:8px;padding:0 4px;text-transform:uppercase}.fides-background-dark{background-color:var(--fides-overlay-background-dark-color)}.fides-radio-button-group{background-color:var(
    --fides-overlay-secondary-button-background-hover-color
  );border:1px solid var(--fides-overlay-row-divider-color);display:flex;margin-bottom:22px;padding:4px}.fides-radio-button{background-color:transparent;border:none;cursor:pointer;flex:1;padding:5px 16px}.fides-radio-button[aria-checked=true]{background-color:var(--fides-overlay-primary-button-background-color);color:var(--fides-overlay-primary-button-text-color)}.fides-flex-center{align-items:center;display:flex}.fides-margin-right{margin-right:3px}.fides-justify-space-between{justify-content:space-between}.fides-vendor-details-table{width:100%}.fides-vendor-details-table td,.fides-vendor-details-table th{font-size:var(--fides-overlay-font-size-body-small);text-align:left}.fides-vendor-details-table td{border-bottom:1px solid var(--fides-overlay-row-divider-color)}.fides-link-button{background:none;border:none;color:var(--fides-overlay-body-font-color);cursor:pointer;padding:0;text-decoration:underline}.fides-external-link,.fides-primary-text-color{color:var(--fides-overlay-primary-color)}.fides-external-link{font-size:var(--fides-overlay-font-size-body-small);font-weight:500;margin-right:16px}.fides-info-box{background-color:var(--fides-overlay-hover-color);border-radius:var(--fides-overlay-component-border-radius);margin:10px 0;padding:16px}.fides-info-box p{margin:0}.fides-tabs .tabpanel-container{overflow:hidden}.tabpanel-container section[hidden]{display:none}.fides-paging-buttons{display:flex;gap:8px;justify-content:center}.fides-paging-info{color:var(--fides-overlay-font-color-dark);font-size:var(--fides-overlay-font-size-body-small);font-weight:600;padding:8px}.fides-paging-previous-button{margin-right:8px}.fides-paging-next-button,.fides-paging-previous-button{background-color:transparent;border:none;cursor:pointer;padding:6px}.fides-paging-next-button:disabled,.fides-paging-previous-button:disabled{cursor:default}.fides-i18n-menu{position:relative}.fides-modal-container .fides-i18n-menu{bottom:var(--fides-overlay-padding);left:var(--fides-overlay-padding);position:absolute}.fides-modal-container .fides-button-group-i18n{min-height:calc(var(--fides-overlay-font-size-body) + var(--fides-overlay-link-v-padding)*2)}div.fides-i18n-pseudo-button{align-items:center;cursor:pointer;display:flex;flex-direction:row;gap:2px;height:var(--fides-overlay-font-size-body);text-transform:uppercase;white-space:nowrap}#fides-i18n-icon{animation-duration:var(--fides-overlay-language-loading-indicator-speed);animation-iteration-count:infinite;animation-timing-function:linear;transform-origin:50% 50%}div#fides-overlay-wrapper .fides-i18n-pseudo-button{box-sizing:content-box}.fides-i18n-popover{bottom:100%;display:flex;flex-direction:column;gap:1px;height:0;left:0;max-height:7rem;overflow:hidden;position:absolute;transition:height .5s}.fides-i18n-menu:hover .fides-i18n-pseudo-button{background-color:var(--fides-overlay-hover-color);border-radius:var(--fides-overlay-language-button-border-radius)}.fides-i18n-menu:hover .fides-i18n-pseudo-button .fides-i18n-caret{transform:rotate(180deg)}.fides-i18n-menu:focus-within .fides-i18n-popover,.fides-i18n-menu:hover .fides-i18n-popover{background-color:var(--fides-overlay-background-dark-color);border:1px solid var(--fides-overlay-primary-color);border-radius:var(--fides-overlay-component-border-radius);height:auto;min-width:9rem;overflow:scroll}button.fides-banner-button.fides-menu-item{background:var(--fides-overlay-secondary-button-background-color);border:none;border-radius:0;color:var(--fides-overlay-secondary-button-text-color);margin:0;padding-left:1.5rem;text-align:left;width:100%}button.fides-banner-button.fides-menu-item[aria-pressed=true]{background:var(--fides-overlay-primary-button-background-color);color:var(--fides-overlay-primary-button-text-color)}button.fides-banner-button.fides-menu-item[aria-pressed=true]:before{content:"\2713";display:inline-block;margin-left:-1rem;margin-right:.25rem}button.fides-banner-button.fides-menu-item:not([aria-pressed=true]):hover{background:var(--fides-overlay-secondary-button-background-hover-color)}@media (min-width:768px){div#fides-banner{border:1px solid var(--fides-overlay-primary-color);border-radius:var(--fides-overlay-component-border-radius);width:75%}div#fides-banner-container.fides-banner-bottom{bottom:var(--fides-overlay-banner-offset)}}@media (min-width:1280px){div#fides-banner{width:60%}}@media (max-width:768px){div#fides-banner{padding:24px;width:100%}div#fides-banner-description{margin-bottom:0}div#fides-banner-inner div#fides-button-group{align-items:flex-start;flex-direction:column;gap:12px;padding-top:24px}.fides-banner-button-group{flex-direction:column;width:100%}button.fides-banner-button{margin:0;width:100%}div#fides-banner-inner-container{max-height:50vh;overflow-y:auto;scrollbar-gutter:stable}div.fides-privacy-policy-link{width:100%}.fides-modal-footer{max-width:100%}.fides-banner-secondary-actions{gap:12px}.fides-banner-secondary-actions .fides-manage-preferences-button{order:0}.fides-banner-secondary-actions .fides-privacy-policy{order:1}.fides-banner-secondary-actions .fides-i18n-menu{order:2}.fides-banner-button-group.fides-button-group-i18n{min-height:68px}.fides-i18n-menu{bottom:var(--fides-overlay-padding);left:var(--fides-overlay-padding);position:absolute}}</style><style type="text/css">:root{--fides-overlay-tcf-p-h:40px;--fides-overlay-tcf-banner-col-gap:36px;--fides-overlay-tcf-banner-row-gap:16px;--fides-overlay-tcf-banner-btn-w:180px;--fides-overlay-tcf-banner-btn-p-h:10px;--fides-overlay-tcf-banner-purpose-p:12px;--fides-overlay-tcf-banner-purpose-p-t:8px}.fides-tcf-banner-container div#fides-banner div#fides-banner-inner div#fides-button-group{gap:12px}.fides-tcf-banner-container #fides-banner{border-radius:0;border-width:1px 0 0;padding-inline:var(--fides-overlay-tcf-p-h);width:100%}div#fides-banner-inner-container{display:flex;flex-direction:row;gap:var(--fides-overlay-tcf-banner-col-gap)}.fides-banner__col{display:flex;flex:1;flex-direction:column;gap:var(--fides-overlay-tcf-banner-row-gap)}.fides-tcf-banner-container .fides-banner__content{margin-bottom:0;max-height:25vh;overflow-y:auto;scrollbar-gutter:stable}.fides-banner-description{margin-top:var(--fides-overlay-tcf-banner-purpose-p-t)}.fides-banner__purpose-list{list-style:none;margin:0;padding:0}.fides-banner__purpose-item{border-bottom:1px solid var(--fides-overlay-row-divider-color);padding:var(--fides-overlay-tcf-banner-purpose-p);padding-top:var(--fides-overlay-tcf-banner-purpose-p-t)}.fides-vendor-count{font-weight:600}.fides-tcf-banner-container div#fides-banner-inner div#fides-button-group{margin-top:var(--fides-overlay-tcf-banner-row-gap)}.fides-tcf-banner-container .fides-banner-secondary-actions{gap:calc(24px - var(--fides-overlay-link-h-padding) - var(--fides-overlay-link-h-padding))}.fides-tcf-banner-container .fides-banner-button{line-height:20px;margin-top:unset;padding-bottom:var(--fides-overlay-tcf-banner-btn-p-h);padding-top:var(--fides-overlay-tcf-banner-btn-p-h)}.fides-record-header{border-bottom:1px solid var(--fides-overlay-row-divider-color);font-weight:600;padding:12px}.fides-tcf-toggle-content{font-size:var(--fides-overlay-font-size-body-small);font-weight:400;margin-right:60px}.fides-tcf-purpose-vendor-title{display:flex;font-weight:600;justify-content:space-between}.fides-tcf-illustration{font-size:var(--fides-overlay-font-size-body-small);padding:13px 60px 13px 13px}.fides-tcf-illustration,.fides-tcf-purpose-vendor{border-radius:var(--fides-overlay-component-border-radius)}.fides-tcf-purpose-vendor{padding:13px}.fides-tcf-purpose-vendor-list{font-weight:400;list-style:none;margin-bottom:0;margin-left:0;padding-left:0}.fides-tcf-vendor-toggles{display:flex}@media (min-width:1080px){.fides-tcf-banner-container .fides-banner-button{min-width:var(--fides-overlay-tcf-banner-btn-w)}}@media (min-width:768px){div#fides-banner-container.fides-banner-bottom.fides-tcf-banner-container{bottom:0}}@media (max-width:768px){.fides-tcf-banner-container div#fides-banner div#fides-banner-inner div#fides-button-group .fides-banner-button-group{padding-left:0}.fides-tcf-banner-container #fides-banner{padding:var(--fides-overlay-padding)}div#fides-banner-inner-container{flex-direction:column;margin-inline:calc(var(--fides-overlay-padding)*-1);padding-inline:var(--fides-overlay-padding)}.fides-tcf-banner-container .fides-banner__content{margin-top:unset;max-height:unset;overflow-y:unset;scrollbar-gutter:unset}.fides-tcf-banner-container .fides-banner-button-group.fides-button-group-i18n{min-height:unset}.fides-tcf-banner-container .fides-i18n-menu{bottom:unset;left:unset;order:unset;position:unset}.fides-tcf-banner-container .fides-banner-secondary-actions{flex-direction:row}.fides-tcf-banner-container .fides-banner-secondary-actions .fides-privacy-policy{order:unset;width:unset}}@media (min-width:2240px){.fides-tcf-banner-container #fides-banner{border-width:1px 1px 0;margin:0 auto;max-width:2240px}}</style><style>.df-clearing-box {
    background: lightgrey;
    padding: 0 10px;
    position: fixed;
    float: left;
    left: 50%;
    top: 50%;
    transform: translate(-50%, -50%);
    font-size: 20px;
}
</style><script type="text/javascript" charset="utf-8" src="https://prism.app-us1.com?a=609693706&amp;u=https%3A%2F%2Fwww.excel-university.com%2Ffour-ways-to-select-every-other-row-in-excel%2F" async=""></script><script type="text/javascript" charset="utf-8" src="https://trackcmp.net/t_prism_sitemessages.php?trackid=609693706&amp;prismid=b461080e-1416-4441-ba70-bef7fbca6205&amp;url=https%3A%2F%2Fwww.excel-university.com%2Ffour-ways-to-select-every-other-row-in-excel%2F" async=""></script><style data-styled="active" data-styled-version="6.1.12"></style><script type="text/javascript" src="https://scripts.grow.me/app.1.8.46.js" defer="" data-grow-headless-beta-name="1.8.46" data-grow-headless-beta-version="1.8.46" data-grow-mediavine-site-id="90c9c716-2077-4635-acb4-ae593654be54"></script><style hs-beacon="active" data-styled-version="5.1.1"></style><script src="https://btloader.com/tag?o=5161256536244224&amp;domain=www.excel-university.com&amp;upapi=true" async=""></script></head>
<body class="post-template-default single single-post postid-21967 single-format-standard fl-builder-2-8-4-1 fl-themer-1-4-11-2 fl-theme-1-7-16 fl-theme-builder-footer fl-theme-builder-footer-footer fl-theme-builder-singular fl-theme-builder-singular-individual-blog-post fl-theme-builder-header fl-theme-builder-header-header-with-grey-bar fl-framework-bootstrap fl-preset-default fl-full-width fl-has-sidebar has-blocks fl-builder-breakpoint-medium mv-loaded mv-device-desktop" itemscope="itemscope" itemtype="https://schema.org/WebPage" style="overflow: visible !important; height: 100%;">

<noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M8T7N66"
height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>
<a aria-label="Skip to content" class="fl-screen-reader-text" href="#fl-main-content">Skip to content</a><div class="fl-page" style="padding-top: 0px; overflow: visible !important;">
<header class="fl-builder-content fl-builder-content-13428 fl-builder-global-templates-locked" data-post-id="13428" data-type="header" data-sticky="1" data-sticky-on="" data-sticky-breakpoint="medium" data-shrink="1" data-overlay="1" data-overlay-bg="transparent" data-shrink-image-height="50px" role="banner" itemscope="itemscope" itemtype="http://schema.org/WPHeader"><div class="fl-row fl-row-full-width fl-row-bg-color fl-node-5ee10b07b5126 fl-row-default-height fl-row-align-center" data-node="5ee10b07b5126">
<div class="fl-row-content-wrap">
<div class="fl-row-content fl-row-fixed-width fl-node-content">
<div class="fl-col-group fl-node-5ee10b07bb431 fl-col-group-custom-width" data-node="5ee10b07bb431">
<div class="fl-col fl-node-5ee93991602fc fl-col-bg-color fl-col-small-custom-width" data-node="5ee93991602fc">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-rich-text fl-node-5f10fce8cf276" data-node="5f10fce8cf276">
<div class="fl-module-content fl-node-content">
<div class="fl-rich-text">
<p style="text-align: right;"><a href="https://www.excel-university.com/buy-now/">Buy Now</a></p>
</div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5ee10b07bb560 fl-col-bg-color fl-col-small fl-col-small-custom-width" data-node="5ee10b07bb560">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-html fl-node-5ee939916017d secondary_nav" data-node="5ee939916017d">
<div class="fl-module-content fl-node-content">
<div class="fl-html">
<a class="secondary_nav" href="https://store.excel-university.com/" title="Store">&nbsp;&nbsp;&nbsp;&nbsp;<i class="fas fa-store fa-lg"></i></a><a class="secondary_nav" href="https://campus.excel-university.com/login/" title="Login">&nbsp;&nbsp;&nbsp;&nbsp;<i class="fas fa-user fa-lg"></i></a><a class="secondary_nav" href="https://store.excel-university.com/cart?action=viewcart" title="Cart">&nbsp;&nbsp;&nbsp;&nbsp;<i class="fas fa-shopping-cart fa-lg"></i></a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="fl-row fl-row-full-width fl-row-bg-color fl-node-5eb1a130a47b3 fl-row-default-height fl-row-align-center" data-node="5eb1a130a47b3">
<div class="fl-row-content-wrap">
<div class="fl-row-content fl-row-fixed-width fl-node-content">
<div class="fl-col-group fl-node-5ed6917dac4d6" data-node="5ed6917dac4d6">
<div class="fl-col fl-node-5ed6917dac67b fl-col-bg-color fl-col-has-cols" data-node="5ed6917dac67b">
<div class="fl-col-content fl-node-content">
<div class="fl-col-group fl-node-5ed691b76be37 fl-col-group-nested fl-col-group-equal-height fl-col-group-align-center fl-col-group-custom-width" data-node="5ed691b76be37">
<div class="fl-col fl-node-5ed691b76beed fl-col-bg-color fl-col-small fl-col-small-custom-width" data-node="5ed691b76beed">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-photo fl-node-5eb1a26f1b48c" data-node="5eb1a26f1b48c">
<div class="fl-module-content fl-node-content">
<div class="fl-photo fl-photo-align-left" itemscope="" itemtype="https://schema.org/ImageObject">
<div class="fl-photo-content fl-photo-img-png">
<a href="https://www.excel-university.com/" target="_self" itemprop="url">
<img decoding="async" class="fl-photo-img wp-image-13423 size-medium" src="https://www.excel-university.com/wp-content/uploads/excel_u_logo_stacked_grey_font-300x90.png" alt="excel_u_logo_stacked_grey_font" itemprop="image" height="90" width="300" title="excel_u_logo_stacked_grey_font" data-no-lazy="1" srcset="https://www.excel-university.com/wp-content/uploads/excel_u_logo_stacked_grey_font-300x90.png 300w, https://www.excel-university.com/wp-content/uploads/excel_u_logo_stacked_grey_font-1024x308.png 1024w, https://www.excel-university.com/wp-content/uploads/excel_u_logo_stacked_grey_font-768x231.png 768w, https://www.excel-university.com/wp-content/uploads/excel_u_logo_stacked_grey_font.png 1128w" sizes="(max-width: 300px) 100vw, 300px">
</a>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5ed691b76bef0 fl-col-bg-color fl-col-small-custom-width" data-node="5ed691b76bef0">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-menu fl-node-5eb1a130a47ce" data-node="5eb1a130a47ce">
<div class="fl-module-content fl-node-content">
<div class="fl-menu fl-menu-responsive-toggle-medium-mobile fl-menu-responsive-flyout-overlay fl-flyout-right">
<button class="fl-menu-mobile-toggle hamburger" aria-label="Menu"><span class="fl-menu-icon svg-container"><svg version="1.1" class="hamburger-menu" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" viewBox="0 0 512 512">
<rect class="fl-hamburger-menu-top" width="512" height="102"></rect>
<rect class="fl-hamburger-menu-middle" y="205" width="512" height="102"></rect>
<rect class="fl-hamburger-menu-bottom" y="410" width="512" height="102"></rect>
</svg>
</span></button> <div class="fl-clear"></div>
<nav aria-label="Menu" itemscope="itemscope" itemtype="https://schema.org/SiteNavigationElement"><div class="fl-menu-mobile-flyout"><button class="fl-menu-mobile-close" aria-label="Close"><i class="fas fa-times" aria-hidden="true"></i></button><ul id="menu-main-menu" class="menu fl-menu-horizontal fl-toggle-arrows"><li id="menu-item-12834" class="menu-item menu-item-type-post_type menu-item-object-page"><a href="https://www.excel-university.com/start-here/">Start Here</a></li><li id="menu-item-378" class="menu-item menu-item-type-post_type menu-item-object-page"><a href="https://www.excel-university.com/training/">Training</a></li><li id="menu-item-13689" class="menu-item menu-item-type-post_type_archive menu-item-object-articles"><a href="https://www.excel-university.com/articles/">Publications</a></li><li id="menu-item-362" class="menu-item menu-item-type-post_type menu-item-object-page current_page_parent"><a href="https://www.excel-university.com/blog/">Blog</a></li></ul></div></nav></div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5ed691b76bef2 fl-col-bg-color fl-col-small" data-node="5ed691b76bef2">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-button fl-node-5ebd8a8bbb13c" data-node="5ebd8a8bbb13c">
<div class="fl-module-content fl-node-content">
<div class="fl-button-wrap fl-button-width-auto fl-button-right">
<a href="/free-gift/" target="_self" class="fl-button">
<span class="fl-button-text">FREE GIFT</span>
</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</header><div class="uabb-js-breakpoint" style="display: none;"></div> <div id="fl-main-content" class="fl-page-content" itemprop="mainContentOfPage" role="main" style="overflow: visible !important;">
<div class="fl-builder-content fl-builder-content-13087 fl-builder-global-templates-locked" data-post-id="13087" style="overflow: visible !important;"><div class="fl-row fl-row-full-width fl-row-bg-photo fl-node-5ed6bc0dd671f fl-row-default-height fl-row-align-center" data-node="5ed6bc0dd671f" style="overflow: visible !important;">
<div class="fl-row-content-wrap" style="overflow: visible !important;">
<div class="fl-row-content fl-row-fixed-width fl-node-content" style="overflow: visible !important;">
<div class="fl-col-group fl-node-5ed6bc0dd6724" data-node="5ed6bc0dd6724" style="overflow: visible !important;">
<div class="fl-col fl-node-5ed6bc0dd6725 fl-col-bg-color" data-node="5ed6bc0dd6725" style="overflow: visible !important;">
<div class="fl-col-content fl-node-content" style="overflow: visible !important;"><div class="fl-module fl-module-heading fl-node-5ed6bc0dd6727" data-node="5ed6bc0dd6727">
<div class="fl-module-content fl-node-content">
<h1 class="fl-heading">
<span class="fl-heading-text">Four Ways to Select Every Other Row in Excel</span>
</h1>
</div>
</div>
<div class="fl-module fl-module-fl-post-info fl-node-5ed6bc0dd6729" data-node="5ed6bc0dd6729">
<div class="fl-module-content fl-node-content">
<span class="fl-post-info-author"><a href="https://www.excel-university.com/author/excel-writer/">Excel University</a></span><span class="fl-post-info-sep">|</span><span class="fl-post-info-date">January 3, 2023</span><span class="fl-post-info-sep">|</span><span class="fl-post-info-comments"><a href="https://www.excel-university.com/four-ways-to-select-every-other-row-in-excel/#comments" tabindex="-1" aria-hidden="true">4 Comments</a></span><span class="fl-post-info-sep">|</span><span class="fl-post-info-terms"><a href="https://www.excel-university.com/tag/filters/" rel="tag" class="filters">Filters</a>, <a href="https://www.excel-university.com/tag/goto/" rel="tag" class="goto">GoTo</a>, <a href="https://www.excel-university.com/tag/tables/" rel="tag" class="tables">Tables</a>, <a href="https://www.excel-university.com/tag/vba/" rel="tag" class="vba">VBA</a></span> </div>
</div>
<div class="fl-module fl-module-fl-post-content fl-node-5ed6bc0dd6726" data-node="5ed6bc0dd6726" data-content-ads-inserted="true" style="overflow: visible !important;" data-slot-rendered-content="true">
<div class="fl-module-content fl-node-content" style="overflow: visible !important;">
<figure class="wp-block-image size-full"><img decoding="async" width="676" height="350" src="https://www.excel-university.com/wp-content/uploads/how-to-select-every-other-row-in-excel.jpg" alt="Women holding her glasses up close to a computer screen and reading about how to select every other row in Excel" class="wp-image-21970" srcset="https://www.excel-university.com/wp-content/uploads/how-to-select-every-other-row-in-excel.jpg 676w, https://www.excel-university.com/wp-content/uploads/how-to-select-every-other-row-in-excel-300x155.jpg 300w" sizes="(max-width: 676px) 100vw, 676px"></figure>
<p>Selecting every other row in Excel can be helpful. Aside from making it easy to get rid of duplicate rows, it can also be a great way to highlight important information, make the data easier to read with formatting, and more. </p>
<p data-slot-rendered-content="true">However … if you’ve ever tried to select every other row in Excel, you know that there’s no straightforward way to do so. Here are four easy (and quick) ways to do it with a bit of guidance for when to use each method!</p>
<div class="mv-ad-box" data-slotid="content_btf" style="height: 440px; width: max(300px, 100%); overflow: visible !important;"><div class="mv-rail-frame-440" data-slotid="content_btf" style="overflow: visible !important;"><div class="mv-rail-slide-440" data-slotid="content_btf" style="overflow: visible !important;"><div class="mv-rail-sticky-440" data-slotid="content_btf"><div id="content_btf_wrapper" class="adunitwrapper content_btf_wrapper" data-wrapper="content_btf" data-nosnippet="">
          <div id="content_btf" class="content_btf adunit">
            
          </div>
        </div></div></div></div>
  
        
    
<mv-ad-reporter data-slot-id="content_btf" data-offering="1" data-offering-name="mediavine" data-offering-domain="mediavine.com"></mv-ad-reporter></div>

<h2 class="wp-block-heading">1. Use the Ctrl button to manually select rows</h2>
<p>If your worksheet doesn’t have many rows, holding down the <strong>Ctrl</strong> key on your keyboard while selecting the desired rows in your spreadsheet is probably the simplest way to select every other row.</p>
<figure class="wp-block-image is-resized"><img decoding="async" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20385%20251'%3E%3C/svg%3E" alt="Table with colors, model numbers, and availability" width="385" height="251" data-lazy-src="https://lh6.googleusercontent.com/MKdxUziDy7Tj3mm9bdXlozrHq79nMAoxBvX6_9ThQoCBhoRKPVKhGY28JJriR9-y_XQtyY8f_-hFhX5BmluxM2CSZTvSSYvEHh2ZoHs4zNERcD0fJEiIGXNuaaFyBcFRc47aHPd1V3CxTj39ZjLS9L-nMHL2aKowuy8A2DLgYTzNGLV8HXLBzIAMrZ_QLg"><noscript><img decoding="async" src="https://lh6.googleusercontent.com/MKdxUziDy7Tj3mm9bdXlozrHq79nMAoxBvX6_9ThQoCBhoRKPVKhGY28JJriR9-y_XQtyY8f_-hFhX5BmluxM2CSZTvSSYvEHh2ZoHs4zNERcD0fJEiIGXNuaaFyBcFRc47aHPd1V3CxTj39ZjLS9L-nMHL2aKowuy8A2DLgYTzNGLV8HXLBzIAMrZ_QLg" alt="Table with colors, model numbers, and availability" width="385" height="251"/></noscript></figure>
<p>When you click on the row number, the entire row will be highlighted. You can then hold down the <strong>Ctrl </strong>key and continue to select additional rows. This type of cell selection is called a non-contiguous range.</p>
<p>While it’s easy, it isn’t necessarily practical if you have lots of rows. Manually selecting rows can take a lot of time and leaves room for error. If you have many rows, the remaining options may be a better fit.</p>
<h2 class="wp-block-heading">2. Format alternating rows with a Table</h2>
<p>If your goal is to have a different format for alternating rows for cosmetic purposes, or to make your data easier to read, then a table is an easy option.</p>
<p>1. Select any cell in your data range.</p>
<p>2. Select <strong>Insert &gt; Table</strong></p>
<p>3. Excel will apply a default format, which includes a different format for alternating rows.</p>
<figure class="wp-block-image size-full" data-slot-rendered-content="true"><img decoding="async" width="409" height="301" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20409%20301'%3E%3C/svg%3E" alt="" class="wp-image-22259" data-lazy-srcset="https://www.excel-university.com/wp-content/uploads/20230104a.png 409w, https://www.excel-university.com/wp-content/uploads/20230104a-300x221.png 300w" data-lazy-sizes="(max-width: 409px) 100vw, 409px" data-lazy-src="https://www.excel-university.com/wp-content/uploads/20230104a.png"><noscript><img decoding="async" width="409" height="301" src="https://www.excel-university.com/wp-content/uploads/20230104a.png" alt="" class="wp-image-22259" srcset="https://www.excel-university.com/wp-content/uploads/20230104a.png 409w, https://www.excel-university.com/wp-content/uploads/20230104a-300x221.png 300w" sizes="(max-width: 409px) 100vw, 409px" /></noscript></figure>
<div class="mv-ad-box" data-slotid="content_2_btf" style="height: 440px; width: max(300px, 100%); overflow: visible !important;"><div class="mv-rail-frame-440" data-slotid="content_2_btf" style="overflow: visible !important;"><div class="mv-rail-slide-440" data-slotid="content_2_btf" style="overflow: visible !important;"><div class="mv-rail-sticky-440" data-slotid="content_2_btf"><div id="content_2_btf_wrapper" class="adunitwrapper content_btf_wrapper" data-wrapper="content_2_btf" data-nosnippet="">
          <div id="content_2_btf" class="content_btf adunit">
            
          </div>
        </div></div></div></div>
  
        
    
<mv-ad-reporter data-slot-id="content_2_btf" data-offering="1" data-offering-name="mediavine" data-offering-domain="mediavine.com"></mv-ad-reporter></div>

<p>This option is called Banded Rows, and you can toggle that on/off by using the <strong>Table Design &gt; Banded Rows</strong> checkbox.</p>
<p>You can also select various table styles by using the <strong>Table Design &gt; Table Styles</strong> gallery.</p>
<h2 class="wp-block-heading">3. Use a helper column with the Go-To Special command</h2>
<p>If your goal is to delete every other row, a helper column that uses alternating values is a good option. You can see an example of such a helper column in the screenshot below.</p>
<figure class="wp-block-image is-resized"><img decoding="async" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20410%20196'%3E%3C/svg%3E" alt="Table with colors, model numbers, and availability" width="410" height="196" data-lazy-src="https://lh4.googleusercontent.com/I1x2zht6MQ0X2iKUSkVGz9TsTID3HveOK_k9Yg_YIEIk8sKbCx0mk4H9YAeFqR8JNZWG_CzU2ozYfU-ETly7pmrJ_usRpymIeaXW56CE2Syt75UuqxNlYbEY6Iys72JEfwZreiLVUiROwufdIon1NmUc-Q6Iy2DC-QXVftrxqp0CrwT4g4p55aP54SlLOQ"><noscript><img decoding="async" src="https://lh4.googleusercontent.com/I1x2zht6MQ0X2iKUSkVGz9TsTID3HveOK_k9Yg_YIEIk8sKbCx0mk4H9YAeFqR8JNZWG_CzU2ozYfU-ETly7pmrJ_usRpymIeaXW56CE2Syt75UuqxNlYbEY6Iys72JEfwZreiLVUiROwufdIon1NmUc-Q6Iy2DC-QXVftrxqp0CrwT4g4p55aP54SlLOQ" alt="Table with colors, model numbers, and availability" width="410" height="196"/></noscript></figure>
<p>1. Prepare a helper column that alternates between two different values. In the above example, every other row in the helper column contains the number 1 or 2. You can also use the <a href="https://www.excel-university.com/save-time-using-the-microsoft-excel-fill-handle/">fill handle</a> to speed up the process of filling the alternating values down. Enter the first two values, 1 and 2, and then select those cells. Hold down the <strong>Ctrl </strong>key and drag the fill handle down. Excel will repeat 1 and 2 all the way down.</p>
<p>2. Select the first cell in the helper column and then extend the selection all the way down the column.</p>
<p>3. On the <strong>Home</strong> ribbon item, click <strong>Find &amp; Select</strong>, then <strong>Go-To Special</strong>, and choose <strong>Column Differences</strong>.</p>
<figure class="wp-block-image is-resized" data-slot-rendered-content="true"><img decoding="async" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20410%20210'%3E%3C/svg%3E" alt="Table with colors, model numbers, availability, nd a helper column to help select every other row in Excel" width="410" height="210" data-lazy-src="https://lh4.googleusercontent.com/WLpiudSoDeIP_sC0U2ZtIQsj3zVav35YrY6pDoMfY0Na9jA5Vp3FS-BcRDGFdkDuC97e-qWqMKcWgv5rLJb-wtuT6b0YxvpOe4COvISIYWW1dRmHu_jPW0oDn60vQ9bg6zPANayrKTQUS4doSG5AO7xMQphcdWFmwtRc55Xvd7X7pD2HD-gqSzVtiEK0Xw"><noscript><img decoding="async" src="https://lh4.googleusercontent.com/WLpiudSoDeIP_sC0U2ZtIQsj3zVav35YrY6pDoMfY0Na9jA5Vp3FS-BcRDGFdkDuC97e-qWqMKcWgv5rLJb-wtuT6b0YxvpOe4COvISIYWW1dRmHu_jPW0oDn60vQ9bg6zPANayrKTQUS4doSG5AO7xMQphcdWFmwtRc55Xvd7X7pD2HD-gqSzVtiEK0Xw" alt="Table with colors, model numbers, availability, nd a helper column to help select every other row in Excel" width="410" height="210"/></noscript></figure>
<div class="mv-ad-box" data-slotid="content_3_btf" style="height: 440px; width: max(300px, 100%); overflow: visible !important;"><div class="mv-rail-frame-440" data-slotid="content_3_btf" style="overflow: visible !important;"><div class="mv-rail-slide-440" data-slotid="content_3_btf" style="overflow: visible !important;"><div class="mv-rail-sticky-440" data-slotid="content_3_btf"><div id="content_3_btf_wrapper" class="adunitwrapper content_btf_wrapper" data-wrapper="content_3_btf" data-nosnippet="">
          <div id="content_3_btf" class="content_btf adunit">
            
          </div>
        </div></div></div></div>
  
        
    
<mv-ad-reporter data-slot-id="content_3_btf" data-offering="1" data-offering-name="mediavine" data-offering-domain="mediavine.com"></mv-ad-reporter></div>

<p>This will select all values in the column that are different than the active cell, which is typically the first cell you click when you drag to select an entire range. (You can press Tab to move the active cell within a selected range.)</p>
<p>Once every other cell in that column is selected, you can right-click any of the selected cells and select <strong>Delete</strong>. In the resulting dialog, select <strong>Entire row</strong> to delete every other row in your dataset.</p>
<h2 class="wp-block-heading">4. Use filters to select every other row in Excel</h2>
<p>If you want to select the entire row (instead of just the helper column cells as in the previous option), this method will work well. Excel’s ability to filter rows is useful when you want to view certain sections of data, but it also provides a quick way to select every other row.</p>
<p>1. Just as you did in the example above, prepare a helper column that alternates between two different values.</p>
<p>2. Select the entire range, go to the <strong>Data</strong> ribbon item, and click the<strong> Filter</strong> button.</p>
<p>3. Choose a filter for the helper column that shows the alternating rows you’d like to select.</p>
<p>4. If you want your selection to include only the data cells, select the entire filtered range. If you want your selection to include the entire row, select all rows that span the filtered data. Selecting filtered rows (or cells) actually selects both the visible and the hidden rows. </p>
<p>5. Click <strong>Go-To Special</strong> and select the <strong>Visible cells only</strong>.</p>
<p>This will change the selection to include only the rows that are showing, and deselect the hidden/filtered rows.&nbsp;</p>
<p data-slot-rendered-content="true">You can then click the <strong>Filter </strong>control (drop-down) for the helper column (the one with the active filter) and clear the filter for that specific column. Now, every other row should be selected.&nbsp;</p>
<div class="mv-ad-box" data-slotid="content_4_btf" style="height: 440px; width: max(300px, 100%); overflow: visible !important;"><div class="mv-rail-frame-440" data-slotid="content_4_btf" style="overflow: visible !important;"><div class="mv-rail-slide-440" data-slotid="content_4_btf" style="overflow: visible !important;"><div class="mv-rail-sticky-440" data-slotid="content_4_btf"><div id="content_4_btf_wrapper" class="adunitwrapper content_btf_wrapper" data-wrapper="content_4_btf" data-nosnippet="">
          <div id="content_4_btf" class="content_btf adunit">
            
          </div>
        </div></div></div></div>
  
        
    
<mv-ad-reporter data-slot-id="content_4_btf" data-offering="1" data-offering-name="mediavine" data-offering-domain="mediavine.com"></mv-ad-reporter></div>

<p>Note: don’t remove the filter controls by clicking Data &gt; Filter or the Data &gt; Clear buttons. Instead, select the filter control (the little drop-down) for the helper column and clear that specific column filter.</p>
<h2 class="wp-block-heading">Bonus: select the entire row with VBA</h2>
<p>As a bonus, here is a snippet of VBA code you can swipe to select every other row.</p>
<p>1. Select any span of rows.</p>
<p>2. Open the VBA Editor using the shortcut <strong>Alt + F11</strong>. Select <strong>New Module</strong>, and copy/paste this code:</p>
<pre class="wp-block-preformatted">Sub AlternateRows() 
  Dim Rng As Range 
  r_start = Selection.Row 
  r_end = Selection.Rows.Count + r_start - 1 
  Set Rng = Rows(r_start) 
  r_start = r_start + 2 
  For r = r_start To r_end Step 2 
    Set Rng = Union(Rng, Rows(r)) 
  Next r 
  Rng.Select 
End Sub</pre>
<p><em>Note that it’s always a good idea to back up your work and test VBA code before applying them to important Excel files. VBA is powerful, so you don’t want to risk messing up your workbooks.</em></p>
<p>3. Select <strong>View</strong>, then <strong>Macros</strong>, and<strong> Run</strong>.</p>
<p>This will select every other row within the original selected range. </p>
<p>If you want to more practice with VBA, check out our post on <a href="https://www.excel-university.com/make-your-spreadsheets-faster-using-microsoft-excel-macros/">Microsoft Excel macros</a> to learn about recording macros, editing VBA codes, and running them in Excel.</p>
<hr class="wp-block-separator has-alpha-channel-opacity">
<p>Do you have any other quick ways to select every other row in Excel? Let us know in the comments!</p>
</div>

<div class="mv-ad-box" data-slotid="content_5_btf" style="height: 440px; width: max(300px, 100%); overflow: visible !important;"><div class="mv-rail-frame-440" data-slotid="content_5_btf" style="overflow: visible !important;"><div class="mv-rail-slide-440" data-slotid="content_5_btf" style="overflow: visible !important;"><div class="mv-rail-sticky-440" data-slotid="content_5_btf"><div id="content_5_btf_wrapper" class="adunitwrapper content_btf_wrapper" data-wrapper="content_5_btf" data-nosnippet="">
          <div id="content_5_btf" class="content_btf adunit">
            
          </div>
        </div></div></div></div>
  
        
    
<mv-ad-reporter data-slot-id="content_5_btf" data-offering="1" data-offering-name="mediavine" data-offering-domain="mediavine.com"></mv-ad-reporter></div>
</div>
<div class="fl-module fl-module-separator fl-node-5ed6bc0dd672b" data-node="5ed6bc0dd672b">
<div class="fl-module-content fl-node-content">
<div class="fl-separator"></div>
</div>
</div>
<div class="fl-module fl-module-uabb-social-share fl-node-60102f381abae" data-node="60102f381abae">
<div class="fl-module-content fl-node-content">
<div class="uabb-social-share-wrap uabb-social-share-horizontal uabb-ss uabb-ss-column-auto uabb-ss-column-medium- uabb-ss-column-responsive-">
<div class="uabb-social-share-link-wrap"><a class="uabb-social-share-link uabb-social-share-1" href="https://www.facebook.com/sharer.php?u=https%3A%2F%2Fwww.excel-university.com%2Ffour-ways-to-select-every-other-row-in-excel%2F" target="_blank" onclick="window.open(this.href,'social-share','left=20,top=20,width=500,height=500,toolbar=1,resizable=0');return false;"><div class="uabb-module-content uabb-imgicon-wrap"> <span class="uabb-icon-wrap">
<span class="uabb-icon">
<i class="ua-icon ua-icon-facebook-with-circle"></i>
</span>
</span>
</div></a></div><div class="uabb-social-share-link-wrap"><a class="uabb-social-share-link uabb-social-share-2" href="https://www.linkedin.com/shareArticle?url=https%3A%2F%2Fwww.excel-university.com%2Ffour-ways-to-select-every-other-row-in-excel%2F" target="_blank" onclick="window.open(this.href,'social-share','left=20,top=20,width=500,height=500,toolbar=1,resizable=0');return false;"><div class="uabb-module-content uabb-imgicon-wrap"> <span class="uabb-icon-wrap">
<span class="uabb-icon">
<i class="fi-social-linkedin"></i>
</span>
</span>
</div></a></div><div class="uabb-social-share-link-wrap"><a class="uabb-social-share-link uabb-social-share-3" href="mailto:?body=https%3A%2F%2Fwww.excel-university.com%2Ffour-ways-to-select-every-other-row-in-excel%2F" target="_self"><div class="uabb-module-content uabb-imgicon-wrap"> <span class="uabb-icon-wrap">
<span class="uabb-icon">
<i class="ua-icon ua-icon-email"></i>
</span>
</span>
</div></a></div><div class="uabb-social-share-link-wrap"><a class="uabb-social-share-link uabb-social-share-4" href="https://twitter.com/share?url=https%3A%2F%2Fwww.excel-university.com%2Ffour-ways-to-select-every-other-row-in-excel%2F" target="_blank" onclick="window.open(this.href,'social-share','left=20,top=20,width=500,height=500,toolbar=1,resizable=0');return false;"><div class="uabb-module-content uabb-imgicon-wrap"> <span class="uabb-icon-wrap">
<span class="uabb-icon">
<i class="ua-icon ua-icon-twitter2"></i>
</span>
</span>
</div></a></div></div>
</div>
</div>
<div class="fl-module fl-module-separator fl-node-60102f29b75ae" data-node="60102f29b75ae">
<div class="fl-module-content fl-node-content">
<div class="fl-separator"></div>
</div>
</div>
<div class="fl-module fl-module-html fl-node-5ed6bc0dd672f" data-node="5ed6bc0dd672f">
<div class="fl-module-content fl-node-content">
<div class="fl-html">
Posted in <a href="https://www.excel-university.com/category/excel/" rel="tag" class="excel">Excel</a>, <a href="https://www.excel-university.com/category/features/" rel="tag" class="features">Features</a>, <a href="https://www.excel-university.com/category/functions/" rel="tag" class="functions">Functions</a>, <a href="https://www.excel-university.com/category/keyboard-shortcuts/" rel="tag" class="keyboard-shortcuts">Keyboard Shortcuts</a>, <a href="https://www.excel-university.com/category/vba/" rel="tag" class="vba">VBA</a></div>
</div>
</div>
<div class="fl-module fl-module-fl-post-navigation fl-node-5ed6bc0dd672d" data-node="5ed6bc0dd672d">
<div class="fl-module-content fl-node-content">
<nav class="navigation post-navigation" aria-label="Posts">
<h2 class="screen-reader-text">Posts navigation</h2>
<div class="nav-links"><div class="nav-previous"><a href="https://www.excel-university.com/skipping-excel-3/" rel="prev">← Skipping Excel 3</a></div><div class="nav-next"><a href="https://www.excel-university.com/how-to-square-a-number-in-excel/" rel="next">How to Square a Number in Excel →</a></div></div>
</nav> </div>
</div>
<div class="fl-module fl-module-separator fl-node-5ed6bc0dd672e" data-node="5ed6bc0dd672e">
<div class="fl-module-content fl-node-content">
<div class="fl-separator"></div>
</div>
</div>
<div class="fl-module fl-module-fl-author-bio fl-node-5ed6bc0dd672c" data-node="5ed6bc0dd672c">
<div class="fl-module-content fl-node-content">
<div class="fl-author-bio-thumb">
<img alt="Avatar photo" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20100%20100'%3E%3C/svg%3E" data-lazy-srcset="https://www.excel-university.com/wp-content/uploads/cropped-Excel_u-logo_for_Favicon-200x200.png 2x" class="avatar avatar-100 photo" height="100" width="100" decoding="async" data-lazy-src="https://www.excel-university.com/wp-content/uploads/cropped-Excel_u-logo_for_Favicon-100x100.png"><noscript><img alt='Avatar photo' src='https://www.excel-university.com/wp-content/uploads/cropped-Excel_u-logo_for_Favicon-100x100.png' srcset='https://www.excel-university.com/wp-content/uploads/cropped-Excel_u-logo_for_Favicon-200x200.png 2x' class='avatar avatar-100 photo' height='100' width='100' decoding='async'/></noscript></div>
<div class="fl-author-bio-content">
<h3 class="fl-author-bio-name">Excel University</h3>
<div class="fl-author-bio-text">We love sharing the things we've learned about Excel, and we built Excel University to help us do that. Our motto is: Learn Excel. Work Faster.</div>
</div>
</div>
</div>
<div class="fl-module fl-module-separator fl-node-5f11ab406591e" data-node="5f11ab406591e">
<div class="fl-module-content fl-node-content">
<div class="fl-separator"></div>
</div>
</div>
<div class="fl-module fl-module-cta fl-node-60bfd9aaa71a0" data-node="60bfd9aaa71a0">
<div class="fl-module-content fl-node-content">
<div class="fl-cta-wrap fl-cta-inline">
<div class="fl-cta-text">
<h3 class="fl-cta-title">Excel is not what it used to be.</h3>
<div class="fl-cta-text-content"><p>You need the <strong>Excel Proficiency Roadmap</strong> now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.</p>
</div>
</div>
<div class="fl-cta-button">
<div class="fl-button-wrap fl-button-width-full">
<a href="https://www.excel-university.com/roadmap/" target="_self" class="fl-button">
<span class="fl-button-text">Free Roadmap</span>
</a>
</div>
</div>
</div>
</div>
</div>
<div class="fl-module fl-module-separator fl-node-5f11ab48bb945" data-node="5f11ab48bb945">
<div class="fl-module-content fl-node-content">
<div class="fl-separator"></div>
</div>
</div>
<div class="fl-module fl-module-cta fl-node-5f7352b405234" data-node="5f7352b405234">
<div class="fl-module-content fl-node-content">
<div class="fl-cta-wrap fl-cta-inline">
<div class="fl-cta-text">
<h3 class="fl-cta-title">Want to learn Excel?</h3>
<div class="fl-cta-text-content"><p>Our training programs start at $29 and will help you learn Excel quickly.</p>
</div>
</div>
<div class="fl-cta-button">
<div class="fl-button-wrap fl-button-width-full">
<a href="/training-passes" target="_self" class="fl-button">
<span class="fl-button-text">Training Info</span>
</a>
</div>
</div>
</div>
</div>
</div>
<div class="fl-module fl-module-separator fl-node-5f7351a957dba" data-node="5f7351a957dba">
<div class="fl-module-content fl-node-content">
<div class="fl-separator"></div>
</div>
</div>
<div class="fl-module fl-module-fl-comments fl-node-5ed6bc0dd6728" data-node="5ed6bc0dd6728">
<div class="fl-module-content fl-node-content">
<div class="fl-comments">
<div class="fl-comments-list">
<h2 class="fl-comments-list-title">
4 Comments </h2>
<ol id="comments">
<li class="comment even thread-even depth-1" id="li-comment-18228">
<div id="comment-18228" class="comment-body clearfix">
<div class="comment-meta">
<span class="comment-avatar">
<img alt="" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2080%2080'%3E%3C/svg%3E" data-lazy-srcset="https://secure.gravatar.com/avatar/2153d226b995e0822e7cc2d1152498b0?s=160&amp;d=mm&amp;r=g 2x" class="avatar avatar-80 photo" height="80" width="80" decoding="async" data-lazy-src="https://secure.gravatar.com/avatar/2153d226b995e0822e7cc2d1152498b0?s=80&amp;d=mm&amp;r=g"><noscript><img alt='' src='https://secure.gravatar.com/avatar/2153d226b995e0822e7cc2d1152498b0?s=80&#038;d=mm&#038;r=g' srcset='https://secure.gravatar.com/avatar/2153d226b995e0822e7cc2d1152498b0?s=160&#038;d=mm&#038;r=g 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/></noscript> </span>
<span class="comment-author-link">B. Helsel</span> <span class="comment-date">on January 4, 2023 at 10:34 am</span>
</div>
<div class="comment-content clearfix">
<p>I don’t know if this tip necessarily fits with your theme, but I use conditional formatting to highlight every other row. This formula can be easily modified to highlight evens, odds, or multiples.</p>
<p>Highlight the range of cells that you want to apply banding and use this rule:<br>
MOD(ROW(),2)=0</p>
<p>Even rows: ISEVEN9ROW())<br>
Odd rows: isodd(row())</p>
<p>I hope this proves to be useful.</p>
</div>
<div class="comment-reply-link"><a rel="nofollow" class="comment-reply-link" href="#comment-18228" data-commentid="18228" data-postid="21967" data-belowelement="comment-18228" data-respondelement="respond" data-replyto="Reply to B. Helsel" aria-label="Reply to B. Helsel">Reply</a></div>
</div>
<ul class="children">
<li class="comment byuser comment-author-jefflenning odd alt depth-2" id="li-comment-18229">
<div id="comment-18229" class="comment-body clearfix">
<div class="comment-meta">
<span class="comment-avatar">
<img alt="" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2080%2080'%3E%3C/svg%3E" data-lazy-srcset="https://secure.gravatar.com/avatar/3b86b26e27593bdc39076c158688cef8?s=160&amp;d=mm&amp;r=g 2x" class="avatar avatar-80 photo" height="80" width="80" decoding="async" data-lazy-src="https://secure.gravatar.com/avatar/3b86b26e27593bdc39076c158688cef8?s=80&amp;d=mm&amp;r=g"><noscript><img alt='' src='https://secure.gravatar.com/avatar/3b86b26e27593bdc39076c158688cef8?s=80&#038;d=mm&#038;r=g' srcset='https://secure.gravatar.com/avatar/3b86b26e27593bdc39076c158688cef8?s=160&#038;d=mm&#038;r=g 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/></noscript> </span>
<span class="comment-author-link"><a href="https://www.excel-university.com" class="url" rel="ugc">Jeff Lenning</a></span> <span class="comment-date">on January 4, 2023 at 11:02 am</span>
</div>
<div class="comment-content clearfix">
<p>This is great, thank you for sharing 🙂</p>
</div>
<div class="comment-reply-link"><a rel="nofollow" class="comment-reply-link" href="#comment-18229" data-commentid="18229" data-postid="21967" data-belowelement="comment-18229" data-respondelement="respond" data-replyto="Reply to Jeff Lenning" aria-label="Reply to Jeff Lenning">Reply</a></div>
</div>
</li>
<li class="comment even depth-2" id="li-comment-18239">
<div id="comment-18239" class="comment-body clearfix">
<div class="comment-meta">
<span class="comment-avatar">
<img alt="" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2080%2080'%3E%3C/svg%3E" data-lazy-srcset="https://secure.gravatar.com/avatar/c3507ecf350ad9d2bfb67c01d341a204?s=160&amp;d=mm&amp;r=g 2x" class="avatar avatar-80 photo" height="80" width="80" decoding="async" data-lazy-src="https://secure.gravatar.com/avatar/c3507ecf350ad9d2bfb67c01d341a204?s=80&amp;d=mm&amp;r=g"><noscript><img alt='' src='https://secure.gravatar.com/avatar/c3507ecf350ad9d2bfb67c01d341a204?s=80&#038;d=mm&#038;r=g' srcset='https://secure.gravatar.com/avatar/c3507ecf350ad9d2bfb67c01d341a204?s=160&#038;d=mm&#038;r=g 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/></noscript> </span>
<span class="comment-author-link">J. Renton</span> <span class="comment-date">on January 5, 2023 at 3:52 am</span>
</div>
<div class="comment-content clearfix">
<p>Agreed. This is how I highlight alternate rows, as well. What I see the most from beginner to mid-level Excel users is that conditional formatting is woefully underutilized.</p>
<p>For dynamic row reports, you can add value checks so that only rows with data in a particular column are highlighted. For example, applying the following conditional format to 50 rows where only 10 rows currently have data and Column A is the determination for highlighting</p>
<p>=AND(LEN($A1)&gt;0,MOD(ROW(),2)=0)</p>
<p>will result in rows 2, 4, 6, 8, and 10 to be highlighted but the remaining rows will have no highlighting. However, when you add more data in additional rows, the highlighting will automatically take effect on the additional rows.</p>
<p>Changing the formula to<br>
=AND(LEN($A1)&gt;0,MOD(ROW(),2)0)<br>
will highlight rows 1, 3, 5, 7 and 9.</p>
<p>Using conditional formatting is nothing more than having an understanding of what makes something TRUE or FALSE.</p>
</div>
<div class="comment-reply-link"><a rel="nofollow" class="comment-reply-link" href="#comment-18239" data-commentid="18239" data-postid="21967" data-belowelement="comment-18239" data-respondelement="respond" data-replyto="Reply to J. Renton" aria-label="Reply to J. Renton">Reply</a></div>
</div>
</li>
</ul>
</li>
<li class="comment odd alt thread-odd thread-alt depth-1" id="li-comment-18247">
<div id="comment-18247" class="comment-body clearfix">
<div class="comment-meta">
<span class="comment-avatar">
<img alt="" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%2080%2080'%3E%3C/svg%3E" data-lazy-srcset="https://secure.gravatar.com/avatar/2153d226b995e0822e7cc2d1152498b0?s=160&amp;d=mm&amp;r=g 2x" class="avatar avatar-80 photo" height="80" width="80" decoding="async" data-lazy-src="https://secure.gravatar.com/avatar/2153d226b995e0822e7cc2d1152498b0?s=80&amp;d=mm&amp;r=g"><noscript><img alt='' src='https://secure.gravatar.com/avatar/2153d226b995e0822e7cc2d1152498b0?s=80&#038;d=mm&#038;r=g' srcset='https://secure.gravatar.com/avatar/2153d226b995e0822e7cc2d1152498b0?s=160&#038;d=mm&#038;r=g 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/></noscript> </span>
<span class="comment-author-link">B. Helsel</span> <span class="comment-date">on January 6, 2023 at 8:56 am</span>
</div>
<div class="comment-content clearfix">
<p>I noticed that my post had a typo: Even rows: ISEVEN9ROW()), should be ISEVEN(ROW()). Excel – endless possibilities.</p>
</div>
<div class="comment-reply-link"><a rel="nofollow" class="comment-reply-link" href="#comment-18247" data-commentid="18247" data-postid="21967" data-belowelement="comment-18247" data-respondelement="respond" data-replyto="Reply to B. Helsel" aria-label="Reply to B. Helsel">Reply</a></div>
</div>
</li>
</ol>
</div>
<div id="respond" class="comment-respond">
<h3 id="reply-title" class="comment-reply-title">Leave a Comment <small><a rel="nofollow" id="cancel-comment-reply-link" href="/four-ways-to-select-every-other-row-in-excel/#respond" style="display:none;">Cancel Reply</a></small></h3><form action="https://www.excel-university.com/wp-comments-post.php" method="post" id="fl-comment-form" class="fl-comment-form"><label for="fl-comment">Comment</label><textarea autocomplete="new-password" id="comment" name="c80e79af34" class="form-control" cols="60" rows="8"></textarea><textarea id="a89b67ebbeba398683c6a7e564154429" aria-label="hp-comment" aria-hidden="true" name="comment" autocomplete="new-password" style="padding:0 !important;clip:rect(1px, 1px, 1px, 1px) !important;position:absolute !important;white-space:nowrap !important;height:1px !important;width:1px !important;overflow:hidden !important;" tabindex="-1"></textarea><script data-noptimize="">document.getElementById("comment").setAttribute( "id", "a89b67ebbeba398683c6a7e564154429" );document.getElementById("c80e79af34").setAttribute( "id", "comment" );</script><br><label for="fl-author">Name (required)</label>
<input type="text" id="fl-author" name="author" class="form-control" value="" aria-required="true"><br>
<label for="fl-email">Email (will not be published) (required)</label>
<input type="text" id="fl-email" name="email" class="form-control" value="" aria-required="true"><br>
<label for="fl-url">Website</label>
<input type="text" id="fl-url" name="url" class="form-control" value=""><br>
<p class="comment-subscription-form"><input type="checkbox" name="subscribe_comments" id="subscribe_comments" value="subscribe" style="width: auto; -moz-appearance: checkbox; -webkit-appearance: checkbox;"> <label class="subscribe-label" id="subscribe-label" for="subscribe_comments">Notify me of follow-up comments by email.</label></p><p class="form-submit"><input name="submit" type="submit" id="fl-comment-form-submit" class="btn btn-primary" value="Submit Comment"> <input type="hidden" name="comment_post_ID" value="21967" id="comment_post_ID">
<input type="hidden" name="comment_parent" id="comment_parent" value="0">
</p></form> </div>
</div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5ee9243d564f4 fl-col-bg-color fl-col-small" data-node="5ee9243d564f4">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-widget fl-node-5efcd67ab057d" data-node="5efcd67ab057d">
<div class="fl-module-content fl-node-content">
<div class="fl-widget">
<div class="widget widget_search"><form aria-label="Search" method="get" role="search" action="https://www.excel-university.com/" title="Type and press Enter to search.">
<input aria-label="Search" type="search" class="fl-search-input form-control" name="s" placeholder="Search" value="" onfocus="if (this.value === 'Search') { this.value = ''; }" onblur="if (this.value === '') this.value='Search';">
</form>
</div></div>
</div>
</div>
<div class="fl-module fl-module-icon fl-node-5ee9243d48ac9" data-node="5ee9243d48ac9">
<div class="fl-module-content fl-node-content">
<div class="fl-icon-wrap">
<span class="fl-icon">
<a href="https://store.excel-university.com" target="_self" tabindex="-1" aria-hidden="true" aria-labelledby="fl-icon-text-5ee9243d48ac9">
<i class="ua-icon ua-icon-minus" aria-hidden="true"></i>
</a>
</span>
<div id="fl-icon-text-5ee9243d48ac9" class="fl-icon-text">
<a href="https://store.excel-university.com" target="_self" class="fl-icon-text-link fl-icon-text-wrap">
<h5>Training Programs</h5> </a>
</div>
</div>
</div>
</div>
<div class="fl-module fl-module-icon fl-node-5ee9243d48acb" data-node="5ee9243d48acb">
<div class="fl-module-content fl-node-content">
<div class="fl-icon-wrap">
<span class="fl-icon">
<a href="https://www.excel-university.com/learn-excel-free/" target="_self" tabindex="-1" aria-hidden="true" aria-labelledby="fl-icon-text-5ee9243d48acb">
<i class="ua-icon ua-icon-minus" aria-hidden="true"></i>
</a>
</span>
<div id="fl-icon-text-5ee9243d48acb" class="fl-icon-text">
<a href="https://www.excel-university.com/learn-excel-free/" target="_self" class="fl-icon-text-link fl-icon-text-wrap">
<h5>Free Resources</h5> </a>
</div>
</div>
</div>
</div>
<div class="fl-module fl-module-mailchimp-subscribe-form fl-node-5ee9243d48abb" data-node="5ee9243d48abb">
<div class="fl-module-content fl-node-content">
<div class="uabb-module-content uabb-subscribe-form uabb-subscribe-form-stacked uabb-sf-style-style1 uabb-form fl-clearfix" data-template-id="5ee9243d3b964" data-template-node-id="5ee9243d48abb">
<div class="uabb-head-wrap">
<h3 class="uabb-sf-heading">Learn by Email</h3>
<h6 class="uabb-sf-subheading">Subscribe to Blog (free)</h6>
</div>
<div class="uabb-form-wrap fl-clearfix" data-nonce="89fc8f40de">
<div class="uabb-form-field">
<input type="text" name="uabb-subscribe-form-fname" id="uabb-subscribe-form-fname" aria-label="fname" placeholder="Your Name">
<div class="uabb-form-error-message">!</div>
</div>
<div class="uabb-form-field">
<input type="email" name="uabb-subscribe-form-email" aria-label="email" placeholder="Your Email">
<div class="uabb-form-error-message">!</div>
</div> <div class="uabb-form-button" data-wait-text="Please Wait...">
<div class="uabb-module-content uabb-button-wrap uabb-creative-button-wrap uabb-button-width-auto uabb-creative-button-width-auto uabb-button-left uabb-creative-button-left uabb-button-reponsive-left uabb-creative-button-reponsive-left">
<a href="#" title="Click Here" target="_self" class="uabb-button ast-button uabb-creative-button uabb-creative-default-btn   " role="button" aria-label="Subscribe">
<span class="uabb-button-text uabb-creative-button-text">Subscribe</span>
</a>
</div>
</div>
</div>
<div class="uabb-form-error-message">Something went wrong. Please check your entries and try again.</div>
</div>
</div>
</div>
<div class="fl-module fl-module-widget fl-node-5ee9243d48acf" data-node="5ee9243d48acf">
<div class="fl-module-content fl-node-content">
<div class="fl-widget">
<div class="widget widget_tag_cloud"><h2 class="widgettitle">Topics</h2><div class="tagcloud"><a href="https://www.excel-university.com/tag/battle/" class="tag-cloud-link tag-link-177 tag-link-position-1" style="font-size: 11.92523364486pt;" aria-label="Battle (11 items)">Battle</a>
<a href="https://www.excel-university.com/tag/breakout/" class="tag-cloud-link tag-link-148 tag-link-position-2" style="font-size: 10.224299065421pt;" aria-label="Breakout (8 items)">Breakout</a>
<a href="https://www.excel-university.com/tag/chart/" class="tag-cloud-link tag-link-122 tag-link-position-3" style="font-size: 9.5700934579439pt;" aria-label="Chart (7 items)">Chart</a>
<a href="https://www.excel-university.com/tag/chatgpt/" class="tag-cloud-link tag-link-230 tag-link-position-4" style="font-size: 9.5700934579439pt;" aria-label="ChatGPT (7 items)">ChatGPT</a>
<a href="https://www.excel-university.com/tag/choose/" class="tag-cloud-link tag-link-41 tag-link-position-5" style="font-size: 8.9158878504673pt;" aria-label="CHOOSE (6 items)">CHOOSE</a>
<a href="https://www.excel-university.com/tag/comparison-formulas/" class="tag-cloud-link tag-link-37 tag-link-position-6" style="font-size: 8pt;" aria-label="Comparison Formulas (5 items)">Comparison Formulas</a>
<a href="https://www.excel-university.com/tag/concat/" class="tag-cloud-link tag-link-151 tag-link-position-7" style="font-size: 8.9158878504673pt;" aria-label="CONCAT (6 items)">CONCAT</a>
<a href="https://www.excel-university.com/tag/concatenate/" class="tag-cloud-link tag-link-106 tag-link-position-8" style="font-size: 10.224299065421pt;" aria-label="CONCATENATE (8 items)">CONCATENATE</a>
<a href="https://www.excel-university.com/tag/conditional-formatting/" class="tag-cloud-link tag-link-35 tag-link-position-9" style="font-size: 18.336448598131pt;" aria-label="Conditional Formatting (36 items)">Conditional Formatting</a>
<a href="https://www.excel-university.com/tag/countifs/" class="tag-cloud-link tag-link-154 tag-link-position-10" style="font-size: 11.401869158879pt;" aria-label="COUNTIFS (10 items)">COUNTIFS</a>
<a href="https://www.excel-university.com/tag/data-model/" class="tag-cloud-link tag-link-156 tag-link-position-11" style="font-size: 12.317757009346pt;" aria-label="Data Model (12 items)">Data Model</a>
<a href="https://www.excel-university.com/tag/data-validation/" class="tag-cloud-link tag-link-36 tag-link-position-12" style="font-size: 15.85046728972pt;" aria-label="Data Validation (23 items)">Data Validation</a>
<a href="https://www.excel-university.com/tag/dynamic-arrays/" class="tag-cloud-link tag-link-171 tag-link-position-13" style="font-size: 12.841121495327pt;" aria-label="Dynamic Arrays (13 items)">Dynamic Arrays</a>
<a href="https://www.excel-university.com/tag/eomonth/" class="tag-cloud-link tag-link-81 tag-link-position-14" style="font-size: 10.224299065421pt;" aria-label="EOMONTH (8 items)">EOMONTH</a>
<a href="https://www.excel-university.com/tag/filter/" class="tag-cloud-link tag-link-173 tag-link-position-15" style="font-size: 14.803738317757pt;" aria-label="FILTER (19 items)">FILTER</a>
<a href="https://www.excel-university.com/tag/filters/" class="tag-cloud-link tag-link-138 tag-link-position-16" style="font-size: 8.9158878504673pt;" aria-label="Filters (6 items)">Filters</a>
<a href="https://www.excel-university.com/tag/flashfill/" class="tag-cloud-link tag-link-43 tag-link-position-17" style="font-size: 9.5700934579439pt;" aria-label="FlashFill (7 items)">FlashFill</a>
<a href="https://www.excel-university.com/tag/format/" class="tag-cloud-link tag-link-129 tag-link-position-18" style="font-size: 9.5700934579439pt;" aria-label="Format (7 items)">Format</a>
<a href="https://www.excel-university.com/tag/get-transform/" class="tag-cloud-link tag-link-145 tag-link-position-19" style="font-size: 18.205607476636pt;" aria-label="Get &amp; Transform (35 items)">Get &amp; Transform</a>
<a href="https://www.excel-university.com/tag/hacks/" class="tag-cloud-link tag-link-153 tag-link-position-20" style="font-size: 11.401869158879pt;" aria-label="Hacks (10 items)">Hacks</a>
<a href="https://www.excel-university.com/tag/hyperlink/" class="tag-cloud-link tag-link-83 tag-link-position-21" style="font-size: 10.224299065421pt;" aria-label="Hyperlink (8 items)">Hyperlink</a>
<a href="https://www.excel-university.com/tag/iferror/" class="tag-cloud-link tag-link-103 tag-link-position-22" style="font-size: 8.9158878504673pt;" aria-label="IFERROR (6 items)">IFERROR</a>
<a href="https://www.excel-university.com/tag/index/" class="tag-cloud-link tag-link-47 tag-link-position-23" style="font-size: 13.88785046729pt;" aria-label="INDEX (16 items)">INDEX</a>
<a href="https://www.excel-university.com/tag/indirect/" class="tag-cloud-link tag-link-125 tag-link-position-24" style="font-size: 9.5700934579439pt;" aria-label="INDIRECT (7 items)">INDIRECT</a>
<a href="https://www.excel-university.com/tag/macro/" class="tag-cloud-link tag-link-140 tag-link-position-25" style="font-size: 10.878504672897pt;" aria-label="Macro (9 items)">Macro</a>
<a href="https://www.excel-university.com/tag/match/" class="tag-cloud-link tag-link-48 tag-link-position-26" style="font-size: 14.280373831776pt;" aria-label="MATCH (17 items)">MATCH</a>
<a href="https://www.excel-university.com/tag/named-ranges/" class="tag-cloud-link tag-link-73 tag-link-position-27" style="font-size: 10.878504672897pt;" aria-label="Named Ranges (9 items)">Named Ranges</a>
<a href="https://www.excel-university.com/tag/named-references/" class="tag-cloud-link tag-link-74 tag-link-position-28" style="font-size: 11.401869158879pt;" aria-label="Named References (10 items)">Named References</a>
<a href="https://www.excel-university.com/tag/names/" class="tag-cloud-link tag-link-75 tag-link-position-29" style="font-size: 8pt;" aria-label="Names (5 items)">Names</a>
<a href="https://www.excel-university.com/tag/pivottable/" class="tag-cloud-link tag-link-67 tag-link-position-30" style="font-size: 20.299065420561pt;" aria-label="PivotTable (52 items)">PivotTable</a>
<a href="https://www.excel-university.com/tag/power-pivot/" class="tag-cloud-link tag-link-155 tag-link-position-31" style="font-size: 12.841121495327pt;" aria-label="Power Pivot (13 items)">Power Pivot</a>
<a href="https://www.excel-university.com/tag/power-query/" class="tag-cloud-link tag-link-144 tag-link-position-32" style="font-size: 22pt;" aria-label="Power Query (69 items)">Power Query</a>
<a href="https://www.excel-university.com/tag/sequence/" class="tag-cloud-link tag-link-174 tag-link-position-33" style="font-size: 12.841121495327pt;" aria-label="SEQUENCE (13 items)">SEQUENCE</a>
<a href="https://www.excel-university.com/tag/sort/" class="tag-cloud-link tag-link-141 tag-link-position-34" style="font-size: 8.9158878504673pt;" aria-label="Sort (6 items)">Sort</a>
<a href="https://www.excel-university.com/tag/spill/" class="tag-cloud-link tag-link-170 tag-link-position-35" style="font-size: 11.401869158879pt;" aria-label="Spill (10 items)">Spill</a>
<a href="https://www.excel-university.com/tag/subtotal/" class="tag-cloud-link tag-link-98 tag-link-position-36" style="font-size: 8.9158878504673pt;" aria-label="SUBTOTAL (6 items)">SUBTOTAL</a>
<a href="https://www.excel-university.com/tag/sumifs/" class="tag-cloud-link tag-link-80 tag-link-position-37" style="font-size: 18.990654205607pt;" aria-label="SUMIFS (41 items)">SUMIFS</a>
<a href="https://www.excel-university.com/tag/tables/" class="tag-cloud-link tag-link-107 tag-link-position-38" style="font-size: 17.158878504673pt;" aria-label="Tables (29 items)">Tables</a>
<a href="https://www.excel-university.com/tag/text/" class="tag-cloud-link tag-link-115 tag-link-position-39" style="font-size: 9.5700934579439pt;" aria-label="TEXT (7 items)">TEXT</a>
<a href="https://www.excel-university.com/tag/textjoin/" class="tag-cloud-link tag-link-152 tag-link-position-40" style="font-size: 9.5700934579439pt;" aria-label="TEXTJOIN (7 items)">TEXTJOIN</a>
<a href="https://www.excel-university.com/tag/unique/" class="tag-cloud-link tag-link-172 tag-link-position-41" style="font-size: 11.92523364486pt;" aria-label="UNIQUE (11 items)">UNIQUE</a>
<a href="https://www.excel-university.com/tag/vlookup/" class="tag-cloud-link tag-link-33 tag-link-position-42" style="font-size: 20.691588785047pt;" aria-label="VLOOKUP (55 items)">VLOOKUP</a>
<a href="https://www.excel-university.com/tag/vstack/" class="tag-cloud-link tag-link-207 tag-link-position-43" style="font-size: 8.9158878504673pt;" aria-label="VSTACK (6 items)">VSTACK</a>
<a href="https://www.excel-university.com/tag/worksheet-protection/" class="tag-cloud-link tag-link-86 tag-link-position-44" style="font-size: 8pt;" aria-label="worksheet protection (5 items)">worksheet protection</a>
<a href="https://www.excel-university.com/tag/xlookup/" class="tag-cloud-link tag-link-178 tag-link-position-45" style="font-size: 15.327102803738pt;" aria-label="XLOOKUP (21 items)">XLOOKUP</a></div>
</div></div>
</div>
</div>
<div class="fl-module fl-module-widget fl-node-5ee9243d48ace" data-node="5ee9243d48ace">
<div class="fl-module-content fl-node-content">
<div class="fl-widget">
<div class="widget widget_categories"><h2 class="widgettitle">Categories</h2>
<ul>
<li class="cat-item cat-item-76"><a href="https://www.excel-university.com/category/add-ins/">Add-Ins</a> (34)
</li>
<li class="cat-item cat-item-25"><a href="https://www.excel-university.com/category/excel/">Excel</a> (424)
</li>
<li class="cat-item cat-item-42"><a href="https://www.excel-university.com/category/features/">Features</a> (234)
</li>
<li class="cat-item cat-item-40"><a href="https://www.excel-university.com/category/functions/">Functions</a> (213)
</li>
<li class="cat-item cat-item-34"><a href="https://www.excel-university.com/category/keyboard-shortcuts/">Keyboard Shortcuts</a> (25)
</li>
<li class="cat-item cat-item-52"><a href="https://www.excel-university.com/category/techniques/">Techniques</a> (76)
</li>
<li class="cat-item cat-item-49"><a href="https://www.excel-university.com/category/training/">Training</a> (46)
</li>
<li class="cat-item cat-item-77"><a href="https://www.excel-university.com/category/vba/">VBA</a> (15)
</li>
</ul>
</div></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div><div class="uabb-js-breakpoint" style="display: none;"></div>
</div>
<footer class="fl-builder-content fl-builder-content-12452 fl-builder-global-templates-locked" data-post-id="12452" data-type="footer" itemscope="itemscope" itemtype="http://schema.org/WPFooter"><div class="fl-row fl-row-full-width fl-row-bg-color fl-node-5eb18b4f2a5c6 fl-row-default-height fl-row-align-center" data-node="5eb18b4f2a5c6">
<div class="fl-row-content-wrap">
<div class="fl-row-content fl-row-fixed-width fl-node-content">
<div class="fl-col-group fl-node-5eb18b4f2a5c7 fl-col-group-equal-height fl-col-group-align-top fl-col-group-custom-width" data-node="5eb18b4f2a5c7">
<div class="fl-col fl-node-5eb18b4f2a5cc fl-col-bg-color fl-col-small fl-col-small-custom-width" data-node="5eb18b4f2a5cc">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-heading fl-node-5eb18b4f2a5de" data-node="5eb18b4f2a5de">
<div class="fl-module-content fl-node-content">
<h3 class="fl-heading">
<span class="fl-heading-text">About</span>
</h3>
</div>
</div>
<div class="fl-module fl-module-rich-text fl-node-5eb18c70d30ec" data-node="5eb18c70d30ec">
<div class="fl-module-content fl-node-content">
<div class="fl-rich-text">
<p><a href="/university-preview/">About Us</a></p>
<p><a href="https://help.excel-university.com">Docs</a></p>
<p><a href="/instructors/">Instructor List</a></p>
<p><a href="/testimonials/">Testimonials</a></p>
<p><a href="/scholarship/">Scholarship</a></p>
<p><a href="/sponsor/">Advertising</a></p>
<p><a href="/affiliate/">Affiliate Program</a></p>
<p><a href="/privacy-policy/">Privacy Policy</a></p>
</div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5eb18bb343671 fl-col-bg-color fl-col-small fl-col-small-custom-width" data-node="5eb18bb343671">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-heading fl-node-5eb18b4f2a5d8" data-node="5eb18b4f2a5d8">
<div class="fl-module-content fl-node-content">
<h3 class="fl-heading">
<span class="fl-heading-text">Connect</span>
</h3>
</div>
</div>
<div class="fl-module fl-module-rich-text fl-node-5eb18b4f2a5d9" data-node="5eb18b4f2a5d9">
<div class="fl-module-content fl-node-content">
<div class="fl-rich-text">
<p><a href="https://www.linkedin.com/in/jefflenning/">LinkedIn</a></p>
<p><a href="https://www.youtube.com/c/exceluniversityinc">YouTube</a></p>
<p><a href="https://www.facebook.com/exceluniversityinc">Facebook</a></p>
<p><a href="https://www.instagram.com/exceluniversity/">Instagram</a></p>
<p><a href="https://twitter.com/exceluniversity">X</a></p>
<p><a href="/blog/">Blog</a></p>
<p><a href="/media">Media</a></p>
</div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5eb18b4f2a5ca fl-col-bg-color fl-col-small fl-col-small-custom-width" data-node="5eb18b4f2a5ca">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-heading fl-node-5eb18bafeebf7" data-node="5eb18bafeebf7">
<div class="fl-module-content fl-node-content">
<h3 class="fl-heading">
<span class="fl-heading-text">Training</span>
</h3>
</div>
</div>
<div class="fl-module fl-module-rich-text fl-node-5eb18bbb4995e" data-node="5eb18bbb4995e">
<div class="fl-module-content fl-node-content">
<div class="fl-rich-text">
<p><a href="https://store.excel-university.com">Course List</a></p>
<p><a href="https://campus.excel-university.com/my/">Student Login</a></p>
<p><a href="/courses/">For CPAs</a></p>
<p><a href="/campus-pass/">For Individuals</a></p>
<p><a href="/online-group-excel-training/">For Groups</a></p>
<p><a href="/excel-content-for-accounting-information-systems-or-other-college-course/">For College Professors</a></p>
<p><a href="/speedloop/">Speed Loop</a></p>
<p>&nbsp;</p>
</div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5ed0516765c06 fl-col-bg-color fl-col-small fl-col-small-custom-width" data-node="5ed0516765c06">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-heading fl-node-5ed0515f31364" data-node="5ed0515f31364">
<div class="fl-module-content fl-node-content">
<h3 class="fl-heading">
<span class="fl-heading-text">Related</span>
</h3>
</div>
</div>
<div class="fl-module fl-module-rich-text fl-node-5ed05169e324e" data-node="5ed05169e324e">
<div class="fl-module-content fl-node-content">
<div class="fl-rich-text">
<p><a href="https://www.mrexcel.com/board/">Excel Forum</a></p>
<p><a href="https://jooble.org/jobs-microsoft-excel">Excel Jobs</a></p>
<p><a href="https://www.excel-university.com/consultants/">Excel Consulting</a></p>
<p><a href="/book/">Excel Books</a></p>
<p><a href="/coaching/">Excel Coaching</a></p>
<p><a href="/learn-excel-free/">Free Resources</a></p>
</div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5eb18b4f2a5c9 fl-col-bg-color fl-col-small fl-col-small-custom-width" data-node="5eb18b4f2a5c9">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-heading fl-node-5eb18b4f2a5dd" data-node="5eb18b4f2a5dd">
<div class="fl-module-content fl-node-content">
<h3 class="fl-heading">
<span class="fl-heading-text">Contact</span>
</h3>
</div>
</div>
<div class="fl-module fl-module-rich-text fl-node-5eb18b4f2a5ce" data-node="5eb18b4f2a5ce">
<div class="fl-module-content fl-node-content">
<div class="fl-rich-text">
<p><a href="/contact/">Contact Form</a></p>
<p><a href="tel:+19492007688">+1 (949) 200-7688</a></p>
<p>[email protected]</p>
<p>Excel University<br>
518 N Cliff Ave #3, Harrisburg, SD 57032</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="fl-row fl-row-full-width fl-row-bg-color fl-node-5eb18b4f2a5b4 fl-row-default-height fl-row-align-center" data-node="5eb18b4f2a5b4">
<div class="fl-row-content-wrap">
<div class="fl-row-content fl-row-fixed-width fl-node-content">
<div class="fl-col-group fl-node-5eb18b4f2a5c0" data-node="5eb18b4f2a5c0">
<div class="fl-col fl-node-5eb18b4f2a5c3 fl-col-bg-color fl-col-has-cols" data-node="5eb18b4f2a5c3">
<div class="fl-col-content fl-node-content">
<div class="fl-col-group fl-node-5ed53fbc68fe2 fl-col-group-nested fl-col-group-equal-height fl-col-group-align-center fl-col-group-custom-width" data-node="5ed53fbc68fe2">
<div class="fl-col fl-node-5ed5401a77525 fl-col-bg-color fl-col-small fl-col-small-custom-width" data-node="5ed5401a77525">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-photo fl-node-5ed5401a7735e" data-node="5ed5401a7735e">
<div class="fl-module-content fl-node-content">
<div class="fl-photo fl-photo-align-center" itemscope="" itemtype="https://schema.org/ImageObject">
<div class="fl-photo-content fl-photo-img-png">
<img decoding="async" class="fl-photo-img wp-image-14095 size-full" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20150%20238'%3E%3C/svg%3E" alt="MVP_Logo_Secondary_dark_grey_RGB_72_footer_150" itemprop="image" height="238" width="150" title="MVP_Logo_Secondary_dark_grey_RGB_72_footer_150" data-lazy-src="https://www.excel-university.com/wp-content/uploads/MVP_Logo_Secondary_dark_grey_RGB_72_footer_150.png"><noscript><img decoding="async" class="fl-photo-img wp-image-14095 size-full" src="https://www.excel-university.com/wp-content/uploads/MVP_Logo_Secondary_dark_grey_RGB_72_footer_150.png" alt="MVP_Logo_Secondary_dark_grey_RGB_72_footer_150" itemprop="image" height="238" width="150" title="MVP_Logo_Secondary_dark_grey_RGB_72_footer_150"  /></noscript>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5ed53fec999a7 fl-col-bg-color fl-col-small fl-col-small-custom-width" data-node="5ed53fec999a7">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-photo fl-node-5ed53fec997d2" data-node="5ed53fec997d2">
<div class="fl-module-content fl-node-content">
<div class="fl-photo fl-photo-align-center" itemscope="" itemtype="https://schema.org/ImageObject">
<div class="fl-photo-content fl-photo-img-png">
<img decoding="async" class="fl-photo-img wp-image-14094 size-full" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20150%2098'%3E%3C/svg%3E" alt="MS_Cert_Trainer_logo_dark_grey_footer_150" itemprop="image" height="98" width="150" title="MS_Cert_Trainer_logo_dark_grey_footer_150" data-lazy-src="https://www.excel-university.com/wp-content/uploads/MS_Cert_Trainer_logo_dark_grey_footer_150.png"><noscript><img decoding="async" class="fl-photo-img wp-image-14094 size-full" src="https://www.excel-university.com/wp-content/uploads/MS_Cert_Trainer_logo_dark_grey_footer_150.png" alt="MS_Cert_Trainer_logo_dark_grey_footer_150" itemprop="image" height="98" width="150" title="MS_Cert_Trainer_logo_dark_grey_footer_150"  /></noscript>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5ed53fbc690f1 fl-col-bg-color fl-col-small fl-col-small-custom-width" data-node="5ed53fbc690f1">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-photo fl-node-5ed53fc3161ec" data-node="5ed53fc3161ec">
<div class="fl-module-content fl-node-content">
<div class="fl-photo fl-photo-align-center" itemscope="" itemtype="https://schema.org/ImageObject">
<div class="fl-photo-content fl-photo-img-png">
<img decoding="async" class="fl-photo-img wp-image-14096 size-full" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20150%20133'%3E%3C/svg%3E" alt="NASBA_CPERegistry_logo_dark_grey_transparent_footer_150" itemprop="image" height="133" width="150" title="NASBA_CPERegistry_logo_dark_grey_transparent_footer_150" data-lazy-src="https://www.excel-university.com/wp-content/uploads/NASBA_CPERegistry_logo_dark_grey_transparent_footer_150.png"><noscript><img decoding="async" class="fl-photo-img wp-image-14096 size-full" src="https://www.excel-university.com/wp-content/uploads/NASBA_CPERegistry_logo_dark_grey_transparent_footer_150.png" alt="NASBA_CPERegistry_logo_dark_grey_transparent_footer_150" itemprop="image" height="133" width="150" title="NASBA_CPERegistry_logo_dark_grey_transparent_footer_150"  /></noscript>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="fl-col fl-node-5ed542a3c043e fl-col-bg-color" data-node="5ed542a3c043e">
<div class="fl-col-content fl-node-content"><div class="fl-module fl-module-rich-text fl-node-5eb18b4f2a5c4" data-node="5eb18b4f2a5c4">
<div class="fl-module-content fl-node-content">
<div class="fl-rich-text">
<p><a href="https://www.excel-university.com/">Excel University</a> | Copyright © 2012-2024 | All rights reserved</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</footer><div class="uabb-js-breakpoint" style="display: none;"></div> </div>
<script id="site_tracking-js-extra">
var php_data = {"ac_settings":{"tracking_actid":609693706,"site_tracking_default":1},"user_email":""};
</script>
<script src="https://stats.wp.com/e-202443.js" id="jetpack-stats-js" data-wp-strategy="defer" data-rocket-defer="" defer=""></script>
<script id="jetpack-stats-js-after">
_stq = window._stq || [];
_stq.push([ "view", JSON.parse("{\"v\":\"ext\",\"blog\":\"179897776\",\"post\":\"21967\",\"tz\":\"-5\",\"srv\":\"www.excel-university.com\",\"j\":\"1:13.9.1\"}") ]);
_stq.push([ "clickTrackerInit", "179897776", "21967" ]);
</script>
<script id="fl-automator-js-extra">
var themeopts = {"medium_breakpoint":"992","mobile_breakpoint":"768","scrollTopPosition":"800"};
</script>
<script>window.lazyLoadOptions=[{elements_selector:"img[data-lazy-src],.rocket-lazyload",data_src:"lazy-src",data_srcset:"lazy-srcset",data_sizes:"lazy-sizes",class_loading:"lazyloading",class_loaded:"lazyloaded",threshold:300,callback_loaded:function(element){if(element.tagName==="IFRAME"&&element.dataset.rocketLazyload=="fitvidscompatible"){if(element.classList.contains("lazyloaded")){if(typeof window.jQuery!="undefined"){if(jQuery.fn.fitVids){jQuery(element).parent().fitVids()}}}}}},{elements_selector:".rocket-lazyload",data_src:"lazy-src",data_srcset:"lazy-srcset",data_sizes:"lazy-sizes",class_loading:"lazyloading",class_loaded:"lazyloaded",threshold:300,}];window.addEventListener('LazyLoad::Initialized',function(e){var lazyLoadInstance=e.detail.instance;if(window.MutationObserver){var observer=new MutationObserver(function(mutations){var image_count=0;var iframe_count=0;var rocketlazy_count=0;mutations.forEach(function(mutation){for(var i=0;i<mutation.addedNodes.length;i++){if(typeof mutation.addedNodes[i].getElementsByTagName!=='function'){continue}
if(typeof mutation.addedNodes[i].getElementsByClassName!=='function'){continue}
images=mutation.addedNodes[i].getElementsByTagName('img');is_image=mutation.addedNodes[i].tagName=="IMG";iframes=mutation.addedNodes[i].getElementsByTagName('iframe');is_iframe=mutation.addedNodes[i].tagName=="IFRAME";rocket_lazy=mutation.addedNodes[i].getElementsByClassName('rocket-lazyload');image_count+=images.length;iframe_count+=iframes.length;rocketlazy_count+=rocket_lazy.length;if(is_image){image_count+=1}
if(is_iframe){iframe_count+=1}}});if(image_count>0||iframe_count>0||rocketlazy_count>0){lazyLoadInstance.update()}});var b=document.getElementsByTagName("body")[0];var config={childList:!0,subtree:!0};observer.observe(b,config)}},!1)</script><script data-no-minify="1" async="" src="https://www.excel-university.com/wp-content/plugins/wp-rocket/assets/js/lazyload/17.8.3/lazyload.min.js"></script><script src="https://www.excel-university.com/wp-content/cache/min/1/469517c3db951cc4d82f382a94b4d0d4.js" data-minify="1" data-rocket-defer="" defer=""></script>

<script type="text/javascript" id="" charset="">(function(a,d,e,f,g,b,c){a.visitorGlobalObjectAlias=f;a[a.visitorGlobalObjectAlias]=a[a.visitorGlobalObjectAlias]||function(){(a[a.visitorGlobalObjectAlias].q=a[a.visitorGlobalObjectAlias].q||[]).push(arguments)};a[a.visitorGlobalObjectAlias].l=(new Date).getTime();b=d.createElement("script");b.src=e;b.async=!0;c=d.getElementsByTagName("script")[0];c.parentNode.insertBefore(b,c)})(window,document,"https://diffuser-cdn.app-us1.com/diffuser/diffuser.js","vgo");vgo("setAccount","609693706");
vgo("setTrackByDefault",!0);vgo("process");</script><script type="text/javascript" id="" charset="">jQuery(document).ready(function(){jQuery(document).bind("gform_confirmation_loaded",function(b,a){window.dataLayer=window.dataLayer||[];window.dataLayer.push({event:"formSubmission",formID:a})})});</script><script type="text/javascript" id="" charset="">function SendUrlToDeadlineFunnel(a){var b="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/\x3d",d=0,k=0,h=[];if(!a)return a;do{var e=a.charCodeAt(d++);var f=a.charCodeAt(d++);var g=a.charCodeAt(d++);var c=e<<16|f<<8|g;e=c>>18&63;f=c>>12&63;g=c>>6&63;c&=63;h[k++]=b.charAt(e)+b.charAt(f)+b.charAt(g)+b.charAt(c)}while(d<a.length);b=h.join("");a=a.length%3;a=(a?b.slice(0,a-3):b)+"\x3d\x3d\x3d".slice(a||3);a=a.replace("+","-");return a=a.replace("/","_")}
var dfUrl=SendUrlToDeadlineFunnel(location.href),dfParentUrlValue;try{dfParentUrlValue=window.parent.location.href}catch(a){"SecurityError"===a.name&&(dfParentUrlValue=document.referrer)}var dfParentUrl=parent!==window?"/"+SendUrlToDeadlineFunnel(dfParentUrlValue):"";
(function(){var a=document.createElement("script");a.type="text/javascript";a.async=!0;a.setAttribute("data-scriptid","dfunifiedcode");a.src="https://a.deadlinefunnel.com/unified/reactunified.bundle.js?userIdHash\x3deyJpdiI6IkFIcXRjNFJxZ2FIY040N1ZhN0FhM1E9PSIsInZhbHVlIjoibVBRTmRKODdnalF5R0Jzci9xUU9UZz09IiwibWFjIjoiZDczYmUyMTE3ZTY2ZThjZGM5MzVlZDJlZmE2Njk2MzA1YTk3NmQyNzU3YTYyODBjN2MzMWRjYTE3ODczMGQ2OSJ9\x26pageFromUrl\x3d"+dfUrl+"\x26parentPageFromUrl\x3d"+dfParentUrl;var b=document.getElementsByTagName("script")[0];
b.parentNode.insertBefore(a,b)})();</script><script type="text/javascript" id="" charset="">!function(b,d,f){function e(){var c=d.getElementsByTagName("script")[0],a=d.createElement("script");a.type="text/javascript";a.async=!0;a.src="https://beacon-v2.helpscout.net";c.parentNode.insertBefore(a,c)}if(b.Beacon=f=function(c,a,g){b.Beacon.readyQueue.push({method:c,options:a,data:g})},f.readyQueue=[],"complete"===d.readyState)return e();b.attachEvent?b.attachEvent("onload",e):b.addEventListener("load",e,!1)}(window,document,window.Beacon||function(){});</script><script type="text/javascript" id="" charset="">window.Beacon("init","ad9087c2-78d7-4d61-9553-60010fcbb878");</script><img src="https://pixel.wp.com/g.gif?v=ext&amp;blog=179897776&amp;post=21967&amp;tz=-5&amp;srv=www.excel-university.com&amp;j=1%3A13.9.1&amp;host=www.excel-university.com&amp;ref=&amp;fcp=1087&amp;rand=0.312740213297626" alt="" width="6" height="5" id="wpstats"><img src="https://t.co/1/i/adsct?bci=4&amp;eci=3&amp;event=%7B%7D&amp;event_id=15c1ec29-cb83-47ed-b58a-4520c51812bc&amp;integration=gtm&amp;p_id=Twitter&amp;p_user_id=0&amp;pl_id=192a30cf-6411-4ef4-b96e-de2d7cd1a614&amp;tw_document_href=https%3A%2F%2Fwww.excel-university.com%2Ffour-ways-to-select-every-other-row-in-excel%2F&amp;tw_iframe_status=0&amp;txn_id=oduuo&amp;type=javascript&amp;version=2.3.30" height="1" width="1" style="display: none;"><img src="https://analytics.twitter.com/1/i/adsct?bci=4&amp;eci=3&amp;event=%7B%7D&amp;event_id=15c1ec29-cb83-47ed-b58a-4520c51812bc&amp;integration=gtm&amp;p_id=Twitter&amp;p_user_id=0&amp;pl_id=192a30cf-6411-4ef4-b96e-de2d7cd1a614&amp;tw_document_href=https%3A%2F%2Fwww.excel-university.com%2Ffour-ways-to-select-every-other-row-in-excel%2F&amp;tw_iframe_status=0&amp;txn_id=oduuo&amp;type=javascript&amp;version=2.3.30" height="1" width="1" style="display: none;"><iframe name="__tcfapiLocator" style="display: none;"></iframe><iframe name="__gppLocator" style="display: none;"></iframe><div data-name="mediavine-gdpr-cmp" data-nosnippet="1"><div class="sc-gJhJTp fsLDHq"><div tabindex="0" class="amc-modal-pre-capture"></div><div color="#41a4a9" view="default" role="dialog" aria-modal="true" aria-labelledby="amc-aria-labelledby" aria-describedby="amc-aria-describedby" class="sc-braxZu kFMVfF amc-modal-container"><div view="default" id="amc-aria-labelledby" class="sc-eJgwjL YjkCT"><div class="sc-czgmHJ LTQSk">Excel University<br>Data and Cookie Consent</div></div><div view="default" id="amc-aria-describedby" class="sc-iCZwEW kUVHAG"><div class="sc-epPVmt cwOEzX">To provide a more personal user experience, we and our <div data-view="partnerSettings" format="inline" class="sc-knesRu clYXSA">215 partners</div> use technology such as cookies to store and/or access device information.
      By clicking “Accept,” you consent to the use of these technologies which will allow us and <div data-view="partnerSettings" format="inline" class="sc-knesRu clYXSA">our partners</div> to process personal data such as IP address, unique ID, and browsing data on this site.</div><div class="sc-epPVmt cwOEzX">To manage your consent preferences, please click on the “Manage Settings” button.
      You can withdraw or update your consent preferences at any time by clicking the 
      “Update Privacy Settings” link at the bottom of the website.</div><div class="sc-epPVmt cwOEzX">We use your data to: Store and/or access information on a device; Use limited data to select advertising; Create profiles for personalized advertising; Use profiles to select personalized advertising; Create profiles to personalize content; Use profiles to select personalized content; Measure advertising performance; Measure content performance; Understand audiences through statistics or combinations of data from different sources; Develop and improve services; Use limited data to select content; Ensure security, prevent and detect fraud, and fix errors; Deliver and present advertising and content; Save and communicate privacy choices.</div></div><div class="sc-jCbFiK bWhiHd"><div view="default" class="sc-dkjaqt bzblAN"><div data-view="manageSettings" format="inverse" view="default" tabindex="0" class="sc-knesRu hmAmwa">Manage Settings</div><div color="#41a4a9" format="primary" view="default" tabindex="0" class="sc-knesRu ePGZca amc-focus-first">Accept</div></div></div></div><div tabindex="0" class="amc-modal-post-capture"></div></div></div><div data-name="mediavine-gdpr-button" data-nosnippet="1"><div class="sc-fQpRED cQCmSE"><div id="mv_privacy_settings" class="sc-dsLQwm iruIiQ">Update Privacy Settings</div></div></div><div id="beacon-container"><div class="hsds-beacon"><div class="Beacon"><div class="ContainerGradient-sc-62zoy-0 dkxqZi"></div><div class="ContainerFramecss__WrapperUI-sc-d7rzhh-0 itSWDc BeaconContainer is-configDisplayRight"></div><div class="FabButtonFramecss__FabButtonFrameUI-sc-y1b4md-0 bbHIsf BeaconFabButtonFrame" style="border-radius: 60px; height: 60px; position: fixed; transform: scale(1); width: 60px; z-index: 1049;"><span class="FabButtonFramecss__FabButtonPulseUI-sc-y1b4md-1 dhhoIq is-visible"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 60 60" preserveAspectRatio="none" aria-hidden="true">
  <path d="M60 30C60 51.25 51.25 60 30 60C8.75 60 1.99634e-09 51.25 1.99563e-09 30C1.99492e-09 8.75 8.75 0 30 0C51.25 0 60 8.75 60 30Z"></path>
</svg>
</span><span class="FabButtonFramecss__FabButtonPulseUI-sc-y1b4md-1 dhhoIq"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 60 60" preserveAspectRatio="none" aria-hidden="true">
  <path d="M60 30C60 51.25 51.25 60 30 60C8.75 60 1.99634e-09 51.25 1.99563e-09 30C1.99492e-09 8.75 8.75 0 30 0C51.25 0 60 8.75 60 30Z"></path>
</svg>
</span><iframe title="Help Scout Beacon - Open" id="" allowtransparency="true" data-cy="FrameComponent"></iframe></div></div></div></div><iframe marginwidth="0" marginheight="0" scrolling="no" frameborder="0" id="10e91781f27cda" width="0" height="0" src="about:blank" name="__pb_locator__" style="display: none; height: 0px; width: 0px; border: 0px;"></iframe><img src="https://ad-delivery.net/px.gif?ch=2" style="display: none !important; width: 1px !important; height: 1px !important;"><img src="https://ad.doubleclick.net/favicon.ico?ad=300x250&amp;ad_box_=1&amp;adnet=1&amp;showad=1&amp;size=250x250" style="display: none !important; width: 1px !important; height: 1px !important;"><img src="https://ad-delivery.net/px.gif?ch=1&amp;e=0.3460528770521021" style="display: none !important; width: 1px !important; height: 1px !important;"></body></html>