Home >Software Tutorial >Office Software >How to set the data corresponding to the excel drop-down menu_How to set the data corresponding to the excel drop-down menu

How to set the data corresponding to the excel drop-down menu_How to set the data corresponding to the excel drop-down menu

WBOY
WBOYforward
2024-04-24 10:34:14714browse

Do you know how to set the data correspondence in the Excel drop-down menu? PHP editor Banana will give you an in-depth understanding of how to set up Excel drop-down menus. This article will detail how to set up drop-down menu items and associated data to help you easily manage large data sets and improve work efficiency. Continue reading below to learn how to set up corresponding data for Excel drop-down menus.

Step one: First open the excel file that needs to be modified.

How to set the data corresponding to the excel drop-down menu_How to set the data corresponding to the excel drop-down menu

Step 2: Click on any cell.

Step 3: Find the [Filter] option in the toolbar [Start].

How to set the data corresponding to the excel drop-down menu_How to set the data corresponding to the excel drop-down menu

Step 4: A drop-down triangle will appear in the lower right corner of the [Name] cell.

How to set the data corresponding to the excel drop-down menu_How to set the data corresponding to the excel drop-down menu

Step 5: Click the drop-down triangle and check the name that needs to be displayed on the page that pops up.

How to set the data corresponding to the excel drop-down menu_How to set the data corresponding to the excel drop-down menu

Step 6: After clicking OK, the form page will only display data related to the name you entered.

How to set the data corresponding to the excel drop-down menu_How to set the data corresponding to the excel drop-down menu

The above is the detailed content of How to set the data corresponding to the excel drop-down menu_How to set the data corresponding to the 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 admin@php.cn delete