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

G

Guest

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.
 
R

R.VENKATARAMAN

copy-pastespecial-transpose

if there are formulas the formulas will not be copied
 
G

Guest

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.
 

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

interchange columns with rows 2
Freeze multiple rows/columns in Excel 2007 11
Flipping data - columns to rows and visa versa 2
Can I rotate data in Excel table (rows to columns, and vv)? 6
how do i transpose a worksheet with formulas and look up tables in 5
columns and rows 1
Is there a convienent way I can exchange a table's rows and columns? 3
How do I reverse the row order in Excel, not based on content? 2

Top