1
Shift and Drag Method
Shift and Drag Method
How to move columns in Excel
This guide will show you how to quickly rearrange your data by moving columns in Excel. You will learn how to select a column, cut it, and insert it into a new position on your excel.
Operations
2
Open the Excel
Navigate to the Excel to begin the process of moving columns.
3
Click column header B
Click the "B" column header at the top of the column to select the entire column.
4
Move the column
Move your mouse cursor to C column until it changes into a four-sided arrow and release the mouse button.
5
Cut and Insert Method
Cut and Insert Method
6
Click column header A
Click the column header "A" at the top of the spreadsheet grid to select the entire column.
7
Select the Cut option
Click the Cut option in the context menu to remove the selected column and copy it to your clipboard. Press Ctrl + X (or right-click and select Cut)
8
Click the column D header
Click the column D header in the spreadsheet to select the entire column or right-click the header of the destination column where you want your cut column to go.
9
Click the Insert Cut Cells option
Select the column where you want the cut column to be placed. Right-click the selected column, and then click “Insert Cut Cells…” from the context menu to place the cut column in the selected location.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.