| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Cells
I have a spreadsheet with text in A1, A2, A3, A4, A5, A6, ..... and so on.
I would like to have the text in each one of those fields run down the left side for example A1, B1, C1, D1, E1, F1, G1, H1, I1, etc.... Can this be done? Thanks ! Ty |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Moving Cells
Select all the appropriate cells in Column A, Copy, select B1, on the Edit
menu select Paste Special, Transpose. Delete Column A. HTH -- Sincerely, Michael Colvin "Ty" wrote: I have a spreadsheet with text in A1, A2, A3, A4, A5, A6, ..... and so on. I would like to have the text in each one of those fields run down the left side for example A1, B1, C1, D1, E1, F1, G1, H1, I1, etc.... Can this be done? Thanks ! Ty |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| stop mouse highlighting cells when moving pointer without pushinganything | New Users to Excel | |||
| moving cells based certain value | New Users to Excel | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| instead of moving cells my arrow keys scroll the page | Excel Discussion (Misc queries) | |||
Linear Mode
