What are columns in Excel

Office Excel: move column - this is how it works

display

Surprisingly, Microsoft Excel does not provide an easy way to accomplish this common task. So if you are confronted with the task of editing large Excel tables in your day-to-day work, you have certainly faced the challenge of swapping individual columns or reorganizing several columns. That is why in our article we show two ways how you can move a column in Excel in a targeted manner. With both techniques, you can also move the formulas and formatting used in the cells and do not have to adjust them manually afterwards.

Move column in Excel with drag and drop

Follow our step-by-step instructions, the quick start guide or the explanatory video.

Video

Cut the column in Excel and paste it elsewhere

Another approach is to use the cut and paste function of Windows to move columns in Excel. To do this, click on the again Column head, to highlight the entire column. You can then select the column with the shortcut key [Ctrl] + [X] cut out. Now select the column where your content should be inserted. Press [Ctrl] +[+] at the selected position so that the content is automatically shifted and inserted with the correct formatting.

Brief instruction: Move column in Excel with drag and drop

  1. Mark the column to be moved with a Left click on the Column head.
  2. Hover the pointer to the edge of the column until the cursor moves into a four sided arrow transformed.
  3. Hold up [Shift] and the left mouse pointer and move the column.
  4. Let go of the buttons again and the column will appear in a new position.