Excel droplist

 Trowa -

In one sheet list of names will be there. While entering data in the second sheet data i would like to choose from drop list from sheet one. Is it possible to get data list from another sheet. Kindly help me.

1 reply

Hi KK,

First select the cell you would like your dropdown list to be available in.
From the top menu's choose Data then Validate.
From the Allow dropdown list choose List.
Now goto Source and select the data you want to be visible in your dropdown list, hit enter.

Enjoy your dropdown list.

Best regards,