Only 2 options in a cell

  • Thread starter Thread starter RobertLees
  • Start date Start date
R

RobertLees

Hi

I have a cell in which the only options are "Work" and "Home".

How do I do this?

Thanks
Robert
 
somewhere far in the sheet enter the 2 options in lets say AA1 and AA2
Now in the cell where you want the option, select the cell, go to Data >
Validation > List, and select the range AA1:AA2.

Mangesh
 
You could also just embed that list into the data|validation dialog.

Select the cell(s) and do data|Validation
Allow: List
Source: Work,Home
 
Back
Top