move content line to column
 

how can I move contents from line to colum or column to line?
for example from A1:M1 to A1:A13

who can help?


Robert

move content line to column
 

Bach up your file. then
Highlight and Cut the range you want to move. A1:M1
(Assuming range A2:A13 is clear of data)
With your active cell (cursor) still in A1 Go to menu, Edit Paste-Special,
Check Transpose box near bottom of screen, OK


"Robert Ehrlich" wrote in message
...
how can I move contents from line to colum or column to line?
for example from A1:M1 to A1:A13

who can help?


Robert

move content line to column
 

Thanks for your help.
I have never seen the menu "Edit Paste-Special"
I only know Edit Paste... please explain.


Robert

"JMay" schrieb im Newsbeitrag
news:mxOZb.8909$iB.2765@lakeread06...
Bach up your file. then
Highlight and Cut the range you want to move. A1:M1
(Assuming range A2:A13 is clear of data)
With your active cell (cursor) still in A1 Go to menu, Edit Paste-Special,
Check Transpose box near bottom of screen, OK


"Robert Ehrlich" wrote in message
...
how can I move contents from line to colum or column to line?
for example from A1:M1 to A1:A13

who can help?


Robert

move content line to column
 

Best way to learn it's features:
Open a New Workbook, enter in cell a1 123.
With cursor on A1 select Copy,
then go to the menu, edit paste-special.. and the dialog box will come up
showing all features available to you.. In the upper right-hand corner of
the box you will see a "?"
left-click on it and then move to each choice (one-by-one) and left-click on
them; as you do an explanation follow (in a pale-yellow box).
After reading, left-click inside the pale-yellow box and the box is turned
off. Then again back to the ? and go to the next choice; go thru them all.
That's me suggestion (for starters)...

"Robert Ehrlich" wrote in message
...
Thanks for your help.
I have never seen the menu "Edit Paste-Special"
I only know Edit Paste... please explain.


Robert

"JMay" schrieb im Newsbeitrag
news:mxOZb.8909$iB.2765@lakeread06...
Bach up your file. then
Highlight and Cut the range you want to move. A1:M1
(Assuming range A2:A13 is clear of data)
With your active cell (cursor) still in A1 Go to menu, Edit
Paste-Special,
Check Transpose box near bottom of screen, OK


"Robert Ehrlich" wrote in message
...
how can I move contents from line to colum or column to line?
for example from A1:M1 to A1:A13

who can help?


Robert