Can I rotate excel sheets so columns are rows & vice-versa (i.e..

Can I rotate excel sheets so columns are displayed as rows & vice-versa (i.e.
to get 256 rows & 65 536 columns)
I want to make a project calender with dates across the top - so I need at
least 365 columns - preferably more.

no. columns are fixed at 256 and rows at 65536. no
rotating.
i would suggest that instead of 12 months row that you do
2 6 months rows or 3 4 month rows or 4 3 month rows.

>-----Original Message-----
>Can I rotate excel sheets so columns are displayed as
rows & vice-versa (i.e.
>to get 256 rows & 65 536 columns)
>I want to make a project calender with dates across the
top - so I need at
>least 365 columns - preferably more.
>.
>

you may want to try using msproject for your stated
purpose

Rgds,


>-----Original Message-----
>Can I rotate excel sheets so columns are displayed as
rows & vice-versa (i.e.
>to get 256 rows & 65 536 columns)
>I want to make a project calender with dates across the
top - so I need at
>least 365 columns - preferably more.
>.
>

copy-pastespecial-transpose

if there are formulas the formulas will not be copied


JamesR <[email protected]> wrote in message
news:[email protected]...
> Can I rotate excel sheets so columns are displayed as rows & vice-versa
(i.e.
> to get 256 rows & 65 536 columns)
> I want to make a project calender with dates across the top - so I need at
> least 365 columns - preferably more.