how to make a cell available for "pull down seletion" ?

[Martin]

I want to do this:


cell D2 PERSONAL SALARY
cell D3 1000-2000
2001-3000
3001-4000
over 4000

that is, I want to make CELL D3 a pull down seletion , in order to avoid the
users type numbers in it.

How?

Thanks!


Martin

 

[Pete_UK]

Select cell D3 then Data | Validation - this allows you to restrict
entries in a variety of ways, including a "List" which is what you
want. You specify where the source list is (on the same sheet) and in
this list you can type the values which are acceptable to your
spreadsheet.

Pete

 

[Gord Dibben]

You can have the list on a separate worksheet if you name the range.

Then refer to the named list by entering =NamedList in the source dialog box.


Gord Dibben Excel MVP