Is there an easy way to rotate an Exel sheet?

  hastelloy 12:41 23 Jan 2007
Locked
Answered

I have an Exel file which has names along the top and events attended down the side. I need to change it so that names are down the side and events along the top. There are no calculations involved. Is this possible or do I have to start from scratch? All suggestions gratefully received.

  VoG II 12:44 23 Jan 2007
Answer

Select your data and Copy it.

Move to a blank part of the worksheet and use Edit > Paste Special > Transpose.

  s99Raj 12:44 23 Jan 2007

Go to the Help section in Excel and look up a function called TRANSPOSE.

  hastelloy 12:56 23 Jan 2007

Isn't it easy when you know how? Thanks to both for a very fast, effective response.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Converse draws on iconic heritage for a fresh brand identity

Mac power user tips and hidden tricks

Comment lancer Windows 10 en mode sans ├ęchec ?