Using a simple formula, B2*C2. When dragging down to fill cells in a column
I get the result of the first cell as far as I drag. This only occurs on a
particular spreadsheet I received from a co-worker. If I go into another
cell and Press F2 and enter the results are ok for that cell now.

Is there a certain setting on the spreadsheet that makes this happen?
Appreciate any tips