Limiting Input in a Cell

M

Matt

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

Thanks,

Matt
 
K

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
 
M

Matt

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

David Byrne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
VB Script reference cells for in current table? 1
#DVI/0! Error 0
Split cells next to 1 cell 1
"The object was saved in an invalid format and cannot be read." 0
Preventing data input until a particular cell is used 3

Top