How to set up automatic data association for excel drop-down menu_Tutorial for setting automatic association data for excel drop-down menu

Use Excel drop-down menus to simplify data entry and increase accuracy. For drop-down menus that need to relate data in different worksheets, manual settings are usually required. This tutorial will show you how to set up drop-down menus in Excel to automatically associate data, helping you save time and improve efficiency. The details below will guide you step-by-step through the setup process, solve your problems, and improve your Excel skills.

Step one: First select the position as shown in the picture and click on the formula.

Step 2: Click [Create based on selected content].

Step 3: Now click on the cell under the city.

Step 4: Change any value to a sequence in Toolbar → Data → Data Validation.

Step 5: Select the city area as the source of data.

Step 6: Now the effect as shown in the picture will appear.

Step 7: Then set the drop-down list of the region.

Step 8: Repeat the above operation of adding a drop-down list.

Step 9: But the source must be set to the formula "=indirect(G10)", G10 represents the first cell corresponding to your city.

The above is the detailed content of How to set up automatic data association for excel drop-down menu_Tutorial for setting automatic association data for excel drop-down menu. For more information, please follow other related articles on the PHP Chinese website!