{"id":1311,"date":"2015-05-29T12:36:17","date_gmt":"2015-05-29T10:36:17","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1311"},"modified":"2024-02-06T16:17:22","modified_gmt":"2024-02-06T15:17:22","slug":"insert-or-delete-rows-and-columns-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-or-delete-rows-and-columns-in-excel\/","title":{"rendered":"CTRL + -\/+: Insert or Delete Rows and Columns in Excel"},"content":{"rendered":"<p>One of my favourite Excel keyboard <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcut\" data-wpil-keyword-link=\"linked\">shortcut<\/a> and one that I use hundreds of times per week is the insert or delete rows and columns.<\/p>\n<p>All you have to do is select the whole row or column with your mouse and then press the following:<\/p>\n<p><strong>CTRL<\/strong> + <strong>&#8211;<\/strong> to <em>delete<\/em> or <strong>CTRL<\/strong> + <strong>+<\/strong> to <em>insert<\/em><br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/7Gf7DMc1zps?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/www.e-junkie.com\/ecom\/gb.php?ii=935478&amp;c=ib&amp;aff=277028&amp;cl=49044\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"Put a Macro In The Quick Access Toolbar\"  class=\"alignnone wp-image-376 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/vbaclasses.com-logo.png\" alt=\"Put a Macro In The Quick Access Toolbar\" width=\"274\" height=\"70\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of my favourite Excel keyboard shortcut and one that I use hundreds of times per week is the insert or delete rows and columns. All you have to do is select the whole row or column with your mouse and then press the following: CTRL + &#8211; to delete or CTRL + + to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17679,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[9,7],"tags":[61],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1311"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1311"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1311\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17679"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}