create list to enter data in cell
Try this:
Select the cell where you want this to happen
Goto the menu DataValidation
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
--
Biff
Microsoft Excel MVP
"Harvey" wrote in message
...
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
|