{"id":343,"date":"2023-08-17T06:28:34","date_gmt":"2023-08-17T06:28:34","guid":{"rendered":"https:\/\/sheeter.ai\/blog\/?p=343"},"modified":"2024-07-01T06:38:18","modified_gmt":"2024-07-01T06:38:18","slug":"move-columns-and-rows-in-excel","status":"publish","type":"post","link":"https:\/\/sheeter.ai\/blog\/move-columns-and-rows-in-excel\/","title":{"rendered":"How to Move Columns and Rows in Excel"},"content":{"rendered":"<p>Users of Microsoft Excel spreadsheets may need to change rows and columns for a variety of reasons. Moving rows and columns in Excel is as simple as using cut and paste or the shortcut keys Ctrl + X and Ctrl + V, which you may already be familiar with from working in Excel, MS Word, or other programs.<\/p>\n<p>Understanding how to shift rows and columns in Excel is just as crucial as understanding how to copy and paste. This is something you will have to do a lot when you are working with Excel.<\/p>\n<p>Continue reading to learn how to shift columns and rows in Excel using copy\/paste and another method shown with screenshots.<\/p>\n<h2><strong>How to Move Columns in Excel<\/strong><\/h2>\n<p>There are basically three different ways to move columns in Excel. These ways are:<\/p>\n<ul>\n<li>Moving Column by Mouse Drag<\/li>\n<li>Moving Column using Short Keys<\/li>\n<li>Moving Column using Mouse Right Click<\/li>\n<\/ul>\n<p>Choose the method that is easiest for you to understand. To move columns in Excel, being familiar with one step is sufficient.<\/p>\n<h3><strong>Moving Column by Mouse Drag<\/strong><\/h3>\n<p>Kindly follow these instructions to move a column to the location of your choice using the mouse.<\/p>\n<p><strong>Step 1:<\/strong> Select a column you want to move (we took Column D as an example).<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-colums-1.png\" alt=\"\" title=\"\"><\/p>\n<p><strong>Step 2:<\/strong> Bring the mouse pointer over the edge of the cell in the selected column to transform it into a move pointer. The image that follows shows a border with a move pointer:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-colums-2.png\" alt=\"\" title=\"\"><\/p>\n<p><strong>Step 3:<\/strong> You can move the column by dragging the move pointer to where you want it to go. For example, we want to shift column D to column C, so we will drag column D and keep it in column C.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-colums-3.png\" alt=\"\" title=\"\"><\/p>\n<p>Following this way, the column can be easily moved to your desired location.<\/p>\n<blockquote><p><strong>Note:<\/strong> This procedure cuts the column and pastes it into the new position. If you want to copy the column to the new spot while keeping the column you already have, just press the Ctrl key before dragging the column to the new place.<\/p><\/blockquote>\n<h3><strong>Moving Column Using Short Keys<\/strong><\/h3>\n<p>To move a column by short key, follow this:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Choose the column you want to shift, as explained in the previous example.<\/li>\n<li><strong>Step 2:<\/strong> If you are using Windows, press Ctrl+X. If you are on the Mac operating system, use Command + X.<\/li>\n<li><strong>Step 3:<\/strong> Choose the column letter where you want to paste it. In our example, we chose C. (We want column D to be shifted into column C.)<\/li>\n<li><strong>Step 4:<\/strong> Now, on Windows, press Ctrl + V, and on Mac, Command + V.<\/li>\n<\/ul>\n<blockquote><p><strong>Note:<\/strong> If you wish to copy the material rather than cut\/paste it, replace Ctrl + X with Ctrl + C or Command + C in step 2.<\/p><\/blockquote>\n<h3><strong>Moving Column using Mouse Right Click<\/strong><\/h3>\n<p><strong>Step 1:<\/strong> Choose a heading column that you want to shift, just like we did in the previous two methods.<\/p>\n<p><strong>Step 2:<\/strong> Press Ctrl + X on Windows or Command + X on Mac OS from the keyboard. This should make the selected borders dotted, as shown in the picture below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-colums-4.png\" alt=\"\" title=\"\"><\/p>\n<p><strong>Step 3:<\/strong> The column has been selected; now single on the column you want to paste the selected column on, and press Ctrl + V (Windows) or Command + V (Mac).<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-colums-5.png\" alt=\"\" title=\"\"><\/p>\n<p>Similar to how we shifted Column D to Column C, you will be able to copy and paste the chosen column in the desired location.<\/p>\n<p><strong>Again,<\/strong> if you wish to copy the material rather than cut\/paste it, replace Ctrl + X with Ctrl + C or Command + C in step 2.<\/p>\n<blockquote><p><strong>Note:<\/strong> When you move columns, Excel copies the text and any formulas. This causes hidden cells, values, and cell formats to move.<\/p><\/blockquote>\n<p>Cell references are not modified, though. The column references must be manually adjusted.<\/p>\n<p>For instance, if other cells, such as those in column B, are referencing the D cells, they will continue to reference even after the material has been copied to column C. This could result in a #REF! the problem, so be careful.<\/p>\n<h3><strong>How to Move Multiple Columns in Excel<\/strong><\/h3>\n<p>You now understand how to move a column in Excel. Yet, do you know how to shift multiple columns continuously?<\/p>\n<p>Suppose we have a dataset in which we wish to move column A and column B before column D.<\/p>\n<p>Now, follow these instructions to gain clarity.<\/p>\n<p><strong>Step 1:<\/strong> Select column A by clicking on the header. Again, press the Shift key and select the header for column B. Do not leave the Shift key until you click on Column B.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-columns-6.png\" alt=\"\" title=\"\"><\/p>\n<p><strong>Step 2:<\/strong> Move the mouse over Column B\\&#8217;s border until the plus symbol appears.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-columns-7.png\" alt=\"\" title=\"\"><\/p>\n<p><strong>Step 3:<\/strong> Hold and drag the selected columns and drop them before column D, the result will display something like this.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-columns-8.png\" alt=\"\" title=\"\"><\/p>\n<p><strong>Note:<\/strong> Remember that this hack only works with contiguous columns or rows. It cannot be used to transfer non-contiguous Excel rows and columns.<\/p>\n<hr \/>\n<h2><strong>How to Move Rows in Excel<\/strong><\/h2>\n<p>We will go through the two possible ways to move the rows in excel.<\/p>\n<h3><strong>Moving Rows by Mouse Drag<\/strong><\/h3>\n<p>Relocating one or more rows follows almost the same approach as moving columns. Follow these instructions in order to relocate one or more rows. We will shift rows 4 and 5 to positions 7 and 8.<\/p>\n<p><strong>Step 1:<\/strong> Pick a row by selecting the number located on the left side. If you wish to choose multiple rows, click the Shift key and continue selecting rows. Multiple selections should look something like this:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-rows-1.png\" alt=\"\" title=\"\"><\/p>\n<p><strong>Step 2:<\/strong> Bring the cursor into view by moving the mouse over the thick blue border.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-rows-2.png\" alt=\"\" title=\"\"><\/p>\n<p><strong>Step 3:<\/strong> Move the mouse down the page and stop at row 7 (for our demo). As required, you will move it to the destination row.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/move-rows-3.png\" alt=\"\" title=\"\"><\/p>\n<p>As said earlier, we moved rows 4 and 5 to destinations 7 and 8.<\/p>\n<h3><strong>Moving Rows Using Short Keys<\/strong><\/h3>\n<p>You may also move rows using keyboard shortcuts.<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Choose the rows you wish to move, as shown in the example above. I selected rows 4 and 5.<\/li>\n<li><strong>Step 2:<\/strong> Press Ctrl + X for Windows or Command + X for Mac users.<\/li>\n<li><strong>Step 3:<\/strong> Go to the first cell of the 7th row, i.e., A7 (in our demo), and press Ctrl + V for Windows or Command + V for Mac users.<\/li>\n<\/ul>\n<p>Following this, you will be able to move the row to your desired position.<\/p>\n<hr \/>\n<h2><strong>Bonus: How to convert data from rows to columns (or vice versa) in Excel<\/strong><\/h2>\n<p>Excel has you covered if you started entering data in a vertical order (columns) and then decided that a horizontal order (rows) would be better. See the picture below for the example:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/rows-to-column-1.png\" alt=\"\" title=\"\"><\/p>\n<p>Do the following steps to turn rows into columns:<\/p>\n<p><strong>Step 1<\/strong>: Select the original data you want to change. To quickly select the entire table, or all of the data-containing cells in a spreadsheet, press Ctrl + Home followed by Ctrl + Shift + End.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/rows-to-column-2.png\" alt=\"\" title=\"\"><\/p>\n<p><strong>Step 2:<\/strong> Select Copy from the context menu or press Ctrl + C on the keyboard to copy the selected cells.<\/p>\n<p><strong>Step 3:<\/strong> Select the first cell where you want to paste the modified data. Like in the picture below, we chose A13 to paste the modified data.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/rows-to-column-3.png\" alt=\"\" title=\"\"><\/p>\n<p><strong>Note:<\/strong> Choose a cell outside of the range where your original data is so that the areas where you copy and paste do not overlap. For example, our original table has four columns and nine rows; the converted table will have nine columns and four rows.<\/p>\n<p><strong>Step 4:<\/strong> Click the right mouse button on the destination cell, pick Paste Special from the context menu, and then select Transpose.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2023\/03\/rows-to-column-4.png\" alt=\"\" title=\"\"><\/p>\n<blockquote><p><strong>Note:<\/strong> If your source data has formulas, make sure to use relative and absolute references correctly, depending on whether you want to change the formulas or keep them locked to certain cells.<\/p><\/blockquote>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p>Using Shift, CTRL, and the Insert method, we learned in this post how to quickly shift columns and rows in Excel.<\/p>\n<p>At times, working on an Excel spreadsheet can be somewhat difficult. But if you know how to use these simple features, you may be able to make your spreadsheets more useful and less time-consuming.<\/p>\n","protected":false},"excerpt":{"rendered":"\n<p class=\"read-more-container\"><a title=\"How to Move Columns and Rows in Excel\" href=\"https:\/\/sheeter.ai\/blog\/move-columns-and-rows-in-excel\/\" aria-label=\"More on How to Move Columns and Rows in Excel\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":82,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-343","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33","no-featured-image-padding"],"_links":{"self":[{"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/posts\/343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/comments?post=343"}],"version-history":[{"count":0,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/posts\/343\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/media\/82"}],"wp:attachment":[{"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/media?parent=343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/categories?post=343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/tags?post=343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}