copying/filling formulas

kimbo

New Member
Joined
Apr 10, 2002
Messages
38
I have a simple formula in a cell. I dragged it down. This should copy the formula (and not the value) into each cell below.

The value in every cell below comes out same, although the formula should yield different values. As such, it appears that Excel copied the value rather than the formula.

However, when I click on each cell individully, the formula appears in the formula bar.

In other words, the values in the cells and the formulas in the formula bar do not match.

I'm getting the same problem when I copy and paste the formula rather than filling it down. That is, it copies the value but the formula appears in the formula bar.

When I re-type the formula into each cell below (i.e, rather than copying or filling down), the correct value is then yielded.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

kimbo

New Member
Joined
Apr 10, 2002
Messages
38
Recalculating with F9 worked. I didn't know about that. Thanks.

I can go ahead this way. However, now I'm wondering why this is happening now for the first time.
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
Go into the tools options menu, calculation tab and make sure calculation is set to automatic. Otherwise you will have to manually recalc by pressing F9

Hope this helps
 

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
Try a find and replace using "=" (without quotes) for the find what and replace with

HTH
 

kimbo

New Member
Joined
Apr 10, 2002
Messages
38
That was the source of the problem. Tools-Options-Calc Automatic.

Didn't know about that setting.

Danke schoen, as they say in Germany.

I will close out the topic now.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,919
Messages
5,545,027
Members
410,647
Latest member
bernardazar
Top