DROP DOWN LIST

C

CA

I am working on a spreadsheet that requires a choice between Yes or No. There
are 4 tabs for each area I cover, all spreadsheets contain the same basic
information; template where the areas will need to be populated. How can I
do a drop down menu for a range of cells in each of the tabs of this one
workbook?
 
T

T. Valko

Select the cells where you want the drop downs to appear.
Goto the menu Data>Validation
On the Settings tab, Allow>List
As the source type in the desired items separated by commas:

Yes,No

Make sure "In-cell dropdown" is checked
OK out
 

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

Formatted cell column in drop down list 1
Using drop-down lists 4
Odd Drop Down Box Behavior 4
Dependent drop down dynamic range formula, off sheet. 7
Navigating between worksheets using a drop down menu 4
Drop Down with dynamic named range offsheet source list 14
Maximum number of data validation cells? 3
I need the percentage of objects used in a drop-down box 2

Top