Excel droplist [Closed]

 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,

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!