Donate SIGN UP

Excel

Avatar Image
catchinit | 12:53 Sun 25th Mar 2007 | Computers
1 Answers
Once a spreadsheet has been input, is it possible to turn the whole thing on its side so the top cells are down the left hand side?
Gravatar

Answers

Only 1 answerrss feed

Best Answer

No best answer has yet been selected by catchinit. 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.
To transpose columns to rows and vice versa select the area of the spreadsheet you wish to change and click Edit → Copy.

Select a new cell outside of the highlighted copy area, click Edit → Paste Special..., tick the box for Transpose and click OK.

Remove the original cells to leave the transposed version of your data.

Only 1 answerrss feed

Do you know the answer?

Excel

Answer Question >>