copy cells which are horizontal to verticle
 

Hi,
How do I copy a set of cells which are horizontal to verticle or vice versa?
For example:

A B C D E F G H I J
1 a
2 b
3 c
4 d
5
6

To become

A B C D E F G H I J
1 a b c d
2
3
4
5
6

Thanks.

copy cells which are horizontal to verticle
 

You could copy the selection and then use paste special and check the
transpose check box on the bottom right corner of the dialog box.

Ed


--
nuver
------------------------------------------------------------------------
nuver's Profile: http://www.excelforum.com/member.php...o&userid=10036
View this thread: http://www.excelforum.com/showthread...hreadid=486471

copy cells which are horizontal to verticle
 

Thanks that worked.
Is there a short cut key for paste special?

"nuver" wrote:


You could copy the selection and then use paste special and check the
transpose check box on the bottom right corner of the dialog box.

Ed


--
nuver
------------------------------------------------------------------------
nuver's Profile: http://www.excelforum.com/member.php...o&userid=10036
View this thread: http://www.excelforum.com/showthread...hreadid=486471

copy cells which are horizontal to verticle
 

Ivano

You can add the toolbar button (Right click on any toolbar and select
customize... and look under the edit category and when you find it, just
drag and drop it on a toolbar)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Ivano" wrote in message
...
Thanks that worked.
Is there a short cut key for paste special?

"nuver" wrote:


You could copy the selection and then use paste special and check the
transpose check box on the bottom right corner of the dialog box.

Ed


--
nuver
------------------------------------------------------------------------
nuver's Profile:
http://www.excelforum.com/member.php...o&userid=10036
View this thread:
http://www.excelforum.com/showthread...hreadid=486471