Move column to in-between existing columns
 

Is there a way to move an entire column to in-between existing columns
without getting the error message, "Do you want to replace contents in
destination cells?" and also without VB? I'm no use with coding...

What I've been doing is to insert new blank column, highlight and drag my
existing column to this new column, then delete the old column.

Have you tried "control x" to cut the column from the old location and then
ctl v to paste it to the new?
Peter
London, UK


"Melissa" wrote:

Is there a way to move an entire column to in-between existing columns
without getting the error message, "Do you want to replace contents in
destination cells?" and also without VB? I'm no use with coding...

What I've been doing is to insert new blank column, highlight and drag my
existing column to this new column, then delete the old column.

Peter,
your suggestion is the same as dragging my column to another place with the
result that the contents in the new colum are overwritten with the contents
of the old column.

But, FYI, I found that I can right-click in the column to the right of where
I want the cells to be moved to, and select "Insert Cut Cells".

"Peter" wrote:

Have you tried "control x" to cut the column from the old location and then
ctl v to paste it to the new?
Peter
London, UK


"Melissa" wrote:

Is there a way to move an entire column to in-between existing columns
without getting the error message, "Do you want to replace contents in
destination cells?" and also without VB? I'm no use with coding...

What I've been doing is to insert new blank column, highlight and drag my
existing column to this new column, then delete the old column.

And you have another response at your first post.

Melissa wrote:

Peter,
your suggestion is the same as dragging my column to another place with the
result that the contents in the new colum are overwritten with the contents
of the old column.

But, FYI, I found that I can right-click in the column to the right of where
I want the cells to be moved to, and select "Insert Cut Cells".

"Peter" wrote:

Have you tried "control x" to cut the column from the old location and then
ctl v to paste it to the new?
Peter
London, UK


"Melissa" wrote:

Is there a way to move an entire column to in-between existing columns
without getting the error message, "Do you want to replace contents in
destination cells?" and also without VB? I'm no use with coding...

What I've been doing is to insert new blank column, highlight and drag my
existing column to this new column, then delete the old column.


--

Dave Peterson