Copy the cells and then position the cursor somewhere else and use Paste
Special | Transpose

Regards

Trevor


"hoffman3" <[email protected]> wrote in
message news:[email protected]...
>
> I have seen the solution awhile ago when I visited this board frequently
> but I am unable to locate it now. I have a spreadsheet with values in
> rows but i want to switch these values into columns.
> As so:
>
> abcde
>
>
> a
> b
> c
> d
> e
> Thanks in advance,
>
> Hoffman3
>
>
> --
> hoffman3
> ------------------------------------------------------------------------
> hoffman3's Profile:
> http://www.excelforum.com/member.php...o&userid=10187
> View this thread: http://www.excelforum.com/showthread...hreadid=470853
>