How to use list from Data Validation in Microsoft Excel

List from Data Validation in Microsoft Excel

How to create a list from Data validation in Microsoft Excel?

This tutorial related to the question mentioned above which is in detail.

First of all Happy New year 2020 to all 

When a person has a large number of data and wants to save time, this option will help in time-saving. Because this option is the easiest way to use in forms filling. If you survey, research or belong to HR or any other field where you need to fill forms with the help of Microsoft Excel. You can use this option for different fields. For example, your form consists of Gender, Qualification, Marital Status or disease, etc.

Let explain how this option works in Microsoft Excel?

Step by Step

Open Microsoft Excel
Go to Data Menu
then go to Data validation

and select the data validation option from the list:

Then select the setting and open the drop-down menu.

Select the list and put the source data and then click on Okay.

Done!

For practical these steps watch the tutorial on our youtube channel or click below on the video.






Visit our facebook page Waseem Web Work
Or
visit our youtube channel Waseem Web Work