How to Move Columns in Excel

Step-by-Step Guide

1. 1

   Step 1: Select the column (or columns

   You can select the column by clicking on the column header which is the letter visible by the ruler.
2. 2

   Step 2: if they're adjacent) that you wish to move.

   You can "cut" the data by clicking the scissor button on the toolbar, or by using the keyboard command.
   
   You should see a dotted line surrounding what you had selected previously.
   
   The keyboard shortcut command on a Windows computer is ctrl-x, "ctrl" being the Control key.
   
   The keyboard command on a Mac computer is cmd-x, "cmd" being the Command key.
   
   Depending on your computer model, your Command key might have an apple or cloverleaf symbol on it instead of saying "cmd."
   
   , Excel will automatically move the column to the left of the column currently selected. (The function may call itself "Insert Cut Cells," depending on your particular setup.) Go to the "Home" tab and look in the "Cells" group.
   
   Click on "Insert" to find the "Insert Copied Cells" function. ,
3. 3

   Step 3: Cut the information in the column.

4. 4

   Step 4: Select the column to the right of where you want the cut column to go.

5. 5

   Step 5: Use Excel's "Insert Copied Cells" function.

6. 6

   Step 6: Verify that the column pasted where you want it.

Detailed Guide

About the Author