rotate a sheet on its axis

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
 
Y

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

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

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
 
B

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

:
Click to expand...
 
L

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rotate image fill within shape 1
Two columns followed by single page-width column on same page 0
Setting column width in a table with a macro is not working 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
How to rotate graph 90 degrees 1
Shape Fill Help 3
How to set a rotating shift schedule for 4 crews with repeat occurrence? -SOLVED 1
Need a text box to rotate 90 degrees. 4

Top