In Excell--- I want to rotate a table 90 degrees

  • Thread starter Thread starter james de memphis
  • Start date Start date
J

james de memphis

I need to rotate a spreadsheet (11 x 8 1/2)landscape to
be on a portrait (8 1/2 x 11).

Is it possible to rotate a spreadsheet?
 
you mean actually print it with what shows as the columns
being the rows and vice versa?

highlight the original table and as you have the last
cell highlighted, note in the NAME box on the upper left
the Row x Column numbers.

Select a range on another sheet that is exactly the flip
of those numbers (in other words, stretch until you get
the Row x Column to be the Column x Row of the original
size). When you have selected this new range, type
=TRANSPOSE(highlight the original area, making sure it's
the exact same size that you first checked).
Ctrl+Shift+Enter.

Done
 
Select the area you wish to transpose. Then Copy (CTRL-C)
and from the Edit Menu select Paste Special. Place your
cursor in the cell where you want the results to go. Click
the checkbox opposite Transpose and then click the OK
Button.
 
Back
Top