HOW DO I INSERT A MULTICHOICE SELECTOR IN EXCEL?

R

ROBBIE1962

I AM TRYING TO INSERT A MULTIPLE CHOICE SELECTOR INTO AN EXCEL WORKSHEET. IE
"HOW MANY PEOPLE 1, 2 OR 3, TO BE SELECTABLE LIKE WHEN WINDOWS GIVES YOU A
CHOICE OF 3 OPTIONS
 
G

Gary''s Student

A TYPICAL APPROACH IS TO USE DATA VALIDATION. CLICK ON THE CELL AND PULL-DOWN:

DATA > VALIDATION > ALLOW > LIST
THEN POINT TO A LIST OF VALID INPUTS
 
Top