Hi everyone,

Is there anything / glitch that prevent the user from making data validation
as List in Excel?

I'm trying to make a form template that will have two different List in one
column. A1 is the List as Name for user easy to fill it out. A2 is the
header and A3:A100 is the a List of item selection.

The data validation of A3:A100 is fine, but I can't get A1 to works. Oh, by
the way, I also set A2 as autofill.

Any idea of why this happen?

I'm using Office 2004 for Mac.

thank you,
Neon520