Limiting Input in a Cell

[Matt]

How can I prevent a user from entering anything other
than "m" or "j" or "w" in a particular cell?

Thanks,

Matt

 

[Kieran]

Matt,

The data validation function will allow you to do this.

Select the required cells.
Goto Data > validation.
Select the 'list' option in teh dropdown box.
enter m,j,w in the list area.
select ok

That's it

 

[Matt]

Thank you very much for the help! I've never explored
Data Validation before. I appreciate it
Matt

 

[David Byrne]

How can I prevent a user from entering anything other
than "m" or "j" or "w" in a particular cell?

Thanks,

Matt

Hi Matt,

Check out Data Validation

Explore And Enjoy

David Byrne

Melbourne
Australia

 

[Guest]

Data validation, select text