Truthfully, the quickest and easiest solution is to use the built in form wizard. This approach provides the least functionality, and will not allow drop downs, validations, etc. The link for this method is here: http://spreadsheets.about.com/od/exc..._data_form.htm

Another approach is to actually build a userform. This will require some VBA knowledge, and a time investment. Here is a good beginners guide. http://www.contextures.com/xluserform01.html