Data Validation

**antoni** · 01-14-2010, 11:03 PM

Hello anyone can help me please..
I use Data Validation on my Sheet, and I have choose Validation Criteria (Allow) = List and the Source. but why the combo List is not appeared when i move the mouse to the cell ?

Thanks b4

**Paul** · 01-14-2010, 11:26 PM

Hi Antoni,

Next to the 'Allow' drop-down box where you selected List, did you check the box labeled "In-cell dropdown"?

Also, for the source, did you set it to a range of cells or a named range as required?

**antoni** · 01-14-2010, 11:45 PM

Thanks Mr. Paul..
Yeah, I have check the box labeled "In-cell dropdown" and Also, for the source, and i have set it to a range of cells or a named range as my required.

But, I have successful with this step :

I try to Close and Save the File, and then open the Excel, choose File - Open.
Select the file and On the Open Button on the Right Bottom, and then Click the Arrow.
Click Open and Repair and click Repair.