More Excel!

  steviegee 14:05 14 Dec 2007
Locked

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.

cc

  steviegee 14:23 14 Dec 2007

Thankyou that worked.

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

Elsewhere on IDG sites

What is ransomware and how do I protect my PC from Petya?

Microsoft Surface Studio – the artist's hands-on review

Original iPhone review

Comment mettre à jour Kodi ?