I make to write in a cell list validation?

[Carlos V]

I have a cell is ready of data but sometimes nees to write thing and not to
use the smooth one sometimes and if but the book to use every month clean it
and I return it to use.



Since I make to write in a cell list validation?



Carlos

 

[Harald Staff]

Hi Carlos

I'm not very sure I understand what you want, but I'll give it a shot:

For a custom list, go Data > Validation, "Allow: List" and in "Source" write something
like
Carlos,Harald,Jenny,Maria
(use semicolons instead of commas if those are your regional list delimiters).

To permit other entries than your list content, uncheck "show error alert" in the tab
"Error alert" in the same wizard.