English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

In excel there is a function where you choose one option from many options given in a cell(from a drop down menu). How do we do it?

2006-07-27 22:53:20 · 5 answers · asked by vishnuenterprise 1 in Computers & Internet Other - Computers

5 answers

There are two ways to do that
1- When you type in names in a list, you can call a list of items entered before, by right click on that cell and select "Pick from list"
2- This is in "Data > Validation", but we need to do something before:
- You need to assign a name to the range of cells you want to be appear in the drop down menu, select the cells and in the formula bar you can see as pace where you see the address of the selected cell, click it and enter a name and press enter.
- Now, Select the cell you want to create a validation to, and go to Data >Validation > Settings > Allow > List
- In source type the equal mark and then the name you entered above
- Press Ok
- From now on, you can select the value by clicking the drop down menu.
- This is a validation to this cell, if you want to copy the validation into other cells, copy this cell and select the destination cells and got to Edit > Paste Special > Validation
- Mark me as best if you like this one

- Read my profile, I am XLMan

2006-07-29 00:02:09 · answer #1 · answered by Anonymous · 0 1

Data Validation is the best way to do this usually.

-Data | Validation...
-Under Allow choose List
-In the Source field either type the list (separated by commas) or refer to a range in the workbook.
-Make sure in-cell dropdown is checked
-Click OK

2006-07-28 14:54:44 · answer #2 · answered by O Caçador 6 · 0 0

From the 'Forms Toolbar' select a 'Combo Box'.

Format it and start using. I suppose thats what you are looking for.

2006-07-27 23:27:49 · answer #3 · answered by Dilip Rao 3 · 0 0

format cell? wfk ( who fuk knows lol)

2006-07-27 23:07:46 · answer #4 · answered by phill281 4 · 0 0

Don't understand your question.

2006-07-27 22:58:55 · answer #5 · answered by anti_money 2 · 0 0

fedest.com, questions and answers