Now press Ctrl + V on Windows OS or Command + V on Mac. Select the desired destination column letter that will highlight the whole column. Press the Ctrl + X on Windows or Command + X on Mac operating system. Select the column as we did in the above example. If you want to copy the column to the new location while keeping existing in place then just press the Ctrl key before dragging the column to the new location.įor moving a column by short key, follow this: Note that, this method cut/pastes the column to the new location. You can see the C column is moved to the H. For example, we want to move the column C to the H: The picture below shows border with move pointer:ĭrag the move pointer to the desired location where you want to relocate the column. Select a column by clicking on A, B, C etc.īring to mouse over the border of any cell in of the selected column so that mouse pointer becomes move pointer: In this tutorial, I will show you how to move columns and rows in Excel by copy/paste and another way with demo pictures – so keep reading.įollow these steps for moving a column to the desired location by using the mouse. However, you may move columns and rows in other ways as well.
In simple terms, moving the rows and columns in Excel is just the matter of cut and paste or pressing the short keys Ctrl + X and Ctrl + V, that you might already use to while working in Excel, MS Word or other programs.
