What is Moving Columns in Excel?
Moving a column in excel means shifting the data of one column to another. It is similar to interchanging or swapping the data of two or more columns. When a column or row is moved, Excel copies the formulas, formatting, hidden cells, outputs, and comments to the new location. However, in some cases, the cell references within the formulas may have to be modified manually to match the changed position.
For example, the manager of the payroll department wants to view the name and the monthly salary of each employee in columns A and B respectively. Since this data is currently in columns D and G, a movement of columns to the new position is required.
The purpose of moving excel columns is to organize the dataset in the required format. Moreover, a movement allows one to view specific columns next to each other. Therefore, the reordering (or moving) of columns helps the user to view the data in the desired sequence.
How to Move Columns in Excel?
In Excel, columns can be moved by using either of the following techniques:
- “Shift” key
- “Insert cut cells” option
In this article, the movement of columns by both techniques has been demonstrated. Further, the mouse has been used under the two methods.
Note: It is not possible to move non-adjacent columns and rows of Excel by using the mouse.
Example #1–Move Columns Using the “Shift” Key
The following image shows the names of certain employees (column B), their IDs (column C), and the departments (column A) they are working in.
We want to arrange the given dataset in the following sequence:
- “Emp name” should be in column A.
- “Emp ID” should be in column B.
- “Dept” should be in column C.
Move the required excel columns by using the “Shift” key.
The steps to rearrange the columns by using the “Shift” key are listed as follows:
Step 1: Select the rightmost column of the dataset. This column is titled “emp ID.” For selecting this column entirely, click the letter “C” appearing at the top of this column. Alternatively, select any cell within this column and press the keys “Ctrl+space” together.
The selection is shown in the following image.
Step 2: Place the cursor at the right edge of the selected column. The regular cursor changes to a four-point arrow cursor, as shown in the following image.
Step 3: Once the four-point arrow cursor appears, press and hold the “Shift” key. At the same time, drag column C to the left edge of column A by using the mouse.
On dragging, a faint vertical line (in green) appears on the left edge of column A. This line indicates the position where the selected column (column C) will be moved. Moreover, there is a small box containing “A:A,” which shows that the selected column will be moved to column A.
The following image shows the faint vertical line (appearing in green) and the small box within red rectangles.
Note: Remember to hold the “Shift” key throughout the dragging process. Further, on some devices, the faint vertical line may appear in grey.
Step 4: On reaching the left edge of column A, leave the “Shift” key and release the mouse.The “emp ID” column shifts from column C to column A. Consequently, the columns “dept” and “emp name” (initially columns A and B) shift rightwards to columns B and C respectively.
The movement of column C to column A is shown in the following image.
Step 5: Likewise, drag the “emp name” column (currently column C) to the left edge of column A by pressing and holding the “Shift” key. This is because we want this to be the first column of the dataset followed by the “emp ID” and “dept” columns.
The movement is shown in the following image. As a result of this movement, “emp ID” and “dept” columns shift rightwards to columns B and C respectively.
In the final dataset, “emp name” is in column A, “emp ID” is in column B, and “dept” is in column C. Hence, all the columns of the dataset have been reordered according to the requirement.
Note: For moving multiple adjacent excel columns, refer to the second question under “frequently asked questions.” This section is at the end of this article.
Let us observe what happens when one forgets to press and hold the “Shift” key (in step 3), while dragging one column to the other. In the following image, the three columns “emp name,” “emp ID,” and “dept” have been arranged in a random order.
Without pressing the “Shift” key, drag column C to column A with the four-point arrow. Excel displays a message, which asks the user if the data of column A needs to be replaced or not.
If the user clicks “Ok,” the data of column A is replaced with that of column C. However, the initial data of column A is lost in the process. Clicking “cancel” does not reorder columns A and C.
Hence, to avoid loss of data, it is essential to press and hold the “Shift” key while dragging one column to the other.
Example #2–Move Columns Using the “Insert Cut Cells” Option
Working on the dataset of example #1, columns A, B, and C contain the department, employee ID, and employee name respectively.
We want to arrange the dataset in the following sequence:
- “Emp ID” should be in column A.
- “Emp name” should be in column B.
- “Dept” should be in column C.
Use the “insert cut cells” option to move the excel columns.
The steps to rearrange the columns by using the “insert cut cells” option are listed as follows:
Step 1: Select the “emp id” column. For selecting, click the letter “B” appearing at the top of this column. Alternatively, select any cell of the “emp id” column and press the keys “Ctrl+space” together.
The selected column is shown in the following image.
Step 2: Right-click the selected column and choose “cut” from the context menu. Alternatively, keep column B selected and press the shortcut keys “Ctrl+X” together.
By cutting column B, a moving border appears around it, as shown in the following image.
Step 3: Select the column where the column that has been cut (column B) needs to be inserted. Since the entire cut cells need to be inserted in column A, select the same. This is shown in the following image.
Note: The cut column may be inserted either at the position of the selected column or just before the selected column. In this case, the cut column is column B and the selected column is column A.
Step 4: Right-click the selected column (column A) and choose “insert cut cells” from the context menu. The same is shown in the following image.
Note: If one presses the keys “Ctrl+V” to paste the cut cells, the initial (existing) content of the destination cells is lost.
Step 5: The “emp ID” column is inserted at the first position (column A) of the worksheet. As a result, the initial column A (“dept” column) shifts rightwards to column B. The “emp name” column stays at its place (column C).
Step 6: Move “emp name” to column B. For this, select the “emp name” column, which is the current column C. Right-click the selection and choose “cut.” This is shown in the following image.
Step 7: Select column B as the “emp name” column needs to be inserted at this location. The selection of column B is shown in the following image.
Step 8: Right-click column B and choose “insert cut cells,” as shown in the following image.
Step 9: The “emp name” column has been pasted in column B. The newly pasted column is shown within a red box in the following image.
The columns of the dataset are rearranged in the required sequence. Hence, in the final dataset, “emp ID” is in column A, “emp name” is in column B, and “dept” is in column C.
Frequently Asked Questions
The moving of columns refers to shifting or transferring the data of one column to another. Such movement of columns is often required when the user wants to view certain columns next to each other. Therefore, moving columns is essential to rearrange the dataset according to the requirements.
In Excel, columns can be moved in either of the following ways:
a. “Shift” key
b. “Insert cut cells” option
Note: For more details related to these techniques, refer to the two examples of this article.
Multiple adjacent columns can be moved by using either the “Shift” key or the “insert cut cells” option. In both these methods, there is no overwriting of data. The initial data of the destination cells shifts to the right of the newly inserted columns.
The steps to move multiple adjacent excel columns by using the “Shift” key are listed as follows:
a. Select multiple adjacent columns that need to be moved.
b. Drag the four-point arrow appearing at the right edge of the rightmost selected column.
c. Press and hold the “Shift” key.
d. Drag the selected columns to the new location.
The multiple adjacent columns have been moved to the new location.
Alternatively, one can use the “insert cut cells” technique to move multiple columns. For this, select multiple adjacent columns and press “Ctrl+X.” At the desired location, select the column before which the cut columns need to be inserted. Right-click the selection and choose “insert cut cells.”
The steps to move columns with the help of keyboard shortcuts are listed as follows:
a. Select any cell of the column to be moved. Press the keys “Ctrl+space” together to select this column entirely.
b. Press the keys “Ctrl+X” together to cut the selected column.
c. Select the column before which the cut column has to be inserted. This column too can be selected by following step “a.”
d. Press the keys “Ctrl+Shift+plus sign (+)” together to insert the cut cells.
The column has been moved to the desired location (selected in step c).
Note: If the keyboard has a separate numeric keypad, use the shortcut “Ctrl+plus sign (+)” to insert the cut cells. Press the “Ctrl” key from the keyboard and the plus sign (+) from the numeric keypad.
Recommended Articles
This has been a guide to move columns in Excel. Here we learned through practical examples, how to move columns in Excel by dragging or cutting them. The downloadable templates are available on the website. You may learn more about Excel from the following articles –
- Adding Columns in Excel
- VBA Insert Columns
- Freeze Columns in Excel
- Group Columns in Excel
- REPT Function in Excel
- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion
58.6K subscribers