How do I change rows content to column & vice versa Excel spread s

Data is already spread in the Excel sheet.

Hi

If you copy your range you can then select Edit|Paste Special|Transpose,
which will tranpose your columns to rows and rows to columns. Make sure you
take a copy before you start!

Andy.

"Harinath" <[email protected]> wrote in message
news:[email protected]...
> Data is already spread in the Excel sheet.

Note that you cannot paste to any range that overlaps the original in any
way. Paste to another range and then move or copy the data to where it
needs to go.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Andy B" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> If you copy your range you can then select Edit|Paste Special|Transpose,
> which will tranpose your columns to rows and rows to columns. Make sure
you
> take a copy before you start!
>
> Andy.
>
> "Harinath" <[email protected]> wrote in message
> news:[email protected]...
> > Data is already spread in the Excel sheet.
>
>