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

Link a text box based on drop down box with four options MS Word 365 0
Font drop-down menu very slow 0
Drop down list control value in vba 2
Drop down lists in seperate columns 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Cross reference drop down not activating 1
drop down list 1
Formatted cell column in drop down list 1

Top