Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy a block of cells | Excel Discussion (Misc queries) | |||
How to copy cells horizontally to cells out of sequence | Excel Discussion (Misc queries) | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
How to copy block of cells and keep grouping? | Excel Discussion (Misc queries) | |||
loan calculator cells, P&I formulas do not copy to second cloumn | Excel Worksheet Functions |