Copying the values in a row to column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Excel 2007 - VBA To Sort Table And Copy To Another Sheet 2
Macro that uses a cell value to copy another cell 3
random pick names from the list 1
Excel Help to copy information from one row at a time to another sheet 1
How to reference to a column of data? 4
Merging multiple columns into one column (dynamically) 1
combining columns 4
Different kind of cell reference. 8

Back
Top