| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet Restrictions | Excel Discussion (Misc queries) | |||
| How to do look up with restrictions | Excel Discussion (Misc queries) | |||
| excel documents won't open from my documents folder | Excel Discussion (Misc queries) | |||
| Excel Documents Don't Appear in My Recent Documents | Excel Discussion (Misc queries) | |||
| Restrictions to hyperlinks | Excel Discussion (Misc queries) | |||
Linear Mode
