Change rows to columns

N

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
 
D

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.)
 
Top