Drag and Drop in Excel
 

while i drag a cell , values and validations continue to be replaced in other
cells. I want values to be replaced and Not validations. How to do it?

Drag and Drop in Excel
 

Hi,

Could you just elaborate on the Validation context. Give us a small example
please..

Challa Prabhu

"VT" wrote:

while i drag a cell , values and validations continue to be replaced in other
cells. I want values to be replaced and Not validations. How to do it?

Drag and Drop in Excel
 

Are you copying cells -- ctrl-drag and drop?

Try rightclick, ctrl-drag and drop. When you let go of the rightclick, you can
choose copy here as values only.

Or just use edit|copy, edit|paste special|values.



VT wrote:

while i drag a cell , values and validations continue to be replaced in other
cells. I want values to be replaced and Not validations. How to do it?

--

Dave Peterson