98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training+london - Pivot tables
microsoft+excel+training+london - Pivot tables
Resolved · Low Priority · Version Standard
Russel has attended:
Excel Intermediate course
Excel Advanced course
Pivot tables
how do I create a validation rule
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.
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. |
Excel tip:Quickly select a block of dataTo quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8. |