Home  >  Article  >  Software Tutorial  >  How to set up automatic data association for excel drop-down menu_Tutorial for setting automatic association data for excel drop-down menu

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

王林
王林forward
2024-04-24 13:10:12709browse

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.

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

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

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

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

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

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

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

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

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

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

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.

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

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!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact [email protected] delete