|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 19th, 2009, 03:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
change cells contents from vertical to horizontal
I need to copy from one workseet the values in cells that are arranged
vertically into another worksheet and the values need to be arranged horizontally. Can this be done? If so, how? 
|
|
#2
November 19th, 2009, 03:52 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
change cells contents from vertical to horizontal
Select the data to be copiedCopySelect target cellRight
clickPasteSpecialselect 'TransposeOK If this post helps click Yes --------------- Jacob Skaria "GailH" wrote: I need to copy from one workseet the values in cells that are arranged vertically into another worksheet and the values need to be arranged horizontally. Can this be done? If so, how?
|
|
#3
November 19th, 2009, 04:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
change cells contents from vertical to horizontal
Perfect-thank you-you just saved me a ton of time.
"Jacob Skaria" wrote: Select the data to be copiedCopySelect target cellRight clickPasteSpecialselect 'TransposeOK If this post helps click Yes --------------- Jacob Skaria "GailH" wrote: I need to copy from one workseet the values in cells that are arranged vertically into another worksheet and the values need to be arranged horizontally. Can this be done? If so, how?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
