Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and count words | Excel Worksheet Functions | |||
Brake & Move Columns | Excel Worksheet Functions | |||
move column headings from row to column | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
merge data from multiple columns to single column | Excel Worksheet Functions |