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

Thanks - I tried this but it changed all formats also - of course, I can
always re-enter, right ;)

Colleen

"Ron Coderre" wrote:

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

No it will carry the formatting as well unless you select otherwise

--
Regards,

Peo Sjoblom

(No private emails please)


"Colleen A" wrote in message
...
Thanks - I tried this but it changed all formats also - of course, I can
always re-enter, right ;)

Colleen

"Ron Coderre" wrote:

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