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.courses.in.london - Drop down lists
microsoft.excel.courses.in.london - Drop down lists
Resolved · Low Priority · Version Standard
Jason has attended:
Project Intro Intermediate course
Excel Intermediate course
PowerPoint Introduction course
Drop down lists
how do you create one like for a RAG status - Red, Amber, Green
RE: drop down lists
Dear Jason
Thanks you for attending Excel Intermediate and Project training.
Creating dropdown list in Excel is quiet simple than it seems. Please follow these steps:
Step1: Select the cells that you want the drop down lists in.
Step 2: Choose Data > Validation... from the menu bar
Step 3: In the Validation Criteria section, from the Allow: Choose "List"
Step 4: Once you have done that Source section should appear. Type your list, in your case, type Red, Amber, Green
NB: You have to separate your choices by putting, (comma).
If you have entered the value somewhere else on the same worksheet then you are allowed to select those cells rather than typing the entries manually. But please be aware that it you or somebody else deletes that column then the data in eth list will be deleted as well.
Another important thing to note here is that if you have a lot of information to enter as your list it would be better to type it out in Word using commas. Then you can simply use the shortcut commands Ctrl+C to copy in Word and come to Excel and in the data Validation dialog box in the source box use CTRL+ V to paste. This is particularly helpful if you already have information in the source box in the Data validation and you are trying to add extra data to your lists.
Hope this helps!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
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:Fill formulae across a sheetTo copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet. |