Step 1: Select the column you need to move by clicking on the column header and then use the Cut command by pressing Control+X or by choosing the Cut command after right-clicking on the column header. Let us understand this with the help of the same example. We can also move the columns using the cut & Paste Command in Excel. The same process needs to be followed for moving the rows to desired locations. The column has been swapped as per our requirement. Which, in our case, is the D Column? As we can see from the snapshot above. Release the mouse button, and the columns will be swapped to the new location. Once you start dragging the column, a green-colored symbol will appear in the column, indicating where you need to place the column.

Press and hold the shift key, and while holding the shift key, drag the column to the desired location where you need to swap the column. The mouse cursor changes from the normal cursor to the move cursor. We need to select the column we need to move, which in our case is the F column after we have selected the column, we need to place the cursor on the edge of the selection. We need to follow certain steps for doing so. So now we want to swap certain columns among each other like we need to swap the Inventory Value column in the F Column with Unit Price. The Columns contain the details as Inventory ID, Name, Description, Unit Price, Quantity in Stock, Inventory Value, etc., and the rows contain the details of the columns.

In the snapshot below, we have an inventory list of a company. Let’s understand this method with the help of an example. Moving Columns through Swappingĭragging columns in excel is a complicated procedure. However, there are several ways for moving the columns in excel.

Dragging the column does not work in excel. Excel functions, formula, charts, formatting creating excel dashboard & othersĮxcel does not have a separate command or a separate function for performing the moving of columns and rows action.

Moving columns in excel table