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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin - 20 Dec 2005 01:27 GMT

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

Reply to this Message

Pete_UK - 20 Dec 2005 01:43 GMT

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

Reply to this Message

Gord Dibben - 20 Dec 2005 03:00 GMT

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

>Select cell D3 then Data | Validation - this allows you to restrict
>entries in a variety of ways, including a "List" which is what you
[quoted text clipped - 3 lines]
>
>Pete

Reply to this Message