Rotate Spreadsheet

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hello,

Is there a way to rotate an entire range of cells in a
spreadsheet from portrait to landscape. I do not mean
rotating for printing purposes but to rotate the actual
spreadsheet.

I have a intensive (full of values across a large range of
cells)spreadsheet that was created incorrectly and now has
to be rotated for insertion into a word doc. The
spreadsheet can be redone manually but I was hoping for a
easier way. Maybe with super-macro?

Thanks in advance,
David
 
How many rows do you have? If you've got more than 256, what your asking can't be done on one spreadsheet.
Otherwise, this will do it:
Select all the cells that contain information, then Edit|Copy
Click to the place you want the info to go (this location can't overlap with area you copied from) and pick Edit|Paste Special. Near the bottom right hand side of the box, click Transpose.

tj
 
Copy the range of cells you want to transpose. Go to
another tab in the workbook, choose paste special and
choose transpose at the bottom of the paste special window.
 
Back
Top