transposing numbers.

  • Thread starter Thread starter Rimma
  • Start date Start date
R

Rimma

I wonder if anyone can help.
I have a list of numbers that are sorted in numerical
order. I typed them from up to botom. I would like to
display them horizontally instead.
For example, they look like this:
1
2
3
4
5
I would like them to look like this:
1 2 3 4 5

Can someone help?

Thanks in advance
 
Rimma said:
I wonder if anyone can help.
I have a list of numbers that are sorted in numerical
order. I typed them from up to botom. I would like to
display them horizontally instead.
For example, they look like this:
1
2
3
4
5
I would like them to look like this:
1 2 3 4 5

Can someone help?

Thanks in advance
Click to expand...

Copy the vertical list of numbers. Click on the cell where you want the
first number to be and use Edit > Paste Special > Transpose.
 
Back
Top