ExcelBanter - Dropdown Values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Dropdown Values (https://www.excelbanter.com/excel-worksheet-functions/123376-dropdown-values.html)

Susie

Dropdown Values

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!

Teethless mama

Dropdown Values

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

"Susie" wrote:

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!

All times are GMT +1. The time now is 03:54 AM.