Transposing columns

[Guest]

I would like to transpose Column A to Column B....how do I do that in Office
2003?

 

[Guest]

Copy the column and then move the point to the cell where you want the data
to start in and click EDIT in the menu, select PASTE SPECIAL and place a
check in the TRANSPOSE check box. Click OK to complete.

 

[Steve]

I would like to transpose Column A to Column B....how do I do that in Office
2003?

Right Click in Column B, Paste Special, Transpose


Steve

 

[Peo Sjoblom]

Select column B, right click header and select cut, then select A header
and right click and select insert cut cells.

--


Regards,


Peo Sjoblom

 

[Gord Dibben]

One more.....

Select column B.

Slide cursor down to side of B1 and you will get a 4-headed arrow.

Hold SHIFT + click and move to left.


Gord Dibben MS Excel MVP