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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Drag and Drop an Outlook email into Excel? 5
Can I drag a validated cell down the column w/a different input/ro 1
Numbers change in cell even when formatted as text 4
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data validation accepts illegal entries when one spreads values 5
Drag and drop data only?? 2
Drop down / validation / lookup into the same cell 2
drag and drop editing 3

Back
Top