{"id":33643,"date":"2023-12-27T07:11:04","date_gmt":"2023-12-27T06:11:04","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=33643"},"modified":"2024-03-22T22:04:03","modified_gmt":"2024-03-22T21:04:03","slug":"how-to-move-rows-in-excel-5-easy-ways","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-move-rows-in-excel-5-easy-ways\/","title":{"rendered":"How to Move Rows in Excel &#8211; 5 Easy Ways!"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-30.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33684 size-large\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-30-1024x576.png\" alt=\"Move Rows in Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-30-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-30-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-30-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-30.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>One of the most common tasks in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a> is moving rows within a spreadsheet. Once you have this skill on point, you will be able to organize your data to the format you desire as well as make corrections to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-11-data-entry-form-tips-and-tricks\/\" target=\"_blank\" rel=\"noopener\">data entry<\/a>. In this article, we will explore different methods to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/swap-columns-in-excel\/\" target=\"_blank\" rel=\"noopener\">move rows in Excel<\/a>.<\/p>\n<div class=\"contents\">\n<h2>Table of Contents<\/h2>\n<ul>\n<li><a href=\"#1\"><strong> Drag and Drop with the Shift Key <\/strong><\/a><\/li>\n<li><a href=\"#2\"><strong> Cut and Paste Rows <\/strong><\/a><\/li>\n<li><a href=\"#3\"><strong> Move Multiple Rows <\/strong><\/a><\/li>\n<li><a href=\"#4\"><strong> Insert Copied Cells <\/strong><\/a><\/li>\n<li><a href=\"#5\"><strong> Using the Sort Feature <\/strong><\/a><\/li>\n<\/ul>\n<\/div>\n<p>Let&#8217;s look at these methods thoroughly!<\/p>\n<h4>Download the Excel Workbook below to follow along the How to Move Rows in Excel tutorial! \u2013<\/h4>\n<p><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/MoveRowsinExcel.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong>\u00a0<\/span><span class=\"postTitle px-3\">MoveRowsinExcel.xlsx<\/span><\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-move-rows-in-excel-5-easy-ways\/#Drag_and_Drop_with_the_Shift_Key\" title=\" Drag and Drop with the Shift Key\"> Drag and Drop with the Shift Key<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-move-rows-in-excel-5-easy-ways\/#Cut_and_Paste_Rows\" title=\" Cut and Paste Rows\"> Cut and Paste Rows<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-move-rows-in-excel-5-easy-ways\/#Move_Multiple_Rows\" title=\" Move Multiple Rows\"> Move Multiple Rows<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-move-rows-in-excel-5-easy-ways\/#Insert_Copied_Cells\" title=\" Insert Copied Cells\"> Insert Copied Cells<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-move-rows-in-excel-5-easy-ways\/#Using_the_Sort_Feature\" title=\" Using the Sort Feature\"> Using the Sort Feature<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Drag_and_Drop_with_the_Shift_Key\"><\/span><strong><span id=\"1\" style=\"color: #ff0000!important\"> Drag and Drop with the Shift Key<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span id=\"1\" style=\"color: #ff0000!important\"> <\/span><br \/>\nHere we have data on the results of the 2008 Beijing Olympics Men\u2019s 200m Freestyle Finals. Suppose there was a slight mistake, and we want to relocate <strong>Row 5<\/strong> to occupy the position of <strong>Row 4<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33655 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-1.jpg\" alt=\"Move Rows in Excel\" width=\"693\" height=\"378\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-1.jpg 693w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-1-300x164.jpg 300w\" sizes=\"(max-width: 693px) 100vw, 693px\" \/><\/a><\/p>\n<p>Click on the row number to <strong>select the entire row<\/strong> that you want to move.<\/p>\n<p><strong>Press and hold<\/strong> the <strong>Shift<\/strong> key.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-2.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33657 size-large\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-2-1024x561.jpg\" alt=\"Move Rows in Excel\" width=\"1024\" height=\"561\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-2-1024x561.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-2-300x164.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-2-768x421.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-2-1536x841.jpg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-2-2048x1122.jpg 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Hover the cursor over the border of the selected row. The cursor should change to a <strong>four-sided arrow<\/strong>.<\/p>\n<p>Click <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-10-excel-double-click-mouse-tricks\/\" target=\"_blank\" rel=\"noopener\">and hold the left mouse<\/a> button, then <strong>drag and drop the row to the desired location.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-3.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33658 size-large\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-3-1024x564.jpg\" alt=\"Move Rows in Excel 3\" width=\"1024\" height=\"564\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-3-1024x564.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-3-300x165.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-3-768x423.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-3-1536x846.jpg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-3-2048x1128.jpg 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cut_and_Paste_Rows\"><\/span><strong><span id=\"2\" style=\"color: #ff0000!important\"> Cut and Paste Rows<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span id=\"2\" style=\"color: #ff0000!important\"> <\/span><br \/>\nUsing the same example, click on the row number to select the entire row that you want to move.<\/p>\n<p><strong>Right-click<\/strong> on the selected row, choose <strong>Cut<\/strong> from the context menu, or use the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/005-my-top-10-excel-keyboard-shortcuts-excel-podcast\/\" target=\"_blank\" rel=\"noopener\">keyboard shortcut<\/a> (Ctrl + X).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-4.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33659 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-4.jpg\" alt=\"Move Rows in Excel 4\" width=\"644\" height=\"525\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-4.jpg 644w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-4-300x245.jpg 300w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/a><\/p>\n<p><strong>Click on the row number<\/strong> where you want to move the cut row. In our case, it\u2019ll be row 4.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-5.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33660 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-5.jpg\" alt=\"Move Rows in Excel 5\" width=\"694\" height=\"380\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-5.jpg 694w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-5-300x164.jpg 300w\" sizes=\"(max-width: 694px) 100vw, 694px\" \/><\/a><\/p>\n<p><strong>Right-click<\/strong> on the selected destination row, choose <strong>Insert Cut Cells<\/strong> from the context menu, or use the keyboard shortcut (Alt + i + e).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-6.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33661 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-6.jpg\" alt=\"Move Rows in Excel \" width=\"649\" height=\"553\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-6.jpg 649w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-6-300x256.jpg 300w\" sizes=\"(max-width: 649px) 100vw, 649px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Move_Multiple_Rows\"><\/span><strong><span id=\"3\" style=\"color: #ff0000!important\"> Move Multiple Rows<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span id=\"3\" style=\"color: #ff0000!important\"> <\/span><br \/>\nIt is possible to move multiple rows at the same time. However, it&#8217;s important to keep in mind that only adjacent rows or columns can be moved together. For instance, you can move Rows 3 to 6 together, but moving Row 3 and Row 5 concurrently is not possible.<\/p>\n<p><strong>Highlight<\/strong> the rows you would like to move.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-14.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33669 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-14.jpg\" alt=\"Move Rows in Excel\" width=\"655\" height=\"382\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-14.jpg 655w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-14-300x175.jpg 300w\" sizes=\"(max-width: 655px) 100vw, 655px\" \/><\/a><\/p>\n<p><strong>Right-click<\/strong> on the selected rows, choose <strong>Cut<\/strong>\u00a0from the context menu, or use the keyboard shortcut (Ctrl + X).<\/p>\n<p><strong>Click<\/strong> on the row number where you want to move the cut row.<\/p>\n<p><strong>Right-click<\/strong> on the selected destination row, choose <strong>Insert Cut Cells<\/strong> from the context menu, or use the keyboard shortcut (Alt + i + e).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-15.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33671 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-15.jpg\" alt=\"Move Rows in Excel\" width=\"650\" height=\"461\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-15.jpg 650w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-15-300x213.jpg 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-16.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33672 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-16.jpg\" alt=\"Move Rows in Excel\" width=\"652\" height=\"381\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-16.jpg 652w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-16-300x175.jpg 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Insert_Copied_Cells\"><\/span><strong><span id=\"4\" style=\"color: #ff0000!important\"> Insert Copied Cells<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span id=\"4\" style=\"color: #ff0000!important\"> <\/span><br \/>\nClick on the row number to select the entire row that you want to move. In our example, it is row 5.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-7.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33662 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-7.jpg\" alt=\"Move Rows in Excel\" width=\"694\" height=\"381\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-7.jpg 694w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-7-300x165.jpg 300w\" sizes=\"(max-width: 694px) 100vw, 694px\" \/><\/a><\/p>\n<p><strong>Right-click<\/strong> on the selected row, choose <strong>Copy<\/strong> from the context menu, or use the keyboard shortcut (Ctrl + C).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-8.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33663 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-8.jpg\" alt=\"Move Rows in Excel\" width=\"662\" height=\"535\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-8.jpg 662w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-8-300x242.jpg 300w\" sizes=\"(max-width: 662px) 100vw, 662px\" \/><\/a><\/p>\n<p><strong>Click on the row number<\/strong> where you want to move the copied row. In our case, it is row 4.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-9.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33664 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-9.jpg\" alt=\"Move Rows in Excel\" width=\"653\" height=\"379\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-9.jpg 653w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-9-300x174.jpg 300w\" sizes=\"(max-width: 653px) 100vw, 653px\" \/><\/a><\/p>\n<p><strong>Right-click<\/strong> on the selected destination row and choose <strong>Insert Copied Cells<\/strong> from the context menu.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-10.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33665 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-10.jpg\" alt=\"Move Rows in Excel\" width=\"651\" height=\"559\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-10.jpg 651w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-10-300x258.jpg 300w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/a><\/p>\n<p>Delete the original row by <strong>Right-clicking the row number<\/strong>, then press <strong>Delete<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-11.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33666 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-11.jpg\" alt=\"Move Rows in Excel\" width=\"664\" height=\"414\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-11.jpg 664w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-11-300x187.jpg 300w\" sizes=\"(max-width: 664px) 100vw, 664px\" \/><\/a> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-12.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33667 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-12.jpg\" alt=\"Move Rows in Excel\" width=\"657\" height=\"559\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-12.jpg 657w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-12-300x255.jpg 300w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/><\/a><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-13.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33668 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-13.jpg\" alt=\"Move Rows in ExceL\" width=\"656\" height=\"378\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-13.jpg 656w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-13-300x173.jpg 300w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Using_the_Sort_Feature\"><\/span><strong><span id=\"5\" style=\"color: #ff0000!important\"> Using the Sort Feature<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span id=\"5\" style=\"color: #ff0000!important\"> <\/span><br \/>\nThe Sort feature method is one of the most creative and useful methods when it comes to moving rows in Excel. This method is the most useful when you need to move a lot of rows. The essence of this method is to mark the order of the data in a new column using numbers. The Sort feature will then automatically arrange the data based on the assigned numbers.<\/p>\n<p>First, <strong>Right-click<\/strong> on column A and click <strong>Insert<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-17.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33673 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-17.jpg\" alt=\"Move Rows in Excel\" width=\"659\" height=\"386\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-17.jpg 659w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-17-300x176.jpg 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/a><\/p>\n<p>From there, mark the new order of the data using numbers. 1 being first place and 8 being 8th place.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-18.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33674 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-18.jpg\" alt=\"Move Rows in Excel\" width=\"773\" height=\"383\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-18.jpg 773w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-18-300x149.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-18-768x381.jpg 768w\" sizes=\"(max-width: 773px) 100vw, 773px\" \/><\/a><\/p>\n<p><strong>Highlight<\/strong> the entire range of data from <strong>A2 to D9<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-19.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33675 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-19.jpg\" alt=\"Move Rows in Excel\" width=\"770\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-19.jpg 770w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-19-300x135.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-19-768x345.jpg 768w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/a><\/p>\n<p>Go to the <strong>Data<\/strong> tab on the Excel ribbon, click <strong>Sort<\/strong>, and specify the sorting criteria.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-21.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33676 size-large\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-21-1024x737.jpg\" alt=\"Move Rows in Excel\" width=\"1024\" height=\"737\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-21-1024x737.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-21-300x216.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-21-768x552.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-21-1536x1105.jpg 1536w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-21.jpg 2002w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Click on <strong>Options<\/strong> and make sure that it is set to <strong>Sort from Top to Bottom<\/strong>, as we are working with rows.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-20.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33677 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-20.jpg\" alt=\"Move Rows in Excel\" width=\"172\" height=\"167\" \/><\/a><\/p>\n<p>On the <strong>Sort by<\/strong> drop-down options, click on <strong>Column A<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-22.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33678 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-22.jpg\" alt=\"Move Rows in Excel\" width=\"582\" height=\"264\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-22.jpg 582w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-22-300x136.jpg 300w\" sizes=\"(max-width: 582px) 100vw, 582px\" \/><\/a><\/p>\n<p>Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-23.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33679 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-23.jpg\" alt=\"Move Rows in Excel \" width=\"782\" height=\"381\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-23.jpg 782w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-23-300x146.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-23-768x374.jpg 768w\" sizes=\"(max-width: 782px) 100vw, 782px\" \/><\/a><\/p>\n<p>As you can see, the data is now set according to the numbers we entered.<\/p>\n<p>Lastly, <strong>Right-click<\/strong> on Column A, and click <strong>Delete<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-24.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33680 size-full\" title=\"Move Rows in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-24.jpg\" alt=\"Move Rows in Excel \" width=\"767\" height=\"340\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-24.jpg 767w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Move-Rows-in-Excel-24-300x133.jpg 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/a><\/p>\n<p><strong>Conclusion<\/strong>:<br \/>\nThere you have it! You have successfully acquired the skills to move <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-blank-rows-in-a-pivot-table-excel\/\" target=\"_blank\" rel=\"noopener\">rows<\/a> in Excel using the simple methods and <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\">shortcuts<\/a> demonstrated above. Be sure to apply these methods the next time you\u2019re manipulating data, or just looking to showcase your Excel <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-interview-questions\/\" target=\"_blank\" rel=\"noopener\">skills<\/a>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the most common tasks in Microsoft Excel is moving rows within a spreadsheet. Once you have this skill on point, you will be able to organize your data to the format you desire as well as make corrections to data entry. In this article, we will explore different methods to move rows in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33684,"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":[38,927,20],"tags":[1516,1515,1517,1466,62],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33643"}],"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=33643"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33643\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33684"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=33643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=33643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=33643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}