 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / February 2007Changing rows to columns
Does anyone know, how I could arrange data in cells from horizontal to vertical? I do not need to change the direction of the text itself, I would like to have the data from the 1st row in the 'A' column, second row in B, etc. > Does anyone know, how I could arrange data in cells from horizontal to > vertical? I do not need to change the direction of the text itself, I would > like to have the data from the 1st row in the 'A' column, second row in B, > etc. One way: Select your data. Copy. Choose another sheet/cell. Choose Edit/Paste Special, check the Transpose checkbox, click OK. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.