Excel data validity setting method
1. First, we download and install Excel software on this website. Next, we need to open the table for setting data validity, and the interface shown below will appear after opening.
2. Next, we click the "Data" option at the top of the Excel software interface, and then it will appear in the menu bar below this option. We find the "data validation" option and click it, as shown in the figure below.
3. We enter the Excel data verification interface, and in the Settings option of the interface, we set the verification condition to the Order option.
4. We entered optional data items in the box below the source, and it should be noted that they must be separated by English ",".
5. Then we click the "Enter Information" option in the data verification interface, enter the title and information in the interface, and click the OK button at the bottom of the interface to set successfully.
6. Next, we return to the main interface of Excel software and click the drop-down arrow to select.
Excel table encryption method
1. First, we open the form file that needs to be encrypted. After opening, we enter the form interface, and then proceed to the next step.
2. We click the "File" option at the top of the software interface, and then click the "Information" option in the left menu bar, as shown in the figure below. On the right side of the information options are options such as protecting workbook, checking workbook and version, and we click "Protect Workbook".
3. As shown in the figure below, after we click the "Protect Workbook" option, a menu bar will appear below. Let's click the "encrypt with password" option, and then proceed to the next step.
4. The encrypted document selection box pops up. You enter the password in the selection box. What needs to be noted here is that you must remember your own password. If you lose or forget your password, you will not be able to recover it. Passwords are case-sensitive. After entering the password, click OK.
5. Next, the selection box for confirming the password will pop up. We will enter the previously set password, and then click OK to successfully set it.
6. After clicking OK, we have completed the encryption setting of the document. Next, when we open the encrypted file, we will find that we need to enter a password to open it. At this time, just enter the password you set.
The above content comes from happy video games.