Data validation

The UK's most regular instructor-led training courses.
Training information: microsoft-excel-courses · Microsoft excel training · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Data validation

Laura has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Laura [3 posts] (2008 Feb 14 Thu, 10:28) Reply

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.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: data validation

by - trainer Stephen gold contributer [283 posts] (2008 Feb 15 Fri, 16:03) Reply

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