| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to rotate a list of numbers?
There is a list of numbers under column A, and I would like to rotate this
list from vertical into horizontal axis, such as A1 to A1 A2 to B1 A3 to C1 A4 to D1 .... Does anyone have any suggestions? Thank in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to rotate a list of numbers?
Copy your column of number and then click EDIT, select PASTE SPECIAL and the
click the TRANSPOSE check box at the bottom of the dialog box. -- Kevin Backmann "Eric" wrote: There is a list of numbers under column A, and I would like to rotate this list from vertical into horizontal axis, such as A1 to A1 A2 to B1 A3 to C1 A4 to D1 ... Does anyone have any suggestions? Thank in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to rotate a list of numbers?
On Fri, 22 Jun 2007 05:51:19 -0700, Eric
wrote: There is a list of numbers under column A, and I would like to rotate this list from vertical into horizontal axis, such as A1 to A1 A2 to B1 A3 to C1 A4 to D1 ... Does anyone have any suggestions? Thank in advance for any suggestions Eric You can do that with Edit Cut, Edit Paste Special, check transpose. You will probably need to paste into a different part of your sheet. Steve -- Steve Wolstenholme Neural Planner Software Ltd EasyNN-plus. The easy way to build neural networks. http://www.easynn.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Thank everyone very much for suggestions
Thank everyone very much for suggestions
Eric |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to rotate a list of numbers?
Steve
Just for info. Paste Special is not available with Cut cells. Just with Copied cells. Gord Dibben MS Excel MVP On Fri, 22 Jun 2007 14:13:26 +0100, Steve Wolstenholme wrote: You can do that with Edit Cut, Edit Paste Special, check transpose. You will probably need to paste into a different part of your sheet. Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change a vertical list of numbers to horizontal list from 1 cell | Excel Discussion (Misc queries) | |||
| how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) | |||
| rotate a list so that it is never in the same cell twice | Excel Discussion (Misc queries) | |||
| Rotate textbox | Excel Discussion (Misc queries) | |||
| How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) | |||
Linear Mode
