View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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?