For creating Drop Down menu we have to create a template like A where we set the data of the B Drop-Downs

First, select the column where you want to set the drop-down

Click on “Data” and then click on “Data Validation”

Select the “List” from the options and click on the “Up Arrow” icon.

Now select the data form “Drop Downs” and press enter

Here Drop-Down is created and all data from the drop-down table section is seen in the drop-down list.
This is the simple data validation method we can create the data in a list like a drop-down menu

Leave a Reply

Your email address will not be published.