98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · High Priority · Version 2007
Wed 8 Apr 2009, 09:02Delegate Atif said...
Atif has attended:
Excel Intermediate course
Excel Advanced course
Excel
Can you tell me once I have created a v-look up formula, like in country name and oter details. How can I create a drop down button in country field so I can just choose the country rather then typing it.
Wed 8 Apr 2009, 09:12Trainer Amanda said...
RE: Excel
Hello Atif
Thank you for your question.
You can create a dropdown list using data validation (from the Data tab). Choose to create a list, then type your list entries into the box below, e.g. UK, France, Germany
Kind regards
Amanda
Wed 8 Apr 2009, 10:35Delegate Atif said...
RE: Excel
Thank you for your reply. I can see data validation under data tab, but can not see create a list option, can you help please?
Wed 8 Apr 2009, 10:42Trainer Amanda said...
RE: Excel
If you click the Data Validation button, select Data Validation again (if required) then on the Settings tab, select List from the dropdown arrow under Allow.
Hope this helps.
Kind regards
Amanda
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:Finding cells that have data restrictionsClick anywhere on the worksheet. |
