rotate a sheet on its axis

  • Thread starter Thread starter sramsey
  • Start date Start date
S

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
 
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
Click to expand...

Copy all your data then Paste Special (with the option transpose
checked). It will do exactly what you need.
 
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
 
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

:
Click to expand...
 
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.
 
Back
Top