Pop-up menu with valid values

  • Thread starter Thread starter Pedro
  • Start date Start date
P

Pedro

Hello!

I am trying to configure a Excel cell to allow the user
to input only a set of valid values.

For example, the cell should contains only RED, YELLOW and BLUE.
I would like that the end user sees a popup menu associated
to the cell with those different values and he selects one of them.

It is simple, but I did not manage to create it. Anyone knows
how to do it ?

Many thanks in advance.

Pedro
 
Pedro,

You need Data Validation (Off the Data menu), and select the List option.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top