<div>
From data-tab select data validation and make a list-criteria there.<br />
<br />
<a href="http://spreadsheets.about.com/od/datamanagementinexcel/qt/20071113_drpdwn.htm" rel="ugc">Step by step guide</a><br />

</div>


From data-tab select data validation and make a list-criteria there.

Step by step guide [http://spreadsheets.about.com/od/datamanagementinexcel/qt/20071113_drpdwn.htm]


<div>
Video tutorial:<br />
<a href="http://www.youtube.com/watch?v=wiRBARJmd4I" rel="ugc">http://www.youtube.com/watch?v=wiRBARJmd4I</a>
</div>


Video tutorial:
http://www.youtube.com/watch?v=wiRBARJmd4I [http://www.youtube.com/watch?v=wiRBARJmd4I]

<div>
Thanks for your help/research
</div>


<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
In excel 2003 there was the option to, when you right clicked on a data range, &quot;Create a List&quot;. I cannot find this feature in excel 2010. Do you know if it has been superseeded by something else or if im just being blind<br />
<br />
Beaumondo
</div>
</div>


Hi 

In excel 2003 there was the option to, when you right clicked on a data range, "Create a List". I cannot find this feature in excel 2010. Do you know if it has been superseeded by something else or if im just being blind

Beaumondo

How to create a list in excel 2010

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.