Cell Drop Down in Excel

[Zeusie]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I cannot find clear instructions about how to create a cell with a set of drop down value choices (1,2,3,4,5...) that can serve as input variables for formulas in other cells. Prior responses have said "go to data validation" but there isn't enough detail in help or in the posts to walk me through creating the reference list and setting up the cell with dropdown. Anyone able to provide this or point to a reference that does. I was able to do it easily using the Windows version but the Mac version is elusive. Thanks.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I cannot find clear instructions about how to create a cell with a set of
drop down value choices (1,2,3,4,5...) that can serve as input variables for
formulas in other cells. Prior responses have said "go to data validation"
but there isn't enough detail in help or in the posts to walk me through
creating the reference list and setting up the cell with dropdown. Anyone
able to provide this or point to a reference that does. I was able to do it
easily using the Windows version but the Mac version is elusive. Thanks.

Here's one way:

On Sheet1, enter the numbers one to 10 in A1:A10. Select A1:A10, then,
in the name box (at the left side of the formula bar, type a range name,
say, "my_range" and press enter.

In Sheet2, select cell A1. Choose Data/Validation... In the Settings
pane, choose "List" from the Allow dropdown. In the Source input box,
enter

=my_range

and click OK.

When you select the dropdown arrow in cell A1, you'll see the values
1-10.