Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training courses london - EXCEL
|
|
|
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 courses london - EXCEL
Resolved · Low Priority · Version Standard
Reply Tue 27 Feb 2007, 09:51Delegate Jaz said...
Jaz has attended:
Excel Intermediate course
Excel Advanced course
EXCEL
How do I use validation in cells?
For upcoming training course dates see: Pricing & availability
RE: EXCEL
Hi Jaz,
Validation in cells is where you will only allow a certain criteria of data to be input into a cell. You do this by highlighting where you want to put the validation in, then go into the Data menu and down to the option that says Validation then simply put in the options as to what you want to be input, there is also an option of editing the error message.
Have a look at that option and see what you think.
Tracy
|