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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top