Adding drop-down list to spreadsheet
 

Hello All-
I need to add a drop-down button to my worksheet. I'm trying to be able to
get the wkst user to be able to choose from the selections in the list. I
have tried everything and can't seem to figure it out. Anybody know how I do
this?
--
Thank you,

KDill

Adding drop-down list to spreadsheet
 

In the cell where the selection is to be made, use Data Validation. Select
List in the first drop-down then in the text box either type the allowed
values (separated by commas) or select a set of cells (from the same sheet)
containing those values.

"KDill" wrote:

Hello All-
I need to add a drop-down button to my worksheet. I'm trying to be able to
get the wkst user to be able to choose from the selections in the list. I
have tried everything and can't seem to figure it out. Anybody know how I do
this?
--
Thank you,

KDill

Adding drop-down list to spreadsheet
 

Data---Validation----Settings Tab---Allow List

In source: First thing in list,Second thing in list,etc.

-chris

"KDill" wrote:

Hello All-
I need to add a drop-down button to my worksheet. I'm trying to be able to
get the wkst user to be able to choose from the selections in the list. I
have tried everything and can't seem to figure it out. Anybody know how I do
this?
--
Thank you,

KDill

Adding drop-down list to spreadsheet
 

The list source can be on another worksheet if you give the listrange a Name and
use that Name in the source dialog

i.e. =MyList


Gord Dibben MS Excel MVP

On Thu, 29 Jun 2006 08:29:02 -0700, bpeltzer
wrote:

In the cell where the selection is to be made, use Data Validation. Select
List in the first drop-down then in the text box either type the allowed
values (separated by commas) or select a set of cells (from the same sheet)
containing those values.

"KDill" wrote:

Hello All-
I need to add a drop-down button to my worksheet. I'm trying to be able to
get the wkst user to be able to choose from the selections in the list. I
have tried everything and can't seem to figure it out. Anybody know how I do
this?
--
Thank you,

KDill