Excel -8 | Excel data validation and Drop Down list

Today i will show you how to validate data and how to make drop down list is Excel 2016. Excel can restrict data entry to certain cells by using data validation, prompt users to enter valid data when a cell is selected, and display an error message when a user enters invalid data. A drop-down list is a graphical control element, similar to a list box, that allows the user to choose one value from a list. When a drop-down list is inactive, it displays a single value. When activated, it displays a list of values, from which the user may select one.

Видео Excel -8 | Excel data validation and Drop Down list автора Анализ операционных данных Excel