ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Validation (https://www.excelbanter.com/excel-discussion-misc-queries/14466-data-validation.html)

Hardy

Data Validation
 
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

Peo Sjoblom

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





All times are GMT +1. The time now is 08:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com