move content line to column

  • Thread starter Thread starter Robert Ehrlich
  • Start date Start date
R

Robert Ehrlich

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
 
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
 
Thanks for your help.
I have never seen the menu "Edit Paste-Special"
I only know Edit Paste... please explain.


Robert
 
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)...
 
Back
Top