How to modify the content of the drop-down box in excel How to modify the drop-down menu in excel

Some of our users will set up menus in cells when using excel tables. Some friends don’t know how to modify the content inside the box after adding it. There are two ways to modify it, namely through the data source. and data area, then the editor of today’s software tutorial will share the specific operation steps, hoping to help the majority of users. How to modify the excel drop-down menu: 1. Modify in the data source 1. Find the data → data verification and find the source.

2. Directly modify the content in the source. fenye 2. Modify in the data area 1. Select the unnecessary data in the data area.

2. Edit the content directly. 3. The same modification effect will be seen when viewing at this time.

The above is the detailed content of How to modify the content of the drop-down box in excel How to modify the drop-down menu in excel. For more information, please follow other related articles on the PHP Chinese website!