hello, can somebody else help me with this problem?

i'm currently using excel 2016 and there is my problem

at cell B6 I type "rabbit", B7 = "dog", B8 = "frog"

I go to cell C6 using this formula "="B6" then it shows "rabbit"

then i drag it down to C8, but the outcomes for C7 and C8 is "rabbit" i'm not using lock cell at formula ($B$7)

i go to cell C7, i press F2 then enter it change into "dog" same as at cell C8. the formula I used doesn't execute automatically.

please help me to fix it. maybe it does problem with my settings at Excel.