Use data validation in Excel

ShowMeAcademy.com - Use data validation in Microsoft Excel 2007

[@simplySumne]

That is simply wonderful dear. Thanks for the tutorial.
Have a big doubt thats even hard to explain.
I ahve a list and i have enabled the drop down list and since the list is huge there is a scroll bar formed. Can i just do it some way that i dont have that scroll bar and i get to see the whole list? in other words while in the dropdown, i dont want the scroll bar but wish to display all whole list.
hope its not a big challenge.
thanks dear.

[@CB-zd5jt]

this tutorial has helped me greatly. thanks!!!!!

[@rajahchandrajeethr824]

Fantastic explanation - thank u

[@Golden5648]

Thanks man!

[@Sbhabhi]

Thanks for the tutorial.

[@deodattakalamkar3324]

Hey Can anybody told me what are advantages of data validation

[@wapda2762]

Deodatta Kalamkar replying after a year
there is less chance of data being invalid and it makes your spreadsheet better in a way

[@simma36]

Good stuff. Thank you

[@Twoweebles]

Very helpful. Thanks

[@edwardbrashier5977]

ne

[@discoverNdive11]

Thanks for sharing

[@vidyagaikwad3798]

Ty so much sir

[@madhavmba1752]

just ok,but remaining incomplete

[@mallukatabu6193]

nice

[@majvfx7419]

hi bader

[@5lkgamer35]

hi

[@wearcrocstopub]

5lk gamer