Drag and Drop in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi,

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

Challa Prabhu
 
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.
 
Back
Top