Sharon,

Try setting your calculation mode to automatic: Tools / Options... Calculation tab, check
"Automatic"

HTH,
Bernie
MS Excel MVP


"Sharon S" <Sharon wrote in message
...
When I copy a formula down my spreadsheet, it returns the same results as the
top row even though it isn't justified anywhere. The only way I can get it
to work is F2 enter on each line!! Please Help! I have lengthy files and
this happens on and off for no reason that I know of.

Thanks!