Allowing Only Certain Entrees

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the spreadsheet as a tracking mechanism, how do I format a cell so
it will only take a certain entry. For example, the formula is set to only
count s1 or s2 or s4. If someone hits s5 one data entry, I want the cell to
reject it.
Thanks
 
hi
click the cell which will take the input then on the menu bar...
Data>validation>follow the wizard.
to learn more, on the menu bar...
help>type validation>click designate valid cell entries.

Regards
FSt1
 
Take a look at the Validation entry in XL Help ("About setting
restrictions on cells and displaying input and error messages")
 

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

Search multiple values & return single value - seperate worksheets 4
use of wildcards in conditional formatting 4
Sort Columns of data at the same time, without regard to order. 3
Dynamic RecordSet Field Name 4
Lookups... 3
Using SumProduct on multiple lines 2
Vlookup / Match / Hlookup / Array fundtion or What? 5
Help writing a query 4

Back
Top