software

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

Have you tried this?:

Select your range
Editgt;Copy
Select a cell outside of your range
Editgt;Paste Specialgt;Transpose

Does that help?

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

XL2002, WinXP-Proquot;Colleen Aquot; wrote:

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


Hi,

Copy, then Paste Special Transpose.--
TJS
------------------------------------------------------------------------
TJS's Profile: www.excelforum.com/member.php...oamp;userid=29583
View this thread: www.excelforum.com/showthread...hreadid=496825Hi,

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 (quot;Insertquot; --gt; quot;Worksheetquot;).

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)=quot;quot;,quot;quot;,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 quot;Editquot;
--gt; quot;Paste Specialquot; --gt; quot;Valuesquot; --gt; quot;OKquot;

Regards,
B. R. Ramachandran
quot;Colleen Aquot; wrote:

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

Many thanks - I'll try this

Colleen

quot;B. R.Ramachandranquot; wrote:

gt; Hi,
gt;
gt; Maybe there is a more elegant way of accomplishinging what you want. But
gt; the following approach should work.
gt;
gt; Let's assume that your data are in Sheet1.
gt;
gt; Create a blank worksheet (quot;Insertquot; --gt; quot;Worksheetquot;).
gt;
gt; In A1 of that worksheet, enter the following formula, and auto-fill across
gt; columns and down rows, to accommodate the transposed data.
gt;
gt; =IF(OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)=quot;quot;,quot;quot;,OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1))
gt;
gt; The new sheet is still linked to the original sheet. To make it
gt; stand-alone, select and copy the entire area of the new sheet, then quot;Editquot;
gt; --gt; quot;Paste Specialquot; --gt; quot;Valuesquot; --gt; quot;OKquot;
gt;
gt; Regards,
gt; B. R. Ramachandran
gt;
gt;
gt;
gt; quot;Colleen Aquot; wrote:
gt;
gt; gt; I need to change the whole orientation of my spreadsheets... columns to rows
gt; gt; AND rows to columns - does anyone know of a quick way, or do I have to
gt; gt; transpose all the information individually.
gt; gt;
gt; gt; Thanks

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

Colleen

quot;TJSquot; wrote:

gt;
gt; Hi,
gt;
gt; Copy, then Paste Special Transpose.
gt;
gt;
gt; --
gt; TJS
gt; ------------------------------------------------------------------------
gt; TJS's Profile: www.excelforum.com/member.php...oamp;userid=29583
gt; View this thread: www.excelforum.com/showthread...hreadid=496825
gt;
gt;

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

Colleen

quot;Ron Coderrequot; wrote:

gt; Have you tried this?:
gt;
gt; Select your range
gt; Editgt;Copy
gt; Select a cell outside of your range
gt; Editgt;Paste Specialgt;Transpose
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;Colleen Aquot; wrote:
gt;
gt; gt; I need to change the whole orientation of my spreadsheets... columns to rows
gt; gt; AND rows to columns - does anyone know of a quick way, or do I have to
gt; gt; transpose all the information individually.
gt; gt;
gt; gt; Thanks

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

--
Regards,

Peo Sjoblom

(No private emails please)quot;Colleen Aquot; gt; wrote in message
...
gt; Thanks - I tried this but it changed all formats also - of course, I can
gt; always re-enter, right
gt;
gt; Colleen
gt;
gt; quot;Ron Coderrequot; wrote:
gt;
gt;gt; Have you tried this?:
gt;gt;
gt;gt; Select your range
gt;gt; Editgt;Copy
gt;gt; Select a cell outside of your range
gt;gt; Editgt;Paste Specialgt;Transpose
gt;gt;
gt;gt; Does that help?
gt;gt;
gt;gt; ***********
gt;gt; Regards,
gt;gt; Ron
gt;gt;
gt;gt; XL2002, WinXP-Pro
gt;gt;
gt;gt;
gt;gt; quot;Colleen Aquot; wrote:
gt;gt;
gt;gt; gt; I need to change the whole orientation of my spreadsheets... columns to
gt;gt; gt; rows
gt;gt; gt; AND rows to columns - does anyone know of a quick way, or do I have to
gt;gt; gt; transpose all the information individually.
gt;gt; gt;
gt;gt; gt; Thanks