Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do you edit and/or delete validations? I would like to add more cells to
a current validated list. I also would like to get rid of a validated list altogether Can anyone please help |
#2
![]() |
|||
|
|||
![]()
You can open it and select clear all to get rid of it, I would recommend
using a dynamic list if you add items http://www.contextures.com/xlNames01.html#Dynamic then refer to the named list in under allowlist -- Regards, Peo Sjoblom "Hardy" wrote in message ... How do you edit and/or delete validations? I would like to add more cells to a current validated list. I also would like to get rid of a validated list altogether Can anyone please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |