How do I set up restrictions in my documents?
 

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.

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.

How do I set up restrictions in my documents?
 

Oops, you did say col D

It should read:
Select col D
Click Data Validation
Under Allow, choose Custom
Put in "Formula:" box: =D1<10
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

How do I set up restrictions in my documents?
 

thanks a whole lot! u solved the hassle of needing to check through my
employees' work thoroughly!

"Max" wrote:

Oops, you did say col D

It should read:
Select col D
Click Data Validation
Under Allow, choose Custom
Put in "Formula:" box: =D1<10
Click OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

How do I set up restrictions in my documents?
 

welcome, glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"KANGYUES." wrote in message
...
thanks a whole lot! u solved the hassle of needing to check through my
employees' work thoroughly!