How do change rows to colums AND columns to rows
 

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

How do change rows to colums AND columns to rows
 

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

How do change rows to colums AND columns to rows
 

Hi,

Copy, then Paste Special Transpose.


--
TJS
------------------------------------------------------------------------
TJS's Profile: http://www.excelforum.com/member.php...o&userid=29583
View this thread: http://www.excelforum.com/showthread...hreadid=496825

How do change rows to colums AND columns to rows
 

Hi,

Maybe there is a more elegant way of accomplishinging what you want. But
the following approach should work.

Let's assume that your data are in Sheet1.

Create a blank worksheet ("Insert" -- "Worksheet").

In A1 of that worksheet, enter the following formula, and auto-fill across
columns and down rows, to accommodate the transposed data.

=IF(OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)="","",OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1))

The new sheet is still linked to the original sheet. To make it
stand-alone, select and copy the entire area of the new sheet, then "Edit"
-- "Paste Special" -- "Values" -- "OK"

Regards,
B. R. Ramachandran



"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

How do change rows to colums AND columns to rows
 

Many thanks - I'll try this :)

Colleen

"B. R.Ramachandran" wrote:

Hi,

Maybe there is a more elegant way of accomplishinging what you want. But
the following approach should work.

Let's assume that your data are in Sheet1.

Create a blank worksheet ("Insert" -- "Worksheet").

In A1 of that worksheet, enter the following formula, and auto-fill across
columns and down rows, to accommodate the transposed data.

=IF(OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)="","",OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1))

The new sheet is still linked to the original sheet. To make it
stand-alone, select and copy the entire area of the new sheet, then "Edit"
-- "Paste Special" -- "Values" -- "OK"

Regards,
B. R. Ramachandran



"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

How do change rows to colums AND columns to rows
 

Thanks - of course this seems to lose all formats, but I guess I can re-do
them.

Colleen

"TJS" wrote:


Hi,

Copy, then Paste Special Transpose.


--
TJS
------------------------------------------------------------------------
TJS's Profile: http://www.excelforum.com/member.php...o&userid=29583
View this thread: http://www.excelforum.com/showthread...hreadid=496825

How do change rows to colums AND columns to rows
 

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

How do change rows to colums AND columns to rows
 

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