If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the Data tab on the ribbon, and created the rule in the Data Validation dialog ...
Keyboard shortcuts can supercharge your productivity - if you know what they are. Here are 55 essential shortcuts every Windows user should know.