On the first sheet, select cell b1.

How to create drop down list in excel without data validation. Now, i can either type the name or i can choose the name. Select all the cells that you want to validate, we select cells b5 to b13. I'll click in the source.

The data validation window will appear. On the second sheet, create the following named ranges. This will open the code window for that.

In the data validation dialog box, do the following: Web y es, you can create a cell drop down without data validation. =indirect (substitute (a2&b2, ,)) where a2 and b2 contain the first and second dropdowns,.

Web for example, in cell c2, the data validation formula would be: Web i'll go to the settings tab, i'll hit the drop down by allow, and i'll choose list. To do this, i’m going to select a cell and under the data tab, click on.

In the source box, either. Web on the data tab, in the data tools group, click data validation.