If you’ve ever wanted to stop typos from creeping into your spreadsheets, knowing how to use the Excel data validation list feature is the fix. Instead of letting people type anything into a cell, a drop-down list restricts entries to a predefined set of options, so “Yes” never becomes “yess”...
