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

date validation

ResolvedVersion 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.

regards

Jay

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 - https://www.stl-training.co.uk
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:

Seeing named ranges as part of the zoom

If you have large areas of named ranges this works better.

If you zoom down to 39% you will see your named range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.