Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to move Cells from Row to Colum
I have imported data from a csv file into Excel (2003). When it appears in
Excel all of the data are in cells accross the sheet. (All in Row 1). How can I move these cells so that they show up in one colum (Up and Down), it is much more easier to read and change. Thanks for any help |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to move Cells from Row to Colum
Select your row of data
Copy Select a cell below your data in the column you want to move to Paste Special Check the "Transpose" box Click OK You can then delete Row 1 HTH, Elkar "John" wrote: I have imported data from a csv file into Excel (2003). When it appears in Excel all of the data are in cells accross the sheet. (All in Row 1). How can I move these cells so that they show up in one colum (Up and Down), it is much more easier to read and change. Thanks for any help |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
How to move Cells from Row to Colum
Thank you for your anawer, that worked
"Elkar" wrote: Select your row of data Copy Select a cell below your data in the column you want to move to Paste Special Check the "Transpose" box Click OK You can then delete Row 1 HTH, Elkar "John" wrote: I have imported data from a csv file into Excel (2003). When it appears in Excel all of the data are in cells accross the sheet. (All in Row 1). How can I move these cells so that they show up in one colum (Up and Down), it is much more easier to read and change. Thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move merged cells with conditional formatting? | Excel Worksheet Functions | |||
Paste and automatically move cells | Excel Discussion (Misc queries) | |||
How do I set up a formula to repat 5 consecutive cells in a colum. | Excel Worksheet Functions | |||
How do I set up a formula to repeat 5 consecutive cells in a colum | Excel Worksheet Functions | |||
How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions |