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.
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

Top