Paste Problem

[Guest]

Until this morning I could copy cells with a formula containing a cell
reference and the cell reference would automatically be updated. Now, the
data and not the formula is copied and appears in the formula window.. For
Example,

A2 = C3 *1 A3 = C4 *2 C3 C4
10 50 10 25

If I copy select and copy cells A2:A3 to B2:B3 and paste from the clipboard
to cells B2:B3.

B2 B2 D3
D4
10 50 17 501

Fomerly, B2 = D3 * 1 and B3 = D4 * 4 would appear in the formula bar and
the data displayed in the cells would be B2= 17 AND B3 = 1002.
Where and what is the setting to return to the previous behavior?

Thanks

 

[Roger Govier]

Hi Ed

It sounds as through you have inadvertently pressed the option for Paste
Special>Values.
At the side of the Paste clipboard icon, there is dropdown arrow which
allows you to copy Formulas, Values, etc.
Just clicking the icon itself, the default behaviour would be to copy
everything about a cell's properties, including the formula contained
within it.