jojo wrote:
I know this question is dumb, but it's really bothering me:
In excel, when we need to apply a fomula repeatedly, we should just
drag
down the little square at the lower right hand side corner of a cell
that
contains the fomula, right? I've been using this basic function for
years,
but I don't know why it doesn't work in my new computer. The fomula
is
actually copied as I can see, but the numbers don't change
accordingly(it
copies the number result from the original cell), until I manually
double
click each cell. This happens 90% of the time, with another 10% of
time
working properly.
So is there any suggestion of what might be wrong with the excel
setting or
the computer? Please please help. I will really appreciate it!

Instead of the copy down, highlite the cell containing the formula you
want to copy to the new cells. ctrl C to copy.
Now highlite all the new cells you want to apply the same formulas to,
but with their respective referenced cells. Edit. Paste Special.
Formulas. OK.

Pierre