 |
 | 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 / New Users / June 2004Create list to choose from
Hi, I'm just trying to create a short pulldown list in a spreadsheet. Instead of having to retype repetitve selections for this spreadsheet that gets used a lot, I'd like to create a pulldown list, but I'm not sure which kind of list to choose and I'm not sure how to enter the list. Can anyone help. Thanks a bunch. Diana Hi Dianah i'ld go with data / validation check out Debra Dalgleish's site for details http://www.contextures.com/xlDataVal01.html cheers JulieD > Hi, > I'm just trying to create a short pulldown list in a spreadsheet. Instead [quoted text clipped - 5 lines] > Thanks a bunch. > Diana Yes ... that's what I discovered. Now I need to figure out where I should store the list. Thanks Julie. > Hi Dianah > [quoted text clipped - 15 lines] > > Thanks a bunch. > > Diana Hi Dianah the common approach is to store the list on another sheet, name the list and then refer to the name of the list in the data validation source Cheers JulieD > Yes ... that's what I discovered. > Now I need to figure out where I should store the list. [quoted text clipped - 21 lines] > > > Thanks a bunch. > > > Diana |
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.