How To: Use data validation with a list in Excel

Use data validation with a list in Excel

This video shows you how to idiot-proof a data set in Excel pretty much. It demonstrates how to enable data validation in a cell, so that when you type something in it must be in a predetermined list or will not work. Start by typing in your data table in a second tab. His example is a date, then information about certain employees based on that day. To enter the data validation menu, click the cell you want to use and then hit ALT+D+L to bring it up. Go to settings, then under the Allow menu. Un-check the in-cell drop down button, and then click on List under the Allow menu. Type in the source for your data table, and hit enter. Now when a date is typed in, it must be in the list or it will not work.

While you're stuck at home, make the most of your time by learning a new language, skill, or even train for a remote-work job with our new premium online courses.

Check them out >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest