Thread View: microsoft.public.excel.misc
5 messages
5 total messages
Started by Lisa Trainor
Wed, 18 Nov 1998 00:00
drop down list
Author: Lisa Trainor
Date: Wed, 18 Nov 1998 00:00
Date: Wed, 18 Nov 1998 00:00
1 lines
69 bytes
69 bytes
What is the easy way to have a drop down list of choices for a cell?
Re: drop down list
Author: "David Hager"
Date: Wed, 18 Nov 1998 00:00
Date: Wed, 18 Nov 1998 00:00
7 lines
216 bytes
216 bytes
Data Validation (in Excel 97) with the list option. Regards, David Hager Lisa Trainor wrote in message <36537772.8A4C501D@aura.title14.com>... > >What is the easy way to have a drop down list of choices for a cell?
Re: drop down list
Author: "T.W.Thompson"
Date: Wed, 18 Nov 1998 00:00
Date: Wed, 18 Nov 1998 00:00
11 lines
405 bytes
405 bytes
Lisa, One easy way is if you are using XL97... From the Data menu select Validation Allow: = List Source = A range of cells that contain your list or to make a list without a range type in you choices separated with a comma (apples,oranges,pears) Regards, Thomas Lisa Trainor wrote in message <36537772.8A4C501D@aura.title14.com>... > >What is the easy way to have a drop down list of choices for a cell?
Re: drop down list
Author: "T.W.Thompson"
Date: Thu, 19 Nov 1998 00:00
Date: Thu, 19 Nov 1998 00:00
31 lines
1139 bytes
1139 bytes
Steve,
The following is pasted from the online help...
If the list of valid entries is in another worksheet or workbook, define a
name for the external data on the active worksheet.
In the Source box, you can then refer to the name on the same worksheet.
For example, if the data you want to use in a formula is in cells A6:A12 on
the first worksheet in a workbook named Budget.xls, you could define the
name ValidData on the active worksheet to be
=[Budget.xls]Sheet1!$A$6:$A$12 and then enter =ValidData in the Source box.
HTH,
Thomas
Steve Cox wrote in message ...
>Any way to get this drop down list to refer to a range on a different sheet
>within the same workbook. When I tried to select a range in another
>worksheet, it would'nt let me
>Merrill Lynch wrote in message <7317jd$nin$1@news.ml.com>...
>>Validation is the simplest. Note that in the Souce box you can type in a
>>simple list rather than point to a range, eg Red, Blue, Green
>>
>>Patrick Molloy
>>
>>
>>Lisa Trainor wrote in message <36537772.8A4C501D@aura.title14.com>...
>>>
>>>What is the easy way to have a drop down list of choices for a cell?
>>
>>
>
>
Re: drop down list
Author: "Merrill Lynch"
Date: Thu, 19 Nov 1998 00:00
Date: Thu, 19 Nov 1998 00:00
8 lines
296 bytes
296 bytes
Validation is the simplest. Note that in the Souce box you can type in a simple list rather than point to a range, eg Red, Blue, Green Patrick Molloy Lisa Trainor wrote in message <36537772.8A4C501D@aura.title14.com>... > >What is the easy way to have a drop down list of choices for a cell?
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads