Excel 2007 : Copying whatever the value is in cell....w/o -->

[THORmx]

Hi,

Is there a way to copy stuff in cells that have data-validation in them, and ONLY COPY the numbers/words etc in the cells without copying the validation too? I would like to know for like, 1 cell...or a click and drag of MULTIPLE CELLS.

Thanks in advance!!!!

[DonkeyOte]

see: Paste Special

ie Copy -> Paste Special -> Values

(you can repeat the Paste Special operation 1+ times for one Copy command... ie to Paste Values & then say Column Widths etc...)

[THORmx]

Thanks so much Donkey!!

Mod's, please mark as solved