One way is to use Data Validation
If I knew more of what you are needing I could help a little more

"Robin Chapple" wrote:

I have a spreadsheet where a default in a field is changed by a double
click. A second double click will return the field to the default.

I only need the field to show the 'default' or the 'alternate' entry.
No other entry is needed.

How do I prevent an operator from entering text?

Thanks,

Robin Chapple