create 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

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

create list to enter data in cell
 

DataValidationAllow:List

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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
|
|

create list to enter data in cell
 

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

On Thu, 1 Nov 2007 22:07:12 +0100, "Niek Otten" wrote:

DataValidationAllow:List

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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
|

create list to enter data in cell
 

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



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Thu, 1 Nov 2007 22:07:12 +0100, "Niek Otten"
wrote:

DataValidationAllow:List

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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
|