Data validation

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,309
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on May 17, 2009

How to create drop down lists in Excel with data validation. Also a little side bit at the end for how to use the auto-complete function to help with data entry in conjunction with data-validation.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • @memyselfandani Excels auto-complete does have a bit to be desired. It will only work once it realizes that there is no other options. So if you have "wall" and "wall plate" it will not auto-complete "wall" because there is another option.

  • Great tip about the auto-complete. why didn't I think of that?

    For some reason the auto-complete doesn't work with every record. I have 3,000 records. It only seems to work when the first few characters are unique.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more