dropdown list view in Excel

DIPAK AGARWAL (Service) (554 Points)

07 May 2009

What is the septs to create a Drop down list view in Excel. So that while entering repetavive data can be selected from that list as input.

Reply
Follow
Share

3 Replies

jeevan (Manager) (40 Points)
Replied 07 May 2009

S1. Enter the data in column wise at some place of the workbook.

S2. go to the cell where you want the drop down list and do the following

S3. In excel go to Data - validation - allow- list

S4. in source field select the data you have entered in S1.

Thats it you can do more validation by using this option

DIPAK AGARWAL (Service) (554 Points)
Replied 07 May 2009

Originally posted by :jeevan
"	S1. Enter the data in column wise at some place of the workbook. S2. go to the cell where you want the drop down list and do the following S3. In excel go to Data - validation - allow- list S4. in source field select the data you have entered in S1. Thats it you can do more validation by using this option	"