Take a column of numbers and automatically make them into a row

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

Guest

I want to take a column of numbers and instead of them being in a vertical
line, make them across the top without cutting and pasting each individual
cell is there a function to do this?
 
Hi

Copy the cells>Paste Special>Transpose.

If you are using XL2003 or lower, then your column of cells can't be greater
than 256, otherwise it won't transpose.
 
Back
Top