CopyPaste SpecialTranspose will do what you want.

If you are not using Excel 2007 beta and you have more than 256 rows, you cannot
swap this way.


Gord Dibben MS Excel MVP

On Wed, 23 Aug 2006 16:17:02 -0700, Shivaraj
wrote:

I have created a tradeshow layout in excel but i want to rotate the whole
layout so it is facing up and down insteat of left to right.

Is it possible to select a group of cells and then rotate them?

thank you,

shivaraj