MODIFICATION OF THE EXCEL DROP DOWN LIST

1Open the file 2. Tool --- macro--- record a new macro--- enter a name, such as: aa 3 Stop recording (so as to get an empty macro) 4. Tool --- macro --- macro, select aa, click the button 5. Delete all characters in the window (one is not left) and replace them with the following content to close the window 7. Tool --- macro --- macro, select allinternalpasswords, run, OK twice, wait 2 minutes, and then OK. OK, no more passwords!

1. First of all, you can click the drop-down option in Excel** to see the drop-down option content at this time, and you need to modify the content.

2. Click on the "Data" option in the toolbar and click on the "Validity" option in it.

3. After entering the validity setting page, you can see that the content of the option entered in the "**" is the option.

4. Directly replace the content that needs to be modified with the original input option content, and click the OK button.

5. Click the drop-down menu of the option again to see that the original option content has been changed to the new content.

1. For example, we complete the following **, enter the text "male, female" in the blank space to set the drop-down box option. Then select the area where you want to set the drop-down box options.

2. Click "Data" in the ribbon - Data Validity.

3. Click in the drop-down box of data validity and select "Sequence" under "Settings--Allow".

4. Then after "**", click the button to select the data ** selection.

5. Drag the mouse to select "Male and Female", and click the data ** button above again to return to the settings dialog box.

6. Click the "OK" button in the settings dialog box. When we click on the input area again, we can see the drop-down box options.

Select the settings area: Under the "Data" option, in "Data Validity" > "Settings", select "Series"; **Enter the drop-down menu content, separated by English commas, or directly select the area where the drop-down menu content is located, and after confirmation, the drop-down menu can be generated.

Lenovo Geekpro 2020

windows 10

excel 2019

1. Open the target excel** on the computer and find the data that needs to set the drop-down options. Here you need to set the drop-down options in the Level column.

2. Then find a blank column, enter the four levels to be filled in (a, b, c d), if necessary, you can hide the four letters.

3. Then select the column of the level that needs to set the drop-down option, select the "Data" option in the menu, and find "Validity" on its page to click.

4. Then in the interface that appears, select "Sequence" in the validity condition column, and select the area of the four levels entered in the second step in the ** column.

5. Click OK to return. After completing the above settings, you can set the drop-down box options in Excel Electronics**.

1. First of all, you can click the drop-down option in Excel** to see the drop-down option content at this time, and you need to modify the content.

2. Click on the "Data" option in the toolbar and click on the "Validity" option in it.

3. After entering the validity setting page, you can see that the content of the option entered in the "**" is the option.

4. Directly replace the content that needs to be modified with the original input option, click OK and press the Royal Fool button.

5. Click the drop-down menu of the option again to see that the original option content has been changed to the new content and the file has been dismantled.

Directly in the data cryptomatha has a polishing effect.

Inside is more blind and wide.