Dropdown Values

S

Susie

How do you create a dropdown list (in a cell) for all records in a column?
For example, I want to pick a value of "Primary", "Secondary", or "Tertiary".
Thanks for your help!
 
T

Teethless mama

Data > Data Validation > Settings tab > Allow: select List > Source: type
Primary, Secondary,Tertiary
 

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

Word VBA - Automatic change content of a cell in table using dropdown list 5
Create own tool bar Mac 2015 0
Improving Nested Formula Calculation Efficiency 2
Access Backstage Reset DropDowns 0
Conditional Dropdowns on Steroids 1
Using list functionality 1
Drop-down calendar for sheet 0
Word macro that can call cells out of Excel for a find and replace 0

Top