drop or paste to a cell problem

E

Eli Fadida

Hi,

When i copy (or drag) a cell and then paste (or drop) it ,the target cell
gets the value only.
This happenes even when I specify to paste the formula only...
Where did i go wrong ?

Thank you,
Victor
 
D

Dave Peterson

If I copy a range of cells from a filtered list (some hidden rows intermingled),
then the formulas convert to values when I paste (or ctrl-drag and drop).

Is your range filtered?
 
Top