Attendance Calendar 2005 in xl templates

[graphage]

I have a question about an Excel Template. I searched for "calendars" in my xl help file. I found a template called "Attendace Calendar 2005". There is a feature that I can't figure out.

If you look at this template, you'll see the boxes for each month, w/ the dates listed for each month. Under each date, there is an empty cell designed to have a one-letter code entered to represent the reason the employee was absent. When you click on one of those empty cells, a drop down arrow appears. You can then click on the arrow and see the list of codes.

How did they create that drop down list?? I've tried to dissect this thing and can't figure it out.

Any ideas?

Thanks!

Here is a link to it on the Microsoft site:
http://office.microsoft.com/en-us/templates/TC011887561033.aspx?CategoryID=CT061995981033

 

[Andywiz]

The drop down lists are created using Data Validation, with the values referenced from the one-letter codes at the foot of the entry tables.

search on data validation in excel's help files - it's relatively straight forward to do.

Andywiz