Hello I have been using Excel 2003 for years now which has been working absolutely fine until today but it suddenly seems as though I have changed something fundamental - and I certainly didn't do it on purpose.

Now, when I copy a formula, it has suddenly started copying the value resulting from that formula instead of the formula. At the same time it will only let me copy the same number of cells. for example, I can't copy one cell down a whole column, or a row of formulae down several rows. I can only copy a single cell or the same shaped block. But even if that was working it wouldn't do me any good as I can't copy the formulae anyway.

I didn't know it was possible to change the defaults in this way and so would have no idea how to do it on purpose. I can't begin to imagine how I managed to do it.

Please can you tell me how to put it right. Many thanks, Julia

Optional Information:
Language (or Software): Excel

Already Tried:
As I said, I have no idea where to begin with this problem. Sorry