Excel help

[wolf63]

I know the answer to my question is probably in the 'help' pages of excel but I have been unable to find it.

I have a list of figures in vertical column and want to move the figures to a horizontal row.

o
o
o
o
o

to

ooooo

Is there a quick way of doing this?

It is actually for a friend - but I want to know too.

Thanks

[HowardKennitby]

this might help

http://www.howtogeek....n-excel-the-easy-way/

[MarkRae]

Go a Google search for Excel paste special transpose

[bibblebub]

use the mouse to paste and one of the ways offered is transpose which does exactly what you want

[wolf63]

Thanks guys - brilliant. Will pass this information on and take all the credit for it. :-)

[excelsior-1]

oh nuts!

wolf - you lovely lady, just goi in from work .. logged on and saw this post in the listings.
i thought wolf63 wants my help, i'd better see what i can do

oh well -- ego deflated now.

[Ann]

LOL @ Excel - I actually thought that too for a minute!

[excelsior-1]

good evening Ann
how are you?

[wolf63]

excel - did you put on your superhero costume and start to fly to my assistance?

Hope you had a good day at this 'work' thing. I tried it for 24 years and 33 days and then they discovered that I was nuts and pensioned me off. (You gotta love Civil Service final pay pensions). ;-) xx

I have sent the solutions to my problem on to my friend and he can try it out. Thanks

[bobmaucher]

Select the entire vertical set of figures.

Click the first (left-most) cell where you want to paste them.

Paste values, with transpose (press these keys one at a time: Alt E S V E Enter)

Viola!