{"id":2311,"date":"2021-04-28T18:06:23","date_gmt":"2021-04-28T18:06:23","guid":{"rendered":"http:\/\/marstraining.in\/?p=2311"},"modified":"2021-05-25T04:07:33","modified_gmt":"2021-05-25T04:07:33","slug":"insert-alternate-blank-rows-in-excel","status":"publish","type":"post","link":"https:\/\/marstraining.in\/?p=2311","title":{"rendered":"Insert Alternate Blank Rows In Excel"},"content":{"rendered":"<h2 style=\"text-align: center;\"><strong><u>Insert Alternate Blank Rows in Excel<\/u><\/strong><\/h2>\n<p><strong>\u2018Insert Alternate Blank Rows In Excel\u2019 <\/strong>Inserting Rows &amp; Columns in an Excel spreadsheet is a common thing but in few cases, we need to <strong>insert alternate blank rows in Excel<\/strong>. In this case we may think Macro is the only solution for this but, it is not so. In today\u2019s article, I will teach you\u2019ll the easiest way to add alternate blank rows in Excel. Look at the data in the following picture below where we need to insert alternate blank rows.<\/p>\n<p><a href=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-online.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-medium wp-image-2620 aligncenter\" src=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-online-300x200.jpg\" alt=\"insert alternate blank rows in excel online\" width=\"300\" height=\"200\" srcset=\"https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-online-300x200.jpg 300w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-online-500x333.jpg 500w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-online-600x400.jpg 600w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-online.jpg 750w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Most of the Excel users have been facing severe issues on how to add alternate blank rows in Excel<strong>.<\/strong> Hence, there is no need to write any Macro code for this. Following are the steps required to insert alternative blank rows.<\/p>\n<ol>\n<li>Insert an extra column after the last column. The name of the extra column can be anything. In the given image below I have inserted an extra column named Temp.<\/li>\n<li>Now fill the extra column with numbers. Over here I have filled the Temp field with numbers from 1 to 11.<a href=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-pdf.jpg\"><img decoding=\"async\" class=\"aligncenter wp-image-2621 size-medium\" src=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-pdf-300x200.jpg\" alt=\"\" width=\"300\" height=\"200\" srcset=\"https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-pdf-300x200.jpg 300w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-pdf-500x333.jpg 500w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-pdf-600x400.jpg 600w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-pdf.jpg 750w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<li>Then copy all numbers from D2:D12 and paste after the last filled cell on the same column, that is in D13, refer to the following image for this.<a href=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/how-to-insert-alternate-blank-rows-in-excel-2.jpg\"><img decoding=\"async\" class=\"size-medium wp-image-2623 aligncenter\" src=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/how-to-insert-alternate-blank-rows-in-excel-2-300x200.jpg\" alt=\"how to insert alternate blank rows in excel\" width=\"300\" height=\"200\" srcset=\"https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/how-to-insert-alternate-blank-rows-in-excel-2-300x200.jpg 300w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/how-to-insert-alternate-blank-rows-in-excel-2-500x333.jpg 500w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/how-to-insert-alternate-blank-rows-in-excel-2-600x400.jpg 600w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/how-to-insert-alternate-blank-rows-in-excel-2.jpg 750w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol start=\"4\">\n<li>Then place your cell position anywhere in the Temp column that is the last column and click on the Sort icon (A to Z or Z to A). You can go to the sort icon by clicking on the Data tab and click on Sort &amp; Filter group on the ribbon.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol start=\"5\">\n<li>After clicking on the Sort icon Excel Sheet will look like this.<a href=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-worksheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2618 aligncenter\" src=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-worksheet-300x200.jpg\" alt=\"insert alternate blank rows in excel worksheet\" width=\"300\" height=\"200\" srcset=\"https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-worksheet-300x200.jpg 300w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-worksheet-500x333.jpg 500w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-worksheet-600x400.jpg 600w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-blank-rows-in-excel-worksheet.jpg 750w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol start=\"6\">\n<li>Then delete the extra column, which is the last column (Temp). Now your data will have alternate blank rows. Refer to the below image where we have successfully entered alternate blank rows in the excel file.<a href=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-rows-in-excel.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2619 aligncenter\" src=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-rows-in-excel-300x200.jpg\" alt=\"insert alternate rows in excel\" width=\"300\" height=\"200\" srcset=\"https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-rows-in-excel-300x200.jpg 300w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-rows-in-excel-500x333.jpg 500w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-rows-in-excel-600x400.jpg 600w, https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/insert-alternate-rows-in-excel.jpg 750w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>That\u2019s it! Follow the above-given steps carefully and you will be able to <strong>insert alternate blank rows in excel<\/strong> easily. Hope you enjoyed this article. Feel free to write your comments and queries in the comment box. Stay connected and Win Excel with me.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Insert Alternate Blank Rows in Excel \u2018Insert Alternate Blank Rows In Excel\u2019 Inserting Rows &amp; Columns in an Excel spreadsheet is a common thing but in few cases, we need to insert alternate blank rows in Excel. In this case we may think Macro is the only solution for this but, it is not so. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2624,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"0","ocean_second_sidebar":"0","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"0","ocean_custom_header_template":"0","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"0","ocean_menu_typo_font_family":"0","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"0","_vp_format_video_url":"","_vp_image_focal_point":[],"_joinchat":[],"ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"off","ocean_gallery_id":[],"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2311","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blogs","entry","has-media","owp-thumbs-layout-horizontal","owp-btn-normal","owp-tabs-layout-horizontal","has-no-thumbnails","has-product-nav"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Insert Alternate Blank Rows In Excel - MARStraining<\/title>\n<meta name=\"description\" content=\"Insert alternate blank rows in excel is a serious issue faced by many excel users. This tutorial will teach you the easiest way to do so\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/marstraining.in\/?p=2311\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Insert Alternate Blank Rows In Excel - MARStraining\" \/>\n<meta property=\"og:description\" content=\"Insert alternate blank rows in excel is a serious issue faced by many excel users. This tutorial will teach you the easiest way to do so\" \/>\n<meta property=\"og:url\" content=\"http:\/\/marstraining.in\/?p=2311\" \/>\n<meta property=\"og:site_name\" content=\"MARStraining\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-28T18:06:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-25T04:07:33+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/Insert-Alternate-Blank-Rows-In-Excel-8.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Prof RASHID RIZWI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prof RASHID RIZWI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/marstraining.in\\\/?p=2311#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/marstraining.in\\\/?p=2311\"},\"author\":{\"name\":\"Prof RASHID RIZWI\",\"@id\":\"https:\\\/\\\/marstraining.in\\\/#\\\/schema\\\/person\\\/a26a42a0305d3d78bfb7e54d5b9520a1\"},\"headline\":\"Insert Alternate Blank Rows In Excel\",\"datePublished\":\"2021-04-28T18:06:23+00:00\",\"dateModified\":\"2021-05-25T04:07:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/marstraining.in\\\/?p=2311\"},\"wordCount\":365,\"commentCount\":11,\"publisher\":{\"@id\":\"https:\\\/\\\/marstraining.in\\\/#organization\"},\"image\":{\"@id\":\"http:\\\/\\\/marstraining.in\\\/?p=2311#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/marstraining.in\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/Insert-Alternate-Blank-Rows-In-Excel-8.jpg\",\"articleSection\":[\"Blogs\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/marstraining.in\\\/?p=2311#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/marstraining.in\\\/?p=2311\",\"url\":\"http:\\\/\\\/marstraining.in\\\/?p=2311\",\"name\":\"Insert Alternate Blank Rows In Excel - MARStraining\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/marstraining.in\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/marstraining.in\\\/?p=2311#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/marstraining.in\\\/?p=2311#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/marstraining.in\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/Insert-Alternate-Blank-Rows-In-Excel-8.jpg\",\"datePublished\":\"2021-04-28T18:06:23+00:00\",\"dateModified\":\"2021-05-25T04:07:33+00:00\",\"description\":\"Insert alternate blank rows in excel is a serious issue faced by many excel users. This tutorial will teach you the easiest way to do so\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/marstraining.in\\\/?p=2311#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/marstraining.in\\\/?p=2311\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/marstraining.in\\\/?p=2311#primaryimage\",\"url\":\"https:\\\/\\\/marstraining.in\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/Insert-Alternate-Blank-Rows-In-Excel-8.jpg\",\"contentUrl\":\"https:\\\/\\\/marstraining.in\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/Insert-Alternate-Blank-Rows-In-Excel-8.jpg\",\"width\":750,\"height\":563},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/marstraining.in\\\/?p=2311#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/marstraining.in\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Insert Alternate Blank Rows In Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/marstraining.in\\\/#website\",\"url\":\"https:\\\/\\\/marstraining.in\\\/\",\"name\":\"MARStraining\",\"description\":\"We Enhance Professionals\",\"publisher\":{\"@id\":\"https:\\\/\\\/marstraining.in\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/marstraining.in\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/marstraining.in\\\/#organization\",\"name\":\"MARStraining\",\"url\":\"https:\\\/\\\/marstraining.in\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/marstraining.in\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/marstraining.in\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/marstraining.in\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/logo.png\",\"width\":175,\"height\":50,\"caption\":\"MARStraining\"},\"image\":{\"@id\":\"https:\\\/\\\/marstraining.in\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/marstraining.in\\\/#\\\/schema\\\/person\\\/a26a42a0305d3d78bfb7e54d5b9520a1\",\"name\":\"Prof RASHID RIZWI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1518a55275e34b8fb9f8045626baba9f033b94c3b4fd450134a386a5f5c5dbdc?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1518a55275e34b8fb9f8045626baba9f033b94c3b4fd450134a386a5f5c5dbdc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1518a55275e34b8fb9f8045626baba9f033b94c3b4fd450134a386a5f5c5dbdc?s=96&d=mm&r=g\",\"caption\":\"Prof RASHID RIZWI\"},\"url\":\"https:\\\/\\\/marstraining.in\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Insert Alternate Blank Rows In Excel - MARStraining","description":"Insert alternate blank rows in excel is a serious issue faced by many excel users. This tutorial will teach you the easiest way to do so","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/marstraining.in\/?p=2311","og_locale":"en_US","og_type":"article","og_title":"Insert Alternate Blank Rows In Excel - MARStraining","og_description":"Insert alternate blank rows in excel is a serious issue faced by many excel users. This tutorial will teach you the easiest way to do so","og_url":"http:\/\/marstraining.in\/?p=2311","og_site_name":"MARStraining","article_published_time":"2021-04-28T18:06:23+00:00","article_modified_time":"2021-05-25T04:07:33+00:00","og_image":[{"width":750,"height":563,"url":"http:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/Insert-Alternate-Blank-Rows-In-Excel-8.jpg","type":"image\/jpeg"}],"author":"Prof RASHID RIZWI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Prof RASHID RIZWI","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/marstraining.in\/?p=2311#article","isPartOf":{"@id":"http:\/\/marstraining.in\/?p=2311"},"author":{"name":"Prof RASHID RIZWI","@id":"https:\/\/marstraining.in\/#\/schema\/person\/a26a42a0305d3d78bfb7e54d5b9520a1"},"headline":"Insert Alternate Blank Rows In Excel","datePublished":"2021-04-28T18:06:23+00:00","dateModified":"2021-05-25T04:07:33+00:00","mainEntityOfPage":{"@id":"http:\/\/marstraining.in\/?p=2311"},"wordCount":365,"commentCount":11,"publisher":{"@id":"https:\/\/marstraining.in\/#organization"},"image":{"@id":"http:\/\/marstraining.in\/?p=2311#primaryimage"},"thumbnailUrl":"https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/Insert-Alternate-Blank-Rows-In-Excel-8.jpg","articleSection":["Blogs"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/marstraining.in\/?p=2311#respond"]}]},{"@type":"WebPage","@id":"http:\/\/marstraining.in\/?p=2311","url":"http:\/\/marstraining.in\/?p=2311","name":"Insert Alternate Blank Rows In Excel - MARStraining","isPartOf":{"@id":"https:\/\/marstraining.in\/#website"},"primaryImageOfPage":{"@id":"http:\/\/marstraining.in\/?p=2311#primaryimage"},"image":{"@id":"http:\/\/marstraining.in\/?p=2311#primaryimage"},"thumbnailUrl":"https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/Insert-Alternate-Blank-Rows-In-Excel-8.jpg","datePublished":"2021-04-28T18:06:23+00:00","dateModified":"2021-05-25T04:07:33+00:00","description":"Insert alternate blank rows in excel is a serious issue faced by many excel users. This tutorial will teach you the easiest way to do so","breadcrumb":{"@id":"http:\/\/marstraining.in\/?p=2311#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/marstraining.in\/?p=2311"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/marstraining.in\/?p=2311#primaryimage","url":"https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/Insert-Alternate-Blank-Rows-In-Excel-8.jpg","contentUrl":"https:\/\/marstraining.in\/wp-content\/uploads\/2021\/04\/Insert-Alternate-Blank-Rows-In-Excel-8.jpg","width":750,"height":563},{"@type":"BreadcrumbList","@id":"http:\/\/marstraining.in\/?p=2311#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/marstraining.in\/"},{"@type":"ListItem","position":2,"name":"Insert Alternate Blank Rows In Excel"}]},{"@type":"WebSite","@id":"https:\/\/marstraining.in\/#website","url":"https:\/\/marstraining.in\/","name":"MARStraining","description":"We Enhance Professionals","publisher":{"@id":"https:\/\/marstraining.in\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/marstraining.in\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/marstraining.in\/#organization","name":"MARStraining","url":"https:\/\/marstraining.in\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/marstraining.in\/#\/schema\/logo\/image\/","url":"https:\/\/marstraining.in\/wp-content\/uploads\/2019\/12\/logo.png","contentUrl":"https:\/\/marstraining.in\/wp-content\/uploads\/2019\/12\/logo.png","width":175,"height":50,"caption":"MARStraining"},"image":{"@id":"https:\/\/marstraining.in\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/marstraining.in\/#\/schema\/person\/a26a42a0305d3d78bfb7e54d5b9520a1","name":"Prof RASHID RIZWI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1518a55275e34b8fb9f8045626baba9f033b94c3b4fd450134a386a5f5c5dbdc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1518a55275e34b8fb9f8045626baba9f033b94c3b4fd450134a386a5f5c5dbdc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1518a55275e34b8fb9f8045626baba9f033b94c3b4fd450134a386a5f5c5dbdc?s=96&d=mm&r=g","caption":"Prof RASHID RIZWI"},"url":"https:\/\/marstraining.in\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/marstraining.in\/index.php?rest_route=\/wp\/v2\/posts\/2311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marstraining.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/marstraining.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/marstraining.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/marstraining.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2311"}],"version-history":[{"count":8,"href":"https:\/\/marstraining.in\/index.php?rest_route=\/wp\/v2\/posts\/2311\/revisions"}],"predecessor-version":[{"id":2627,"href":"https:\/\/marstraining.in\/index.php?rest_route=\/wp\/v2\/posts\/2311\/revisions\/2627"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/marstraining.in\/index.php?rest_route=\/wp\/v2\/media\/2624"}],"wp:attachment":[{"href":"https:\/\/marstraining.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marstraining.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marstraining.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}