 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / August 2007Drop down list Q
My drop down list, when opened for selection, always displays the last half dozen entries, therefore I have to scroll up to find the one I want, rather than scrolling down. Why would this be?  SignatureTraa Dy Liooar Jock It sounds like your Data Validation is based on a list that includes blank cells at the bottom. Since the DV cell is already blank, it's matching the 1st blank cell in the source range. You should either base the list on the actual list items (with no blanks) OR base the DV on a Dynamic Range Name....which automatically expands and contracts to accommodate the data. Debra Dalgleish has Dynamic Range Name instructions at her website: http://www.contextures.com/xlNames01.html#Dynamic Am I on the right track? SignatureTry something like this: From the Excel main menu: <><><> Is that something you can work with? Does that help? *********** Regards, Ron XL2003, WinXP > My drop down list, when opened for selection, always displays the last half > dozen entries, therefore I have to scroll up to find the one I want, rather > than scrolling down. Why would this be? Absolutely on the right track. There is a blank cell at the bottom of my list. Thanks Ron SignatureTraa Dy Liooar Jock > It sounds like your Data Validation is based on a list that includes blank > cells at the bottom. Since the DV cell is already blank, it's matching the [quoted text clipped - 12 lines] > > dozen entries, therefore I have to scroll up to find the one I want, rather > > than scrolling down. Why would this be? OK, how can I automatically extend the drop down list to show all options and lose the scroll bar? Thanks, SignatureTraa Dy Liooar Jock > My drop down list, when opened for selection, always displays the last half > dozen entries, therefore I have to scroll up to find the one I want, rather > than scrolling down. Why would this be? See this website for instructions: http://www.contextures.com/xlDataVal10.html Does that help? *********** Regards, Ron XL2003, WinXP > OK, how can I automatically extend the drop down list to show all options and > lose the scroll bar? [quoted text clipped - 3 lines] > > dozen entries, therefore I have to scroll up to find the one I want, rather > > than scrolling down. Why would this be? Thanks Ron. SignatureTraa Dy Liooar Jock > See this website for instructions: > http://www.contextures.com/xlDataVal10.html [quoted text clipped - 13 lines] > > > dozen entries, therefore I have to scroll up to find the one I want, rather > > > than scrolling down. Why would this be? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.