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

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

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

Find values across a row and return a text value from the same column 2
Row of numbers adding incorrectly. 4
How do I move items from columns into rows without cut/paste? 1
don't want cell numbers to change when pasting formulas 3
Sorting a list of numbers 4
Transpose a col to a row? 3
How to create a list of media files names in excel. 2
Combining data from multiple worksheets into one 4

Top