Excel droplist

KK - Sep 3, 2010 at 01:35 AM
 Trowa - Sep 3, 2010 at 09:36 AM

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 response

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,