| Home |
| Search |
| Today's Posts |
|
#1
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
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
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change data from horizontal to be vertical (Excel 2003) | Excel Discussion (Misc queries) | |||
| how to change data from horizontal to be vertical (Excel 2007) | Excel Discussion (Misc queries) | |||
| How do I change horizontal cells to vertical | Excel Discussion (Misc queries) | |||
| change table from vertical to horizontal | Excel Discussion (Misc queries) | |||
| How do I change my typing from horizontal to vertical | Excel Worksheet Functions | |||
Linear Mode
