Change the name for Sheet1 to 'DataEntry'.

This example will have a workbook with two sheets - a data entry sheet, and a sheet with lists. There are a few steps for setting up the drop-down lists, and the details are in the sections below.

Then, in column C, a dependent drop-down list shows items for the selected product type only.

Select a produce type (fruit or vegetable) in column B, from the first drop-down list.

In the screen shot below, you can see the completed data entry sheet. This example uses Fruit and Vegetable lists. Here are the step-by-step instructions for making dependent drop-down lists in Excel. The video, and the full transcript is on the Dependent Drop-Down Lists Video page. In this short video, you will see how to set up a main drop-down list, with a dependent drop-down list in the next column. There are spreadsheet setup instructions and a video in the sections below. In cell C4, the dependent drop downs changed automatically, and now it shows the Vegetable list

Next, in cell B4, Vegetable was selected as Produce Type.

Fruit was selected as Produce Type in cell B3, and the drop down showed the Fruit list in cell D3.

In a Microsoft Excel dependent drop down list, the list of items changes, depending on the value

Download the Sample Files What Is a Dependent Drop-Down List?

How to add another page on word