| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying the values in a row to column
Hi,
I have a list of values in a row of range for suppose D1:D30. I need to copy and paste the values to a column F1:F30. How can I do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying the values in a row to column
D1:D30 is a column, not a row.
If you have elements in a row, such as D1 to AG1, you can copy, then edit/ paste special/ transpose (but the copy and paste areas can't overlap, so you can't use F1, but you can paste it lower and then move it upwards. -- David Biddulph "Sasikiran" wrote in message ... Hi, I have a list of values in a row of range for suppose D1:D30. I need to copy and paste the values to a column F1:F30. How can I do that? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying the values in a row to column
Thank you very much David
"David Biddulph" wrote: D1:D30 is a column, not a row. If you have elements in a row, such as D1 to AG1, you can copy, then edit/ paste special/ transpose (but the copy and paste areas can't overlap, so you can't use F1, but you can paste it lower and then move it upwards. -- David Biddulph "Sasikiran" wrote in message ... Hi, I have a list of values in a row of range for suppose D1:D30. I need to copy and paste the values to a column F1:F30. How can I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Cell Values | Excel Discussion (Misc queries) | |||
| Copying cells with similar column values | New Users to Excel | |||
| copying trade values | Excel Discussion (Misc queries) | |||
| Copying values into another cell | Excel Discussion (Misc queries) | |||
| keeping certain values the same when copying | Excel Worksheet Functions | |||
Linear Mode
