Excel Help Please!!!!

  • Thread starter Thread starter LauraC
  • Start date Start date
L

LauraC

I am wondering if anyone knows how to make a horizontal (row of data
into a vertical format (a column of data) so that the informatio
remains in the same order it original was left to right in a row bu
now in a column up and down
 
Laura, Paste Special will do just what you want:

1-Select the data.
2-Edit > Copy.
3-Select a destination cell.
4-Edit > Paste Special > Transpose > OK.
 
select data in row->copy->paste special->and in dialog box check transpose
 

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

Back
Top