Can I rotate my spreadsheet?

  • Thread starter Thread starter LAS
  • Start date Start date
L

LAS

I have a simple spreadsheet, one set of rows and columns. I would like to
re-organize it so the rows become the columns and the columns become the
rows. Is this possible?
 
Maybe -- if you have enough room.

If your data has 56,789 rows, then there won't be enough columns in any version
of excel to transpose the rows into columns.

But assuming that you do.
Create a new worksheet
Select the range on the old worksheet
Edit|Copy (in xl2003 menus)
Select A1 on that new sheet
Edit|Paste special|Check Transpose and click ok
 
Perfect!! Thanks!
Dave Peterson said:
Maybe -- if you have enough room.

If your data has 56,789 rows, then there won't be enough columns in any
version of excel to transpose the rows into columns.

But assuming that you do.
Create a new worksheet
Select the range on the old worksheet
Edit|Copy (in xl2003 menus)
Select A1 on that new sheet
Edit|Paste special|Check Transpose and click ok
 
Back
Top