A handy way to make your excel form can only be seen can not be changed

Perhaps you have completed hundreds of financial statements in Excel, maybe you have used Excel functions to achieve thousands of complex operations, maybe you think Excel is just like this Even no new ideas. But our handy use of repeated and numerous repetitions on weekdays is only one percent of all Excel skills. Today will teach you how to make the excel form can only be seen can not be changed, appreciate the different style of Excel.
I have worked hard to design a personal resume form, but it has been messed up by others. Is it very annoying? If it is a private document, just set a password, but this is for others to go inside. Filling in the data or asking for your reference is often caused by someone else's "careless", which leads to redoing the entire form. I don't know if you have encountered it. I have encountered it and worked hard to work overtime. The 7-day-designed form, because there is no protective measure, causing ……哎, sad past, not to mention it!
Now, I teach you a good way to let others in front of your Excel form only Can see, can't move! The method is to set these cells to "Read only"; read
Excel
select the cells that do not need to be protected, right click - set the cell, will protect the label The Lock check box in the box is cleared and then the protection is set on the worksheet.
At this point, the locked cell is read-only, and the cell that has just been cleared of the lock check box can be input normally. If you don't want others to see the contents of some units, if you want to make sure that the Lock check box in these unit protection tabs is checked, then select Hide, so that the contents of these units will not be displayed.
But you must protect your worksheet or workbook before your protection and hiding are effective. To protect the worksheet, you can choose the following: [Tools] → [Protect] & Rarr; [Protect Worksheet] & Rarr; Select the password and repeat the same password, so you need to enter the password in the future.
Today, Xiaobian teaches everyone to let others see in front of your Excel spreadsheet. It’s a good way to move. How do you learn? If you haven’t learned, hurry, don’t let your results be swayed by others.