Have you tried this?:

Select your range
EditCopy
Select a cell outside of your range
EditPaste SpecialTranspose

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Colleen A" wrote:

I need to change the whole orientation of my spreadsheets... columns to rows
AND rows to columns - does anyone know of a quick way, or do I have to
transpose all the information individually.

Thanks