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