When completing tables we may offer some items to be selected from the list of options using the Data Validation. You can ensure that users always selects one of the values and no other, or perhaps let Excel to calculate a formula or format the cells in a table right by the selected option. Whether in a single cell, or an entire column, validation list (or drop-down list) is very useful and help users to facilitate their work. How to do it? Learn in this video. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too.
Please note that this tutorial is presented in czech language.