change cells contents from vertical to horizontal

's Computer Specifications

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?

's Computer Specifications

Select the data to be copied>Copy>Select target cell>Right
click>PasteSpecial>select 'Transpose>OK

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?

's Computer Specifications

Perfect-thank you-you just saved me a ton of time.

"Jacob Skaria" wrote:

> Select the data to be copied>Copy>Select target cell>Right
> click>PasteSpecial>select 'Transpose>OK
>
> 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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
taking numbers in vertical cells putting them in horizontal cells	jhawk22	Microsoft Excel Worksheet Functions	3	28th Apr 2010 08:37 PM
need to paste link from 4 vertical cells to 4 horizontal cells?	=?Utf-8?B?Y2lvYW5nZWw=?=	Microsoft Excel Misc	6	8th Jun 2009 06:44 PM
How do I change horizontal cells to vertical	JMP	Microsoft Excel Misc	1	7th Aug 2008 09:40 PM
copy formulas from horizontal cells into vertical cells.	Little Penny	Microsoft Excel Programming	1	26th Oct 2006 08:01 PM
Linking a horizontal set of cells to a vertical sets of cells	=?Utf-8?B?UnVzc2VsbC1zdGFuZWx5?=	Microsoft Excel Charting	2	21st Oct 2005 03:19 PM