{"id":164,"date":"2011-09-13T14:19:42","date_gmt":"2011-09-13T14:19:42","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=164"},"modified":"2023-12-30T23:14:25","modified_gmt":"2023-12-30T23:14:25","slug":"excel-courses-adding-multiple-rows-in-an-excel-worksheet","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-courses-adding-multiple-rows-in-an-excel-worksheet\/","title":{"rendered":"Excel Courses \u2013 Adding multiple rows in an Excel Worksheet"},"content":{"rendered":"<p>If you want to add more than one row to an <strong>Excel Worksheet<\/strong>, drag select the number or rows you want added to the spreadsheet.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/09\/21.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-166\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/09\/21.png\" alt=\"\" width=\"347\" height=\"312\" \/><\/a><\/p>\n<p>Then right click on these selected rows, choose <em>Insert<\/em> from the menu, and the new rows will be added above the rows you first selected.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/09\/3.png\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-167\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/09\/3.png\" alt=\"\" width=\"346\" height=\"311\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet. Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected. &nbsp;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[38,171,172,219,220,224,231,282,283,288,318,470,539,616],"class_list":["post-164","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-adding-multiple-rows","tag-excel","tag-excel-how-to","tag-excel-tips","tag-excel-training-y","tag-excel-training-london","tag-excel-tutorial","tag-hints","tag-hints-and-tips","tag-how-to","tag-inserting-multiple-rows","tag-rows","tag-training","tag-ya"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=164"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/164\/revisions"}],"predecessor-version":[{"id":6795,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/164\/revisions\/6795"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}