Follow up to Excel spreadsheet rotation.?

Question

If you imagine the spreadsheet is on a piece of paper and you can pick it up and rotate it anti-clockwise 90 degrees, this is what I am trying to do to the spreadsheet within Excel... Is this possible?

Answer 1

Sure
You can do this in two ways:
1- Is using Copy and Paste Special > Transpose
Do this if you need to do this once
But If you want to do this on daily basis, then:
2- Do it using functions,
Assume you have your table in Sheet1 B4:F8, and you want to rotate it in Sheet2 C6:G10, then
in Sheet2 C6, paste this
=INDIRECT( ADDRESS( COLUMN( )+1,ROW( )-4,,, "Sheet1" ))
And fill into the column below and to the right.

PS1: This will work on these references only B4:F8 into C6:G10, if you have another references, then mail me here
PS2: This will work even if you have the list bigger than the example here, as long as it starts from B4
PS3: I do this as example to my students here

Yes, I can do these here, I am the VBAXLMan

Answer 2

Try this select you area right click mouse copy move mouse to a blank area choose edit from the menu bar then click paste special and tick the box at the bottom called transpose

Answer 3

Select the cells.
Click Edit, then Copy (or Control+C).
Position cursor in the top right cell of where you want to put the new cells.
Click Edit, then Paste Special.
Check Transpose box.
Click OK.

Answer 4

There doesn't seem to be a function specifically for rotating, but you could copy and paste special using a 'transpose' operation.

Answer 5

Copy the area
right click
past special
transpose

save before you start