Change rows to columns

[natasha]

Is is possible to change rows to columns in excel? I have
a spreadsheet reading right to left, and I want to take
information from one row and list it vertically instead.

for example:
"one two three four" (written in 4 separate cells)
becomes:

one
two
three
four

(again in four separate cells)

Please help!

Otherwise, do you know a way to take one long row of
information (over 30 cells horizontally) and re-arrange
it in one or two steps? I want to take that row of
information and send it on one piece of paper in an easy
to read format.

Thanks, Natasha

 

[Jason Morin]

Copy and Edit > Paste Special > Transpose.

HTH
Jason
Atlanta, GA

 

[perrink]

to

 

[Guest]

Is it possible to add a tooldbar button that does this?

 

[Dave Peterson]

I don't think that there's a built in icon that'll do this.

You could record a macro when you did it once and assign the macro to an icon
(or even a shortcut key).

But there is a "paste special" icon you could drag to your favorite toolbar.

You can find it:
tools|customize|Commands Tab|Edit category

(I find just rightclick|paste special is quicker than going up to the toolbar.)