Home > Article > Software Tutorial > How to create a drop-down menu in WPS. Both methods can be easily implemented.
How to create a drop-down menu in WPS. Both methods can be easily implemented.
- PHPzOriginal
- 2024-08-27 10:10:21540browse
Creating drop-down menus in WPS tables simplifies the entry of repeated data. PHP editor Xinyi will provide two simple methods to help you easily implement this function. Method 1: Using the "Data Validation" function, you can effectively limit the cell input value to make it comply with the preset drop-down options. Method 2: With "Conditional Formatting" rules, you can automatically populate drop-down menu options based on specific conditions, simplifying the data entry process.
1. First determine the location of the cell where the drop-down menu needs to be placed, and then select the cell, as shown in the figure below.
2. Then click [Data] - find [Validity] - click the drop-down menu of [Validity] to find [Validity] again, and click [Validity], as shown in the figure below.
3. In the pop-up [Data Validity] window, in the [Settings] tab, select [Sequence] from the [Allow] drop-down menu of the validity condition, and select [Source] after [Sequence]. Select the name column data and click [OK], as shown in the figure below.
Method 2: Make a drop-down menu through a drop-down list
1. Also first determine the cell location where the drop-down menu needs to be placed, and then select the cell, as shown in the figure below.
2. Then click [Data] - click [Drop-down List], as shown in the figure below.
3. In the pop-up Insert Drop-down List dialog box, we can choose two methods: [Add drop-down option manually] and [Select drop-down selection from cell], as shown in the figure below.
4. Let’s add a drop-down menu from [Select drop-down selection from cell] as an example. Click the [Select drop-down selection from cell] option, and then click the table icon on the right , select the name column data on the left, and finally click [OK], as shown in the figure below.
The above is the detailed content of How to create a drop-down menu in WPS. Both methods can be easily implemented.. For more information, please follow other related articles on the PHP Chinese website!