rows and columns interchange 1

[mirage10]

Hi,
In a particular excel sheet, I typed the whole document and later realised that the rows should have been columns and vice versa.
I donot want to type the whole thing again.Is there a way to interchange these row and column positions?


------------------------------------------
A Man can be only as happy.. as he makes up his mind to be

 

[SkipVought]

Hi,

take a look at the TRANSPOSE worksheet function.

Skip,

_{[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken!}

 

[PHV]

You may also consider the Transpose checkbox in the PasteSpecial dialogbox.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886