Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list starts from blank row
A drop down list referenced from another worksheet with a named range shows
the blank row after the last selection in the list when the drop down arrow is clicked in a blank cell in the data entry worksheet. help. thanks Jerry Bennett |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list starts from blank row
Go to the sheet with the list; select the range of valid entries and rename
this range to the name used in Data Validation. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Jerry Bennett" <Jerry wrote in message ... A drop down list referenced from another worksheet with a named range shows the blank row after the last selection in the list when the drop down arrow is clicked in a blank cell in the data entry worksheet. help. thanks Jerry Bennett |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list starts from blank row
That means you have an empty cell at the bottom of the source range. When
you click on a data validation drop down cell it automatically scrolls to the current selection. So, if the cell is empty it scrolls to the empty selection at the bottom of your list. Are you using a dynamic range as the source? If so, your calculation sounds like it's off by 1 cell. -- Biff Microsoft Excel MVP "Jerry Bennett" <Jerry wrote in message ... A drop down list referenced from another worksheet with a named range shows the blank row after the last selection in the list when the drop down arrow is clicked in a blank cell in the data entry worksheet. help. thanks Jerry Bennett |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list starts from blank row
thanks a lot, I understand now and have fixed the problem. I guess Excel
automatically assumes you are creating dynamic drop down lists, which is what i need, and i was creatiing a named range in the source list of say 200 cells to allow for additions, when I didn't have to. this all came about when I converted my 2003 sheet to 2007 and lost all the named ranges and drop down lists. thanks again, you saved me a lot of time best -- Jerry bennett Easthampton, MA "T. Valko" wrote: That means you have an empty cell at the bottom of the source range. When you click on a data validation drop down cell it automatically scrolls to the current selection. So, if the cell is empty it scrolls to the empty selection at the bottom of your list. Are you using a dynamic range as the source? If so, your calculation sounds like it's off by 1 cell. -- Biff Microsoft Excel MVP "Jerry Bennett" <Jerry wrote in message ... A drop down list referenced from another worksheet with a named range shows the blank row after the last selection in the list when the drop down arrow is clicked in a blank cell in the data entry worksheet. help. thanks Jerry Bennett |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list starts from blank row
Excel does not automatically use dynamic ranges for drop down lists. I'm not
sure about Excel 2007 but I haven't seen anything about it being any different than previous versions in that regard. See this for instructions on creating dynamic ranges: http://contextures.com/xlNames01.html#Dynamic -- Biff Microsoft Excel MVP "Jerry Bennett" wrote in message ... thanks a lot, I understand now and have fixed the problem. I guess Excel automatically assumes you are creating dynamic drop down lists, which is what i need, and i was creatiing a named range in the source list of say 200 cells to allow for additions, when I didn't have to. this all came about when I converted my 2003 sheet to 2007 and lost all the named ranges and drop down lists. thanks again, you saved me a lot of time best -- Jerry bennett Easthampton, MA "T. Valko" wrote: That means you have an empty cell at the bottom of the source range. When you click on a data validation drop down cell it automatically scrolls to the current selection. So, if the cell is empty it scrolls to the empty selection at the bottom of your list. Are you using a dynamic range as the source? If so, your calculation sounds like it's off by 1 cell. -- Biff Microsoft Excel MVP "Jerry Bennett" <Jerry wrote in message ... A drop down list referenced from another worksheet with a named range shows the blank row after the last selection in the list when the drop down arrow is clicked in a blank cell in the data entry worksheet. help. thanks Jerry Bennett |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list starts from blank row
Maybe it was a XL2007 Table - what was called List in XL2003
Suppose you make a Table (with Insert Table) and name it (say Mydata) then use =Mydata in a Validation. Later you enter a value under the last item in the Mydata table. Since it is a Table, it is dynamic and the Validation drop down includes the new item. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "T. Valko" wrote in message ... Excel does not automatically use dynamic ranges for drop down lists. I'm not sure about Excel 2007 but I haven't seen anything about it being any different than previous versions in that regard. See this for instructions on creating dynamic ranges: http://contextures.com/xlNames01.html#Dynamic -- Biff Microsoft Excel MVP "Jerry Bennett" wrote in message ... thanks a lot, I understand now and have fixed the problem. I guess Excel automatically assumes you are creating dynamic drop down lists, which is what i need, and i was creatiing a named range in the source list of say 200 cells to allow for additions, when I didn't have to. this all came about when I converted my 2003 sheet to 2007 and lost all the named ranges and drop down lists. thanks again, you saved me a lot of time best -- Jerry bennett Easthampton, MA "T. Valko" wrote: That means you have an empty cell at the bottom of the source range. When you click on a data validation drop down cell it automatically scrolls to the current selection. So, if the cell is empty it scrolls to the empty selection at the bottom of your list. Are you using a dynamic range as the source? If so, your calculation sounds like it's off by 1 cell. -- Biff Microsoft Excel MVP "Jerry Bennett" <Jerry wrote in message ... A drop down list referenced from another worksheet with a named range shows the blank row after the last selection in the list when the drop down arrow is clicked in a blank cell in the data entry worksheet. help. thanks Jerry Bennett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sometimes Excel starts but its screen is blank? | Setting up and Configuration of Excel | |||
WPEXCEL.XLS file always starts up (blank) when Excel opens | Excel Discussion (Misc queries) | |||
Drop Down List Ignore Blank | Excel Discussion (Misc queries) | |||
Ignoring Blank value in a drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |