How to lock the formula column in wps2019 table_detailed steps to lock the formula column

php Editor’s new introduction: When using wps2019 tables, locking formula columns is a common requirement to ensure that the formulas remain unchanged when scrolling the table. The following are detailed steps: First, select the formula column that needs to be locked; then, click the "Freeze Panes" button in the "View" tab; finally, select "Freeze First Row" or "Freeze First Column" in the drop-down menu , the formula column can be successfully locked. This way, no matter how you scroll the table, the selected formula column will remain fixed, making it easier to view and analyze the data.

1. Open wps2019 and create a new blank document. Here you can make a simple salary table based on the editor's example. Sales commission = sales amount * 0.03, amount payable = base salary sales commission.

2. Set the function body of the formula column. Click on cell D2, enter [=C2*0.03] after fx and press Enter. Left-click on the lower right corner of cell D2 and pull down to cell D4 to complete copying the formula.

3. In the same way, click on cell E2, enter "=B2 D2" after fx and press Enter. Left-click on the lower right corner of cell E2 and pull down to cell E4. Completed Formula copy.

4. First, left-click the small triangle in the upper left corner of the table to select the entire table, and then click [Lock Cells] above to complete unlocking the entire table.

5. Select all your formula columns, first click [Lock Cells], and then click [Protect Worksheet].

6. At this time, the password input window and the confirmation window for re-entering will pop up. The second input must be consistent and remember it.

7. After completion, when you try to modify the formula column again, a warning window will pop up, prompting you that you must enter a password to cancel the lock. However, you can perform arbitrary operations on non-formula columns, which ensures that the formulas you define will not be modified by others.

The above is the detailed content of How to lock the formula column in wps2019 table_detailed steps to lock the formula column. For more information, please follow other related articles on the PHP Chinese website!