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

A

AAD

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

Roger Govier

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