{"id":74,"date":"2016-02-10T16:57:03","date_gmt":"2016-02-11T00:57:03","guid":{"rendered":"http:\/\/www.susmg.info\/alandale\/tips\/?p=74"},"modified":"2016-09-02T01:14:39","modified_gmt":"2016-09-02T01:14:39","slug":"a-quick-way-to-insert-six-rows-at-once-in-excel","status":"publish","type":"post","link":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/","title":{"rendered":"A quick way to insert six rows at once in Excel"},"content":{"rendered":"
\n
\n

Subscriber Barb K. asks \u201cWhen I need to insert lines in an Excel spreadsheet, I am doing it one line at a time. Is there an easier way to insert six rows at a time?\u201d<\/p>\n

Yes there is, although\u00a0I find people often don\u2019t discover this useful shortcut.\u00a0 Simply select the six rows then right-click on the highlighted rows and select Insert.<\/p>\n

Note that if the rows you want to add are not adjacent in the worksheet, you can select the first row then press and hold CTRL as you click on additional row headers.\u00a0 With the non-adjacent rows selected, right-click on any of them and select Insert. Excel inserts a row above each of the rows you had selected.<\/p>\n<\/div>\n<\/div>\n

\n

Any questions, please let me know<\/a>.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Subscriber Barb K. asks \u201cWhen I need to insert lines in an Excel spreadsheet, I am doing it one line at a time. Is there an easier way to insert …<\/p>\n","protected":false},"author":2,"featured_media":67,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-74","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"\nA quick way to insert six rows at once in Excel - Alandale Training Software Tips<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A quick way to insert six rows at once in Excel - Alandale Training Software Tips\" \/>\n<meta property=\"og:description\" content=\"Subscriber Barb K. asks \u201cWhen I need to insert lines in an Excel spreadsheet, I am doing it one line at a time. Is there an easier way to insert ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Alandale Training Software Tips\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-11T00:57:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-09-02T01:14:39+00:00\" \/>\n<meta name=\"author\" content=\"John Chandler\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Chandler\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A quick way to insert six rows at once in Excel - Alandale Training Software Tips","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":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"A quick way to insert six rows at once in Excel - Alandale Training Software Tips","og_description":"Subscriber Barb K. asks \u201cWhen I need to insert lines in an Excel spreadsheet, I am doing it one line at a time. Is there an easier way to insert ...","og_url":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/","og_site_name":"Alandale Training Software Tips","article_published_time":"2016-02-11T00:57:03+00:00","article_modified_time":"2016-09-02T01:14:39+00:00","author":"John Chandler","twitter_card":"summary_large_image","twitter_misc":{"Written by":"John Chandler","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/"},"author":{"name":"John Chandler","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/3d915833a2c762b11624ae07740300e8"},"headline":"A quick way to insert six rows at once in Excel","datePublished":"2016-02-11T00:57:03+00:00","dateModified":"2016-09-02T01:14:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/"},"wordCount":138,"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/#primaryimage"},"thumbnailUrl":"","articleSection":["Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/","url":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/","name":"A quick way to insert six rows at once in Excel - Alandale Training Software Tips","isPartOf":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/#primaryimage"},"thumbnailUrl":"","datePublished":"2016-02-11T00:57:03+00:00","dateModified":"2016-09-02T01:14:39+00:00","author":{"@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/3d915833a2c762b11624ae07740300e8"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/02\/10\/a-quick-way-to-insert-six-rows-at-once-in-excel\/#primaryimage","url":"","contentUrl":""},{"@type":"WebSite","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#website","url":"https:\/\/www.alandaletraining.com\/software-tips\/","name":"Alandale Training Software Tips","description":"Weekly Software Tips","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.alandaletraining.com\/software-tips\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.alandaletraining.com\/software-tips\/#\/schema\/person\/3d915833a2c762b11624ae07740300e8","name":"John Chandler","url":"https:\/\/www.alandaletraining.com\/software-tips\/author\/d5afe\/"}]}},"_links":{"self":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/74","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/comments?post=74"}],"version-history":[{"count":1,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/74\/revisions"}],"predecessor-version":[{"id":147,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/posts\/74\/revisions\/147"}],"wp:attachment":[{"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/media?parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/categories?post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alandaletraining.com\/software-tips\/wp-json\/wp\/v2\/tags?post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}