Donate SIGN UP

Excel

Avatar Image
turboped | 23:05 Thu 20th Jul 2006 | Technology
2 Answers
Any idea how to copy a list in a column across the rows?
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by turboped. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Select the cells in the column list -- rightclick | copy

Then put the cursor in the cell at the left of where you want the list in a row.

right-click or menu bar edit | paste special | tick TRANSPOSE | OK

That should do it. Works both ways and will move row to column or vice versa.
Question Author
Cheers. Many Thanks.

1 to 2 of 2rss feed

Do you know the answer?

Excel

Answer Question >>