Is there an easy way to rotate an Exel sheet?

  hastelloy 12:41 23 Jan 07
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 07
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 07

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

  hastelloy 12:56 23 Jan 07

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now