Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training+london - Pivot tables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft+excel+training+london - Pivot tables
Resolved · Low Priority · Version Standard
Reply Fri 16 Nov 2007, 17:10Delegate Russel said...
Russel has attended:
Excel Intermediate course
Excel Advanced course
Pivot tables
how do I create a validation rule
For upcoming training course dates see: Pricing & availability
RE: pivot tables
Hi Russel, Thanks for the post, I hope you enjoyed your courses, in response to your question; to create a validation rule, now which one is my question? If you go to the menu command Data and choose Validation you will open a dialog box which will give you a number of choices, choose the type of validation you wish to apply to the cell and follow the steps that are indicated. dont forget to add a pre-entry message or instructions and also a message which will display if the entry is incorrect. I hope that answers your question, best regards Pete.
|