Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list shows first blank row after last list entry
When selecting the drop down list for my referenced list on another
worksheet, I get the blank row after the last list entry and have to page up to find my selection. this doesn't happen on all columns with list selections. Changing the name on the source worksheet or in the data validation does not fix it, nor does copying the source data over to another column and trying to rename it to the original name. Also, when doing this this original named range disappears from the name range list, but when I go to try and use it again it says it is already in use. this seems like a simple thing, but like all things with Microsoft, nothing is simple -- Jerry Bennett |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list shows first blank row after last list entry
Hi Jerry,
I'm assuming this is a data validation list, in which case, if the list is : .. typed into the validation dialogue box, you haven't added a comma after the last entry .. referenced by a formula, the chosen range matches the list range. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Jerry Bennett" wrote in message ... When selecting the drop down list for my referenced list on another worksheet, I get the blank row after the last list entry and have to page up to find my selection. this doesn't happen on all columns with list selections. Changing the name on the source worksheet or in the data validation does not fix it, nor does copying the source data over to another column and trying to rename it to the original name. Also, when doing this this original named range disappears from the name range list, but when I go to try and use it again it says it is already in use. this seems like a simple thing, but like all things with Microsoft, nothing is simple -- Jerry Bennett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i add a new entry to an existing drop-down list in Excel? | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
Can a user select more than one entry in a drop down list? | Excel Worksheet Functions | |||
Auto-complete an entry in drop-down list | New Users to Excel | |||
drop down list - save the entry | Excel Discussion (Misc queries) |