익명 04:02

Is there a way to move a column in between existing columns with drag-and-drop?

Is there a way to move a column in between existing columns with drag-and-drop?

In Excel 2010, I want to move a column with some data to be in between two existing columns which also have data. However, a simple drag-and-drop of the column will just prompt me to replace the data of whichever column is closest to the drop.

Is there a keyboard shortcut, or other equally-efficient method, that will allow me to perform a fairly simple drag-and-drop to in between columns?



Top Answer/Comment:

Hold shift and the shaded border you see when moving the selected column will change to a shaded line between two destination columns.

When you release your mouse the column will move to where the shaded line was.

상단 광고의 [X] 버튼을 누르면 내용이 보입니다