Drop down list in excel?

J

jbahr

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Can you add a drop down list to select choices in Excel? For example, when people are entering data in a spreadsheet, one cell would have a drop down list from which they can choose from a variety of pre-determined answers.
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Can you add a drop down list to select choices in Excel? For example, when
people are entering data in a spreadsheet, one cell would have a drop down
list from which they can choose from a variety of pre-determined answers.
Click to expand...
Sure, select the cell, and then choose Validation in the data menu. Select
list, and type in the valid entries.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Drop down lists in seperate columns 5
Link a text box based on drop down box with four options MS Word 365 0
Drop Down menus 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
PROBLEM WITH PC CREATED EXCEL SPREADSHEET DROP DOWN MENU 1
Drop-Down List Greyed Out 1

Top