How to move columns in Excel (and rows) | Tutorial

How to move columns in Excel (and rows)

Filling a worksheet with data is actually quite simple. It is much more difficult to plan the complete structure in advance. It is therefore not uncommon that some areas, be it single cells, but also whole rows or columns have to be moved. Therefore we were looking for a practical solution how to move columns in Excel without having to create free spaces in advance and then copy the columns. We actually came across a solution that automatically makes space for the moved columns and rows. We don’t want to deprive you of this knowledge!

Excel Move columns without overwriting data:

It is actually quite easy to find a way to move columns back and forth in Excel. The problem is that there must not be any data in the new place, otherwise it will be overwritten with the content of our moved column. However, this is usually not the purpose. Therefore it is important to work with the right key combinations so that Excel knows what to do.

Step-by-step instructions:

  • Select the columns or rows you want to move
  • Move the mouse to the outer edge of your selection until your cursor is a cross with four arrows
  • Now press the Shift key and drag your selection to the desired location
  • Release the mouse button. The columns or rows will be placed at this position. Other content will be sorted in front of or behind it
  • Done!

The Shift key makes the difference in this procedure. In fact, this is the case in Excel in quite a few cases. If you are not sure how a feature works, try using the mouse or keys like CTRL, Alt or Shift. In most cases you will find the right solution and you can also get to know other great functions by chance!

Video tutorial:

Links with * are affiliate links. By purchasing via this link we receive a part of the purchase price as commission without any additional costs for you. This helps us to expand the offers available here for you! Thank you!

Be the first to comment

Leave a Reply