In a spreadsheet, sometimes in order to prevent the formulas you set from being seen by other people using the document, you can use the hidden cell function to protect the modified formulas from being viewed by others. The operation methods of wps and office excel spreadsheets may There are some differences, but they are all locked and hidden. Let’s take a look at the specific operation methods.

　 How to hide function formulas in wps spreadsheet

　　How to hide function formulas in excel spreadsheet

1. Select all worksheets in the upper left corner-Ctrl+1, lock in protection (check and cancel)

2. F5-Positioning Conditions-Formula

3. CtrL+1-Protect (Lock and Hide tick)

4. Review-protect worksheet, complete

Summary: The above is all about how to hide function formulas in WPS spreadsheets. I don’t know if you already understand it.