While the above two methods are fairly simple, they aren’t very efficient when you want to move several rows or columns in a large spreadsheet. Move Rows and Columns With Data Sort Feature

Likewise, if you’re moving a row, right-click the row below the desired destination and select Insert Cut Cells.ģ. Right-click on it and select Insert Cut Cells. Step 3: If you’re moving a column, highlight the column to the right of where you want the cut column to go. Step 2: Right-click on your selection and select Cut. Step 1: In your Excel spreadsheet, select the column or row you want to move. Move Rows and Columns With Cut and PasteĪnother quick way to move rows or columns in Excel is to cut and paste them from one location to another. This method also lets you move multiple adjacent rows or columns at once. Step 4: Keep holding the Shift key and drag and drop the column or row to its new position. Step 3: Hold down the Shift key on your keyboard and click and hold the right or left border of the column (or the top or bottom border of the row). If you want to move a row, click on its row number on the far left. Step 2: Select your column by clicking the column header. Step 1: Open your Excel spreadsheet and navigate to the column or row you want to move. All you have to do is drag and drop the row or column to your preferred location.

However, if you aren’t careful then the data cells may get merged and duplicated. The easiest way to move a row or column in Excel is with your mouse. Stick around till the end if you’re interested in a bonus tip. This guide will walk you through handy methods to move rows and columns in Microsoft Excel. However, rearranging data isn’t as easy when you’ve to move entire rows or cells in a worksheet. Whether you want to relocate one odd column or row for better visibility or reorder them all from scratch, Microsoft Excel offers several options for rearranging data. When working on an Microsoft Excel spreadsheet, you may have to move rows and columns for various reasons.

Excel rotate row to column