More Excel!

  steviegee 14:05 14 Dec 07
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 07

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 07

Thankyou that worked.

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

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…