| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Validation question in 2007
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Validation question in 2007
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 pcor wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Question | Excel Worksheet Functions | |||
| data validation in Execl 2007 | New Users to Excel | |||
| Data validation Excel 2007 | Excel Worksheet Functions | |||
| Question on Validation | Excel Worksheet Functions | |||
| Validation Question....Can this be done? | Excel Discussion (Misc queries) | |||
Hybrid Mode
