 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2006Column to a row
I have a column of numbers. How do I transfer this column to a row? There must be a function that will allow it. Thanks, Sal and Eileen Have a look in the help index for TRANSPOSE  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com >I have a column of numbers. How do I transfer this column to a row? There >must be a function that will allow it. > > Thanks, > Sal and Eileen I've done it with copy & paste, high light the colume of cells you want then copy, know high light row of cells, paste them. Work for me just fine. > I have a column of numbers. How do I transfer this column to a row? There > must be a function that will allow it. > > Thanks, > Sal and Eileen I had this problem awhile ago, and ya, it is very simple once you're told, All you have to do, is select the numbers that you want to move from a column to row, then select Edit -> Paste Special, then click the Transpose box. This will paste your data to the opposite of what you are selecting (column to row, or row to column). Good luck! Mike Thank you very much. It was a much needed format. > I had this problem awhile ago, and ya, it is very simple once you're > told, [quoted text clipped - 5 lines] > Good luck! > Mike |
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.