[Office application] How to protect the structure of my Excel sheet without being changed by the filling personnel

My colleagues complained that they had added a password to the Excel sheet that asked the Department staff to fill out. After the result was finally copied by them, they changed the column structure, "A Mess" is filled in. This will cause a lot of trouble for his subsequent handling.

I believe many of my friends may encounter such problems.

The general solution is as follows: Use a password to protect the worksheet and lock different cells to allow modification of some cells and lock some cells.

1. Select cells that can be edited by users. Choose format-cell-protection from the menu.

Remove "Lock. This is a key step.

2. Menu: Tools-Protect-protect worksheets. Password protection for the worksheet

3. In the first option in "allow all users of this worksheet", remove the check mark before "select lock cell.This is a key step.

After such processing, the table cannot be copied or modified.

Try it.

[More tips]

[Office application] How does one split the Excel merge cells and keep data in each cell?

[Office application] how to set the default page margin for IE printing and set the paper to horizontal (Accounting ticket printing)

[Computer Fault] the Excel file cannot be saved, and it is always automatically restarted for recovery.

[Office application] Two separate columns of data quickly become two columns of matched associated data

[Books]

Purchase genuine Excel home books support this site

 

[Office application] How to protect the structure of my Excel sheet without being changed by the filling personnel