How do I create drop down form fields in Excel?
This was really helpfull thankyou
"Monica" wrote:
Hi Micki,
Basically what you need to do is:
- create a list of items/options you want to be displayed
- select the range of the list (highlight the list) and give it a name which
you have to type in the 'name box' in the top left corner end press enter
- select a range where you want the dropdown to appear and choose Data /
Validation / Settings, where you can choose the validation criteria: choose
'list' in 'allow' and as a source key in the name of the list (="name"). 'OK'
Hope that will help.
"Micki" wrote:
Is it possible to create dropdown lists in Excel? If so, how do I do it?
Thanks
|