Creating drop downs in a spread sheet

[Meagans93]

Hi good morning,

I was wondering if there is a way to put only specific items to chose from for a column. For example

In column B. I want to be able to choose only from 3 options. Red, White, Blue. and then in column H I also want to be able to choose only from High Priority , Low Priority.


My coworkers all have the same spreadsheet that they keep their information on. I have to go to each spreadsheet and copy the info and add it to my master spreadsheet.
I am trying to keep formatting for these spreadsheets as streamlined as possible.

Thanks in advance for your help.

 

[mumps]

Using Data Validation, you can select a "List" and then enter the options separated by commas for each drop down list.