More Excel!

  steviegee 14:05 14 Dec 2007

If I have data within cells A1-Z1 how do I select them all to read downwards A1, A2 etc.....

  csqwared 14:15 14 Dec 2007

Try this
Select & Copy the cells you want to swop. Highlight the first cell wqhere you want the data to start, select "Paste Special" and tick the "Transpose" box. You will have to start the downward date in A2.


  steviegee 14:23 14 Dec 2007

Thankyou that worked.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy S9 review

ManvsMachine and other artists put Apple's iMac Pro to the test using powerful rendering tools

What to expect at Apple's 27 March education event

Comment filmer l’écran d’un iPhone ?