Copying the values in a row to column

S

Sasikiran

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?
 
D

David Biddulph

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.
 
S

Sasikiran

Thank you very much David

David Biddulph said:
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.
Click to expand...
 
Top