 |
 | 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 / November 2007create list to enter data in cell
What I want to do is: when I select a cell I want a list of choices to come up to choose from. I then pick the item and it is entered into the cell. I saw in one of excel websites and I cannot figure out how to do it. Would appreciate any help. Harvey Try this: Select the cell where you want this to happen Goto the menu Data>Validation Allow: List Source: the source can be a range of cells like =A1:A5 or you can type them in separated by a comma like Joe, Sue,Bob,Tom,Lisa Make sure In-cell drop down is checked OK out  SignatureBiff Microsoft Excel MVP > What I want to do is: when I select a cell I want a list of choices to > come up to choose from. I then pick the item and it is entered into the > cell. I saw in one of excel websites and I cannot figure out how to do it. > Would appreciate any help. > Harvey Data>Validation>Allow:>List SignatureKind regards, Niek Otten Microsoft MVP - Excel | What I want to do is: when I select a cell I want a list of choices to come | up to choose from. I then pick the item and it is entered into the cell. I | saw in one of excel websites and I cannot figure out how to do it. Would | appreciate any help. | Harvey Just an added note. Excel has this built-in if you already have a list of items in a colulmn. Right-click on the cell and "Pick from list" You will have a choice of unique pre-entered items to select from. Gord Dibben MS Excel MVP >Data>Validation>Allow:>List > [quoted text clipped - 3 lines] >| appreciate any help. >| Harvey Thank you all I have set up my INVENTORY SHEET. I have just one more question I would like to enter all data just using the mouse. How do I set up a data validation list to have a number layout so I can punch in 100.00 or 99-65 (just examples)? Harvey > Just an added note. > [quoted text clipped - 15 lines] >>| appreciate any help. >>| Harvey
|
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.