Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 | | |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 | |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter data in a cell using a list I specify | New Users to Excel | |||
How do I enter data in an adjacent cell based on a list selection? | Excel Worksheet Functions | |||
How do you create a list & data validation in same cell? | Excel Worksheet Functions | |||
Create a list of data from same cell but different sheets | Excel Discussion (Misc queries) | |||
Create List based on cell data | Excel Discussion (Misc queries) |