WPS Table Tutorial: The start of ET secret--Application of data validity

Annual Summary of student sports, academic record table There is always such a problem, not the format was changed, is the data bizarre, it seems that in the production of worksheets to start!

One, the agreement format.

such as the date of birth format: Select the column, execute "format" → "number" → "date", select the "2001-3-7" type, OK.

Second, the agreed domain.

For example, the achievement of the standing long jump pupil should be between 0.00 and 3.00.

Select the standing long jump column, perform "data" → "Data Validation", in the set "validation conditions" option, "Allow" Drop-down list select "Decimal", the value Select "between", the minimum input 0.00, the maximum is set to 3.00. Set the input information and error warning as needed.

Set the input information, as long as the cursor is in the standing Jump column, the message will appear.

The warning interface that appears when you enter 3.56 meters in the standing Long jump column:

Third, the contract form.

1. setting allows the user to edit the area.

Execute tools → protection → allow users to edit areas click the New button in the pop-up dialog box to set the area to allow the user to edit in the reference cells box in the New Area dialog box, in this case, the area where the PE teacher needs to enter data. When you are sure, return to allow users to edit the area, and then determine.

2. Protect the worksheet.

Execute the tools → protection → protect sheet, set the password and determine.

Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials

This will cause users to be warned when they try to modify other areas of the table and cannot change them.