Microsoft Excel?

Question

How do I create a dropdown box with its values incorporated into the formula. I dont want to have the values hidden on the sheet or in another worksheet in the same document. Can this be done?

Answer 1

What office do you have? I have office 2007 and if you click on help and do a search for Drop down menu then it will tell you how to create one. For example this is what mine says:

To make data entry easier, or to limit entries to certain items that you define, you can create a drop-down list of valid entries that is compiled from cells elsewhere in the workbook. When you create a drop-down list for a cell, it displays an arrow in that cell. To enter information in that cell, click the arrow, and then click the entry that you want.

To create a drop-down list from a range of cells, use the Data Validation command in the Data Tools group on the Data tab.
To create a list of valid entries for the drop-down list, type the entries in a single column or row without blank cells.
Select the cell where you want the drop-down list.
On the Data tab, in the Data Tools group, click Data Validation.
Click the Settings tab.
In the Allow box, click List.
To specify the location of the list of valid entries, do one of the following:
If the list is in the current worksheet, enter a reference to your list in the Source box.
If the list is on a different worksheet, enter the name that you defined for your list in the Source box.
In both cases, make sure that the reference or name is preceded with an equal sign (=). For example, enter =ValidDepts.

Make sure that the In-cell drop-down check box is selected.
To specify whether the cell can be left blank, select or clear the Ignore blank check box.
Optionally, display an input message when the cell is clicked.

Bit confusing for me but try and use your help and search in office...it gives you piccies as well. Good luck

Answer 2

Lemme guess, you are in a computer Literacy classification... Possibly with the art Institute??? Considering whats humorous is that is the distinctive query of this weeks first mission. Weird. "Week three: Week three - W3: project 1 dialogue dialogue query 3 compare Microsoft phrase, Microsoft Excel, and Microsoft PowerPoint. When will have to you employ each of those functions? When can you use these functions interchangeably? Give examples and explanations to help your answer."

Answer 3

No, to create a drop down box, the permissable entries to be selected must be in an active cell somewhere. What is wrong with having this in a hidden area of the sheet ?

Answer 4

Lemme wager, you're in a pc Literacy classification... perchance with the artwork Institute??? because whats humorous is that is the precise question of this weeks first project. extraordinary. "Week 3: Week 3 - W3: project a million communicate communicate question 3 evaluate Microsoft be conscious, Microsoft Excel, and Microsoft PowerPoint. even as ought to you employ each and every of those applications? even as are you able to employ those applications interchangeably? supply examples and motives to help your answer."

Answer 5

go to Data > Filter > Autofilter