Encrypting Office Data Formulas Eliminating Peeping

Nowadays, more and more people use Office to make daily forms, and most of them are work-related things. The data tables that need to be processed are sometimes more important. For those so-called trade secret data, you can't just look at it. At this time, you need to protect these important data. So how to protect it is effective? Specific methods such as the play: 1. Start Yongzhong Office2004 (other versions please follow the operation), open the integrated document that needs to hide and protect the formula. 2. Select the "Edit → Position" menu command to open the "Find and Replace" interface. Cico Tip: You can quickly open the above interface by pressing the “Ctrl+G” key combination. 3. Select the "Positioning" tab and click the "Special Positioning" button to open the "Special Positioning" interface. 4. Click the “Formula” option (the default settings are used in the foreground), click the “OK” button to select all the cells in the table containing the formula at one time. 5. Select the "Tools → Protection → Protect Cells" menu command to open the "Protect Cells" interface. 6. Click the “Hide Formula” option, enter the password in the input box, and click the “OK” button to confirm the password once again. At this point, if we select a cell that contains a formula, we see that the "Edit" column only shows the result returned by the formula, instead of displaying the specific formula (as shown in the figure); if you double-click the mouse to enter the edit state, A prompt interface will pop up, indicating that the cell is in a protected state. Cico Tip: If you want to edit the formula, you can select the "Tools → Protection → Cancel Cell Protection" menu command (if you set a password, you need to enter a password) to remove the protection before you can edit.