How do I set up restrictions in my documents?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KANGYUES. - 26 Dec 2007 09:55 GMT

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 to this Message

Max - 26 Dec 2007 11:03 GMT

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 ..

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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 to this Message

Max - 26 Dec 2007 11:06 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

KANGYUES. - 27 Dec 2007 04:46 GMT

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

> Oops, you did say col D
>
[quoted text clipped - 4 lines]
> > Put in "Formula:" box: =D1<10
> > Click OK

Reply to this Message

Max - 27 Dec 2007 05:39 GMT

welcome, glad it helped.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

Reply to this Message

Rate this thread: