date validation

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date Validation

Date Validation

resolvedResolved · Low Priority · Version 2007

Jay has attended:
Excel Intermediate course
Excel Advanced course

Date Validation

On data Vaildation how do you do a list, i can see the option list but not sure where to enter in.



RE: Date Validation

Hi Jay

Thanks for getting in touch. To use Lists in Data Validation, do the following:

First select the cells you want to restrict data entry to. On the Data menu select Data Validation, then List. In the List box either select the cells that contain the items you need, or type in a list separated by commas.

If you wanted validation in cells A2:A30, and you had a range of possible answers in cells H1:H3, you'd start be selecting cells A2:A30, then going to Data > Data Validation. Choose the List option and then select cells H1 to H3. Click OK and A2:A30 should now have drop-down lists in.

I hope this helps, please let us know if you require further details.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL -
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Date Validation

thanks very good


Excel tip:

3D formulas find and replace

After you know all the components of a 3D reference, you can change them to suit by using a localised Find and replace crt+f, if need be.

View all Excel hints and tips

Server loaded in 0.07 secs.