Subject: Schooboy Excel help

I have a load of random numbers in different cells going vertically down the page.

Any quick way of transposing these figures so they go horizontally instead?

I'm sure there is, but i keep getting distracted by Nick Toons on the TV and i think it's damaging my brain, or something.

probably or something.

copy
edit
paste special
transpose

Legend, ta.

and relax

;)

Now i am trying to use relative cell references...

in one cell i have the formula ='17'!F65529 and i want to copy this down so it copies formulas from across the other page.

If i put a $ sign before or after the F it just keeps everything the same, any idea why?

When you have a formula in a cell, if you click and drag that cell vertically or horzontally the reference will be incremented by how many cells you've moved it.

If you put a $ sign in the formula (ahead of the column or the row) it will stop this incrementing.

Maybe an exemple will help:
say you put 1 in A1 and '=A1" in A2... now click and drag A2 down (drag the little square of A2 at the bottom right corner)... A3 becomes 0, A4 becomes 0... look at what A3 and A4's formula are saying in the formula box...

Now put 1 in A1 and '=$A$1' in A2 and repeat the drag thingy... you get 1 everywhere.


Once you become familiar with this, you can put the $ only before the column or only before the row in a formula to get what you want from excel...
(edited)

I understand how it works fella, but i want to able to make ='17'!L65529 to ='17'!M65529 and so on as i copy the formula down the page.

I have experimented with relative cell reference, and cannot place the $ sign in a place that will give me this.

What am i missing?

remove all $ signs?!

If i remove all $ signs this: ='17'!T65529 becomes this: ='17'!T65530

---

send me your spreadsheet...

sk mail

Mailed you.

mailed you a second time with a fix :)

Cheers lots for that solution...i may reformat the spreadsheet like that anyway :o)

Jeez, is that the time?

*runs off to bed*