How to Convert same horizontal row to vertical row in Excel?

W

Winnie

Is there anyway to "Copy" a horizontal row in Excel
and "Paste" it as a vertical column in Excel?
 
T

trip_to_tokyo

1. In EXCEL 2007 in cells A 21 to E 21 I type:-

a b c d e

(one letter in each cell).

2. Highlight cells A 21 to E 21 inclusive.

3. Ctrl-C to copy.

4. Go to cell I 8 for example (this can be any cell you like).

5. Home / Paste / Transpose

The letters a to e inclusive will now appear in cells I 8 to I 12 inclusive.

Is the above what you want?

If it is please click Yes.

Thanks.
 
A

Arvi Laanemets

NB! Something to be aware of!

The source range (the row you want to transpose from) and target range (the
column you want to transpose to) mustn't intersect! So when you want to
transpose the whole row, the destination must be on different sheet.


Arvi Laanemets
 

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

Borders Rotating 90 Degrees 1
format Column with horizontal alphabet label 3
Auto Filter in Row dimension 1
How to transpose data (Row to column) without losing the cell link 3
Error bars in scatter plots 2
2 Horizinotal axes in Excel 2007 8
Making touchpad's Horizontal Scroll region work in Excel/Word 2007 1
cross-hares 3

Top