How to Move Columns in Excel

Cutting and Pasting

1. Click the letter above the column you want to move. This selects the column.

   1. To move more than one (adjacent) column at the same time, hold down Ctrl (PC) or ⌘ Command (Mac) as you click each column letter.

2. Press Ctrl+X (PC) or ⌘ Command+X (Mac). This 'cuts' the data in the column, which really just selects it and adds it to the clipboard.

   1. The column data will remain in its place until you paste it into its new location.
   2. 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.
   3. If you cut the wrong column, press Esc to return the data to its original location.

3. Right-click the letter above the column to the right of where you want to move the data. A drop-down menu will expand.^{[2] X Research source}

   1. When you insert your copied data, it'll be moved to the left of the column you right-click here.

4. Click Insert Cut Cells on the right-click menu. Excel will insert the cut column to the left of the one on which you right-clicked.

   1. If you want to undo the pasted column, press Ctrl+Z (PC) or ⌘ Command+Z (Mac).
   2. 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 also insert and move your data the same way.