How to Move Columns in Excel

How to Move Columns in Excel - Spreadsheets have a variety of uses, and figuring out how to set one up to work most easily for a specific task can take a few tries. Understand how to move columns in Excel so you can rearrange them more easily.

Method Rearrange Excel Columns Using the Menus

1. Select the column (or columns, if they're adjacent) that you wish to move.You can select the column by clicking on the column header which is the letter visible by the ruler.

2. Cut the information in the column. 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."

3. Select the column to the right of where you want the cut column to go.

4. Use Excel's "Insert Copied Cells" function. 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.

5. Verify that the column pasted where you want it.

Tweet

Do not miss the best of the post-post Maxz Pro. Now also subscribe by email :

You can also follow Maxz Pro by clicking on the button below :

Artikel keren lainnya:

Ditulis oleh Unknown pada tanggal Senin, 05 Januari 2015