Use Data Validation (and perhaps place your list on another worksheet):
http://www.officearticles.com/excel/...**********Hope it helps!Anne Troywww.OfficeArticles.com"earljoe" wrote inmessage ... I am creating a time sheet and I want to either creat a droplist but I think I will have too many entries it has to be in 15 min increments for the 24 hrs. I got it up to 10:45 am from midnight but it wont let me make any more entries. Either that or I need a way that the ( : ) does not need to be entered to keep the formulas working correctly. Can anyone help? -- earljoe ------------------------------------------------------------------------ earljoe's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=31174 View this thread: http://www.excelforum.com/showthread.php?threadid=508340