It is important that selecting data entry in certain cells from the drop-down list in the Excel tables in terms of both guiding the user and guaranteeing the same type of data entry for everyone. The following explanation was made in Microsoft Office 2016. It is performed similarly in other versions.
Let’s create an example table for explanation. Let’s give the “Production Type” and “Product” headings to the two columns. Let’s illustrate two different methods here. Let’s add “Dry” and “Watery” production types in the cells under the production type title. Under the title of the product, let the data taken from another page be listed.
By selecting the cells under column B with the title of Production Type, we select Data> Data Validation> Data Validation… from the menu above.
From the pop-up window, we select the “List” option from the drop-down list in the allowed section of the Settings tab. We write “Dry; Watery” in the “Source” section below. You can add the data you want to add to the list. You can write the data you want to add to the list, separated by “;”.
The list has been created as shown below.
Similarly, by selecting the cells under column C with the product title, we select Data> Data Validation> Data Validation… from the menu above. From the pop-up window, we select the “List” option from the drop-down list in the allowed section of the Settings tab.
We come to the “Source” section at the bottom, selecting the cells on page 2 this time and press the “enter” key.
When we close the dialog window by saying OK, we see that our list is created.
With this listing method, we limit the data to be entered in these cells and direct them in the direction we want.
You can download the created excel file by clicking the icon below.