Limiting Input in a Cell

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

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

Thanks,

Matt
 
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
 
Thank you very much for the help! I've never explored
Data Validation before. I appreciate it
Matt
 
Matt said:
How can I prevent a user from entering anything other
than "m" or "j" or "w" in a particular cell?

Thanks,

Matt
Click to expand...


Hi Matt,

Check out Data Validation

Explore And Enjoy

David Byrne

Melbourne
Australia
 
Back
Top