HOW DO I INSERT A MULTICHOICE SELECTOR IN EXCEL?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ROBBIE1962 - 28 Mar 2008 12:59 GMT

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

Reply to this Message

Gary''s Student - 28 Mar 2008 14:22 GMT

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

Signature

Gary''s Student - gsnu200776

> 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

Reply to this Message