Home |
Search |
Today's Posts |
#1
|
|||
|
|||
move column
can anyone tell me how to move a column with data in it, to fit in between 2
other columns please. Thanks |
#2
|
|||
|
|||
Hi Nad
there's a couple of ways to achieve this, i use the right mouse drag method .... select the column you want to move move the mouse just under the column header and you should see a four headed black arrow hold down the RIGHT mouse button drag to where you want it to go, release mouse button choose Shift Right and Move from the list of options. Cheers JulieD "Nad" wrote in message ... can anyone tell me how to move a column with data in it, to fit in between 2 other columns please. Thanks |
#3
|
|||
|
|||
Select the column and right click it and select cut, select the column you
want it to the left of and right click and select insert cut cells. Note that if you for instance want what's in A to be between what's in C and D when inserted the contents of A will be in C and what was in C will be in B You can also select the column, place the cursor on a cell border and drag the column Regards, Peo Sjoblom "Nad" wrote: can anyone tell me how to move a column with data in it, to fit in between 2 other columns please. Thanks |
#4
|
|||
|
|||
Julie,
Tried that but it asks if I want to replace the cell contents, I just want the column to fit in between 2 other columns. Thanks JulieD wrote in message ... Hi Nad there's a couple of ways to achieve this, i use the right mouse drag method ... select the column you want to move move the mouse just under the column header and you should see a four headed black arrow hold down the RIGHT mouse button drag to where you want it to go, release mouse button choose Shift Right and Move from the list of options. Cheers JulieD "Nad" wrote in message ... can anyone tell me how to move a column with data in it, to fit in between 2 other columns please. Thanks |
#5
|
|||
|
|||
Hi
are you using the RIGHT mouse to drag NOT the left Cheers JulieD "Nad" wrote in message ... Julie, Tried that but it asks if I want to replace the cell contents, I just want the column to fit in between 2 other columns. Thanks JulieD wrote in message ... Hi Nad there's a couple of ways to achieve this, i use the right mouse drag method ... select the column you want to move move the mouse just under the column header and you should see a four headed black arrow hold down the RIGHT mouse button drag to where you want it to go, release mouse button choose Shift Right and Move from the list of options. Cheers JulieD "Nad" wrote in message ... can anyone tell me how to move a column with data in it, to fit in between 2 other columns please. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Move column values w/o formula | Excel Worksheet Functions | |||
how can I take 3 cells and move them to a different column into 1 | Excel Discussion (Misc queries) | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
How to move one piece of text to another column | Excel Discussion (Misc queries) |