Validation question in 2007

  • Thread starter Thread starter pcor
  • Start date Start date
P

pcor

If I click on Col B I and select DATA/ Validation I get the message:The
selection contains more than one type of validation. Erase current and
continue?"
My question is: How can I find out what data validation are currently in use.
Thanks
 
Hi,

You can use Goto Special cells .
CTRL+G displays dialog
Special...
Check Data validation.

You can then select all cells with data validation or this with the same
data validation as the activecell.

Cheers
Andy
 
Back
Top