| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rotate a sheet on its axis
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotate a sheet on its axis
On Jan 15, 12:30*pm, sramsey
wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotate a sheet on its axis
Copy, then right-click, paste special, transpose.
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sramsey" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotate a sheet on its axis
Copy, Paste Special, Transpose
sramsey wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotate a sheet on its axis
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" wrote: Copy, then right-click, paste special, transpose. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sramsey" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotate a sheet on its axis
yep, Excel 2007.
sramsey wrote: 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" wrote: Copy, then right-click, paste special, transpose. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sramsey" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotate a sheet on its axis
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sramsey" wrote: 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" wrote: Copy, then right-click, paste special, transpose. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "sramsey" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rotate / Change axis of chart? | Charts and Charting in Excel | |||
| Rotate axis titles in Excel | Excel Discussion (Misc queries) | |||
| Excel - 3D coordinates, how can I rotate about an axis? | Excel Discussion (Misc queries) | |||
| How to rotate more than one level of category axis labels? | Charts and Charting in Excel | |||
| rotate data from x axis to y axis | New Users to Excel | |||
Linear Mode
