Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change contents of list dropdown
I find using lists for data validation very handy, but also very
confusing. This is what allows me to have a dropdown containing possible cell values. Defining and altering these lists seems very odd and awkward. I managed to get a set of lists working, so that they show in the dropdown. However, I needed to add an entry to the top of one of the lists. So, I added a row before the first one, but when I click the dropdown arrow on cells referencing that list, it still shows the old list. What do I have to do to get the cells to use the new list? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change contents of list dropdown
If you insert a row above row 1, it pushes your list down, so it starts
on row 2. The data validation list automatically adjusts, to use the list that now starts on row 2, and ignores what you added in row 1. You could insert a row within the list, and it would be automatically included in the data validation list. Or, use a dynamic range, which will expand as you add new items. There are instructions he http://www.contextures.com/xlNames01.html david.karr wrote: I find using lists for data validation very handy, but also very confusing. This is what allows me to have a dropdown containing possible cell values. Defining and altering these lists seems very odd and awkward. I managed to get a set of lists working, so that they show in the dropdown. However, I needed to add an entry to the top of one of the lists. So, I added a row before the first one, but when I click the dropdown arrow on cells referencing that list, it still shows the old list. What do I have to do to get the cells to use the new list? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change the length of the dropdown list used to cell entries | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
How do I show the contents of a dropdown without showing the box? | Excel Worksheet Functions | |||
Can I import a folder's contents as a dropdown list? | Excel Worksheet Functions |