rotate a sheet on its axis

[sramsey]

255 columns is not enough for me. I'm wondering if there is a way to rotate
my sheet 90 degrees so my columns are now rows and rows are now columns.

Thank You

 

[Yanick]

255 columns is not enough for me.  I'm wondering if there is a way to rotate
my sheet 90 degrees so my columns are now rows and rows are now columns.

Thank You

Copy all your data then Paste Special (with the option transpose
checked). It will do exactly what you need.

 

[Luke M]

Copy, then right-click, paste special, transpose.

 

[Bob I]

Copy, Paste Special, Transpose

 

[sramsey]

I found that option, but due to the design of this thing it's just not going
to work. I'm going to need over 1000 columns. Any other ideas? A 'rotate
sheet' option would be sweet.

Thanks

 

[Bob I]

yep, Excel 2007.

I found that option, but due to the design of this thing it's just not going
to work. I'm going to need over 1000 columns. Any other ideas? A 'rotate
sheet' option would be sweet.

Thanks

:

 

[Luke M]

Upgrade to XL 2007 (or 2010)?

Earlier versions have hard limit of not being able to have more than 256
columns (as in, you can't trade rows for columns). You'ld have to design your
sheet to be row based, rather than column based.