SilenTScopE
New Member
- Joined
- Sep 18, 2008
- Messages
- 3
Ok so let's say I have numbers in cells A1 to A10. Now I want all those numbers to be copied to cells C5 to C15. I used Excell 2 years ago (could have been excel 2000 or 2003). Now 2 years ago, all I had to do was take cell C5 and put in the formula box "=A1". Then for cell C6, I would put "=A2" and for cell C7, "=A3". Then, i could select cells C5 to C7 and fill (I think that's the word. I mean pressing on the little black square on the bottom right corner and extending it to other cells) the cells up to C15. Excel would figure out the pattern of the formula in the first 3 cells and extend it to the next cells. Now, I have excel 2007 and if I try this, it will not work. Now, when I use the little black square, it just copies the formula to the other cells, it doesn't continue the pattern of the formula.
Is this an option I can turn on somewere? I can't do anything without this function.
Is this an option I can turn on somewere? I can't do anything without this function.