This method only works for a single column. To move multiple columns, use cut and paste commands (see next method). Moving columns is a great way to set up your spreadsheet for a Vlookup or Sum formula. For general spreadsheet tips, check out our guide on making a spreadsheet in Excel.
The cursor will turn into a hand in the web app version of Excel.
If you want to copy and replace columns instead of just moving them, hold down Ctrl (Windows) or ⌥ Option (macOS) while dragging and dropping. Holding ⇧ Shift will cut and insert the columns. Holding Ctrl+⇧ Shift will copy and insert the columns.
To move more than one (adjacent) column at the same time, hold down Ctrl as you click each column letter. Formatting your spreadsheet can significantly improve your Excel experience.
The column data will remain in its place until you paste it into its new location. You can also cut the column by clicking the scissors icon on the Home tab. It’s in the “Clipboard” section near the top-left corner of the app. If you cut the wrong column, press Esc to return the data to its original location.
When you insert your copied data, it’ll be to the left of the column you right-click.
If you want to undo the pasted column, press Ctrl+Z. Alternatively, you can click the drop-down icon next to the Insert button on the Home toolbar at the top, and select Insert Cut Cells or Insert Cells here. This will insert and move your data the same way.
