There are basic instructions on the Getting Started page, and many other techniques, such as Dependent Drop Down Lists, and showing a popup Combo Box when a data validation cell is clicked.There are many tips in the following sections, for working efficiently with data validation, and troubleshooting tips for when things go wrong.Another option is to use a macro, to clear the dependent cell, after making a selecting in the first drop down. In this example, column B contains a drop down list of Regions.Create a drop down list of items in a cell, with Excel's Data Validation feature.
Then, the first and second selections are mismatched -- for example, in the screen shot below, Vegetable is the first choice, and Banana is selected in the second column.
This can be very useful because now you can use one sheet to store all of your reference lists like a database and use them on any other sheet in the workbook. This can be on the same sheet or on a differnet sheet.
I went ahead and selected cell A1 on Sheet2 for the example.
Well sometimes you can type it in incorrectly or you might have a long list of different types of expenses and incomes, so this can be a pain to maintain and remember. First, create a new workbook and on Sheet1 start off in row 1, column 1 (A1) and type in a few expense categories in the column. Now that you got your reference list, go ahead and select the cells with the data in them. Left click on A1 and hold the mouse button down and drag until you get to A8. Now in the box next to the formula textbox on the left (also called the Name box), type in a name for your list and press Enter. Doing this basically gives the cells from A1 to A8 a name so that the group of cells can now be referenced by a name rather than saying A1 through A8. Now we can use our list to create a dropdown menu with those values.
An easy solution in Excel is to create your own dropdown list of choices pulled from a particular column on the same sheet or another sheet. First select the cell where you want your dropdown list to be created.