1. Hide the "0" value in the spreadsheet
Run WPS Form 2009 and open a worksheet. When entering student scores, the scores of students who were absent will be regarded as "0"
But this is not consistent with the actual situation. If we want to hide the "0" value in the table, we only need to click the "Options" command under the "Tools" menu with the mouse, and click the "Options" button in the upper part of the pop-up "Options" dialog box. After the "View" tab, uncheck the "Zero Value" checkbox.
2. Hide formulas in spreadsheets
The spreadsheets created by some users contain more important formulas. In order to protect their intellectual achievements and prevent accidents caused by unauthorized modifications by others, they need to hide the formulas in the spreadsheets. Here's how:
After dragging the mouse to select the cell containing the formula,
Right-click the mouse and click the "Format Cells" command in the pop-up menu. In the pop-up "Format Cells" dialog box, click the "Protect" label at the top and cancel the system's default "Lock" reset. Select the "Hide" checkbox;
