| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add drop down choices to a spreadsheet?
I have figured out how to get drop downs in my spreadsheet but I can not
figure out how to be able to re-use the same one in different boxes over again. When I put in a selection from a drop down, it takes it away from being one of the choices on my list for the next one. I hope someone can help! I am very frustrated! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add drop down choices to a spreadsheet?
See http://www.contextures.com/xlDataVal03.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" <Wendy @discussions.microsoft.com wrote in message ... I have figured out how to get drop downs in my spreadsheet but I can not figure out how to be able to re-use the same one in different boxes over again. When I put in a selection from a drop down, it takes it away from being one of the choices on my list for the next one. I hope someone can help! I am very frustrated! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add drop down choices to a spreadsheet?
I want to be able to reuse the entries over and over. It is a spreadsheet of
codes and the codes may need to be entered more than once. Wendy "Bob Phillips" wrote: See http://www.contextures.com/xlDataVal03.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" <Wendy @discussions.microsoft.com wrote in message ... I have figured out how to get drop downs in my spreadsheet but I can not figure out how to be able to re-use the same one in different boxes over again. When I put in a selection from a drop down, it takes it away from being one of the choices on my list for the next one. I hope someone can help! I am very frustrated! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add drop down choices to a spreadsheet?
You can use a named range as the source, as described he
http://www.contextures.com/xlDataVal01.html Then, the list items won't disappear as you move down the worksheet. Or, if you select a range on the worksheet, use absolute references, so the range won't adjust as you move down. For example, instead of: =A1:A10 use =$A$1:$A$10 Wendy wrote: I want to be able to reuse the entries over and over. It is a spreadsheet of codes and the codes may need to be entered more than once. Wendy "Bob Phillips" wrote: See http://www.contextures.com/xlDataVal03.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" <Wendy @discussions.microsoft.com wrote in message ... I have figured out how to get drop downs in my spreadsheet but I can not figure out how to be able to re-use the same one in different boxes over again. When I put in a selection from a drop down, it takes it away from being one of the choices on my list for the next one. I hope someone can help! I am very frustrated! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add drop down choices to a spreadsheet?
Oh, I thought it was the other way.
Just use absolute references in you range, such as $A$1 not A1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" wrote in message ... I want to be able to reuse the entries over and over. It is a spreadsheet of codes and the codes may need to be entered more than once. Wendy "Bob Phillips" wrote: See http://www.contextures.com/xlDataVal03.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" <Wendy @discussions.microsoft.com wrote in message ... I have figured out how to get drop downs in my spreadsheet but I can not figure out how to be able to re-use the same one in different boxes over again. When I put in a selection from a drop down, it takes it away from being one of the choices on my list for the next one. I hope someone can help! I am very frustrated! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add drop down choices to a spreadsheet?
I have that - this is how I have the range
=$A$1:$E$25 It still doesn't work. I have been working on this for a while and can not get it to work. "Bob Phillips" wrote: Oh, I thought it was the other way. Just use absolute references in you range, such as $A$1 not A1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" wrote in message ... I want to be able to reuse the entries over and over. It is a spreadsheet of codes and the codes may need to be entered more than once. Wendy "Bob Phillips" wrote: See http://www.contextures.com/xlDataVal03.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" <Wendy @discussions.microsoft.com wrote in message ... I have figured out how to get drop downs in my spreadsheet but I can not figure out how to be able to re-use the same one in different boxes over again. When I put in a selection from a drop down, it takes it away from being one of the choices on my list for the next one. I hope someone can help! I am very frustrated! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I add drop down choices to a spreadsheet?
Surely you get an error with that, a list must be one row or one column, not
multi in both dimensions. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" wrote in message ... I have that - this is how I have the range =$A$1:$E$25 It still doesn't work. I have been working on this for a while and can not get it to work. "Bob Phillips" wrote: Oh, I thought it was the other way. Just use absolute references in you range, such as $A$1 not A1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" wrote in message ... I want to be able to reuse the entries over and over. It is a spreadsheet of codes and the codes may need to be entered more than once. Wendy "Bob Phillips" wrote: See http://www.contextures.com/xlDataVal03.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" <Wendy @discussions.microsoft.com wrote in message ... I have figured out how to get drop downs in my spreadsheet but I can not figure out how to be able to re-use the same one in different boxes over again. When I put in a selection from a drop down, it takes it away from being one of the choices on my list for the next one. I hope someone can help! I am very frustrated! |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I choose multiple choices from a drop down box?
Is this possible in MS Excel 2007? I'm talking about a similar function as
on websites. TY Carol "Bob Phillips" wrote: Surely you get an error with that, a list must be one row or one column, not multi in both dimensions. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" wrote in message ... I have that - this is how I have the range =$A$1:$E$25 It still doesn't work. I have been working on this for a while and can not get it to work. "Bob Phillips" wrote: Oh, I thought it was the other way. Just use absolute references in you range, such as $A$1 not A1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" wrote in message ... I want to be able to reuse the entries over and over. It is a spreadsheet of codes and the codes may need to be entered more than once. Wendy "Bob Phillips" wrote: See http://www.contextures.com/xlDataVal03.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Wendy" <Wendy @discussions.microsoft.com wrote in message ... I have figured out how to get drop downs in my spreadsheet but I can not figure out how to be able to re-use the same one in different boxes over again. When I put in a selection from a drop down, it takes it away from being one of the choices on my list for the next one. I hope someone can help! I am very frustrated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit drop down list and linking to other info | Excel Worksheet Functions | |||
| Drop down list includes hyperlink | Excel Discussion (Misc queries) | |||
| How do I create a form with drop downs that narrows choices? | Excel Discussion (Misc queries) | |||
| Drop down list with multiple choices | Excel Worksheet Functions | |||
| Dynamic Drop Down Boxes | Excel Worksheet Functions | |||
Linear Mode
