Restricting values of cell to the ones on scrolldown list exclusiv

  • Thread starter Thread starter Jorge E. Jaramillo
  • Start date Start date
J

Jorge E. Jaramillo

Hi

I know how to make a scrolldown list so that people can choose options from
it to enter into a cell, but the problem is that if by accident someone would
type anything while on that cell, the cell would accept such entry. Even
worse, the connection to the scrolldwon list would be lost.

Is there a way to restrict such action? I mean that the cell would only
allow the values from the scrolldown list and nothing else?

Thanks

Jorge E Jaramillo
 
Hi

I know how to make a scrolldown list so that people can choose options from
it to enter into a cell, but the problem is that if by accident someone would
type anything while on that cell, the cell would accept such entry. Even
worse, the connection to the scrolldwon list would be lost.

Is there a way to restrict such action? I mean that the cell would only
allow the values from the scrolldown list and nothing else?

Thanks

Jorge E Jaramillo
Click to expand...

Jorge,

Use a data validation list, linked to the list of available values
somewhere else on your sheet.
This restricts the values to those on the list.

Regards

David
 
Back
Top