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 » Data validation
Data validation
Resolved · Low Priority · Version 2003
Luisa has attended:
Excel Introduction course
Data validation
How do I validate a group of cells to create a list
RE: Data validation
Hi Luisa,
Creating a custom list in Excel can either be undertaken by typing the items directly or extracting the information from a pre-created column of data.
Go to Tools>Options, from the tabs choose Custom Lists and in the list entries box type your items separated by a comma, if you wish to use a pre-created list click the Import list from cells box and select (highlight) the required information in your worksheet, click the Import button and your items will be displayed in the List entries box. click OK and you will be able to use the list at any time (using the Fill button or the Edit>Fill commands... Pete
Wed 10 Dec 2008: Automatically marked as resolved.
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:Create own ribbon tab - Excel 2010a. In Excel click on the File tab |