Thread: How do I set up restrictions in my documents?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How do I set up restrictions in my documents?
Try Data Validation

Assume the restriction is to apply to data entry in col A

Select col A
Click Data Validation
Under Allow, choose Custom
Put in "Formula:" box: =A1<10
Click OK

Test it out ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"KANGYUES." wrote:
A restriction in my documents will be of a great help. For example, all
numbers in column D should be <10. This will surely help drastically in my
employees Data Entry work and also save time and effort.

Thanks.
Reply With QuoteReply With Quote