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