How to Move Columns in Excel without Overwriting (3 Methods)

While working in Excel, sometimes we need to move columns for many reasons like if we do a mistake to arrange columns or maintaining the chronology. Excel offers some quick and smart features to do it. You will learn 3 quick methods from this article to move columns in Excel without overwriting with clear demonstrations.


Download Practice Workbook

You can download the free Excel template from here and practice on your own.


3 Ways to Move Columns in Excel without Overwriting

To explore the methods, we’ll use the following dataset that represents some salesperson’s Sales in different Regions.


1. Use SHIFT+Drag to Move Columns in Excel without Overwriting

First, we’ll learn how to use SHIFT + Drag to move columns. It’s quite easy and useful for a small dataset. Here, I’ll move the Sales column between the Salesperson and Region columns.

Steps:

  • Select the Sales column.
  • Keep the mouse cursor at the left border and it will show a 4 directional arrow.
  • Then just press and hold the SHIFT key and drag the column between the Salesperson and Region columns by pressing the left click of your mouse.
  • When you will see a vertical green line between the columns then release the left click first and then release the SHIFT key.

Use SHIFT+Drag to Move Columns in Excel without Overwriting

Soon after, you will see that the column is moved successfully.

Read More: How to Move Multiple Columns in Excel (4 Quick Ways)


2. Apply Insert Cut Cells in Excel to Move Columns without Overwriting

Now we’ll use a command- Insert Cut Cells from the Context menu to move columns without overwriting. It is feasible for a large dataset.

Steps:

  • Select the column that you want to move. I selected the Sales column.
  • Then press CTRL + X to cut it.

Apply Insert Cut Cells in Excel to Move Columns without Overwriting

  • Later, select the first cell of the column before which you want to move. I’ll move before the Region column.
  • Then right-click your mouse and select Insert Cut Cells from the Context menu.

Apply Insert Cut Cells in Excel to Move Columns without Overwriting

Now have a look that the column is moved properly.

Read More: Excel VBA: Cut and Insert Column (5 Examples)


3. Use Sort Command to Move Columns in Excel without Overwriting

Now we’ll learn a tricky way to do the task. We can indirectly use the Sort command to move columns without overwriting. Let’s see how to do it.

Steps:

  • First, give your desired serial number in the immediate upper row of your dataset.
  • I used 1,2,3.

Use Sort Command to Move Columns in Excel without Overwriting

  • Then select the whole dataset including the added row.
  • Next, click as follows: Data ➤ Sort & Filter ➤ Sort.

Use Sort Command to Move Columns in Excel without Overwriting

Soon you will get a dialog box.

  • Select the row number from the Sort by I selected Row 4 as I placed the serial number in Row 4.
  • Then click Options.

And soon after, another dialog box will open up.

Use Sort Command to Move Columns in Excel without Overwriting

  • Mark Sort left to right and press OK.

It will take you back to the previous dialog box.

Use Sort Command to Move Columns in Excel without Overwriting

  • At this moment, nothing to do more. Just press OK.

Use Sort Command to Move Columns in Excel without Overwriting

Now see that the columns are arranged according to the given serial, consequently, the Sales column moved between the Salesperson and Region columns.

  • Finally, just delete the added row.

Read More: How to Move Columns in Excel Table (5 Methods)


Practice Section

You will get a practice sheet in the Excel file given above to practice the explained ways.


Conclusion

I hope the procedures described above will be good enough to move columns in Excel without overwriting. Feel free to ask any question in the comment section and please give me feedback.


Related Article

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo