Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data validation
|
|
|
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. |
Data validation
Resolved · Low Priority · Version Standard
Reply Thu 14 Feb 2008, 10:28Delegate Laura said...
Laura has attended:
Excel Intermediate course
Excel Advanced course
Data validation
i'm having difficulty remebering how to assign a drop down box to a cell with options to click on to put text in the selected cell.
For upcoming training course dates see: Pricing & availability
RE: data validation
Hi Laura
Thank you for your question
If you select the cells that are to contain the data and then click on Data-validation.
In the resulting dialog box, select LIST in the allow data combo. You will then be given the option either to type each item of your list in, with each item separated by a comma.
Alternatively, if your list is entered at some point in the workbook then you can select the data by highlighting the relevant range of cells
Hope this is useful
Regards
Stephen
|