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!