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

Maybe you have already done hundreds of financial statements in Excel. Maybe you have used Excel functions to implement thousands of complex operations. Maybe you think Excel is just that, or even new. 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 If someone else fills in the data or wants to give it to everyone, it is often because of the "careless" of others, and they have to redo the entire form. I don’t know if you have encountered it. I have encountered it. Overtime work took a 7-day-designed form, because no protective measures were taken, causing ……哎, sad past, not to mention it!

Now, I teach you a good way to let others Your Excel spreadsheet can only be viewed in front of you, and you can't move it! The method is to set these cells to "Read only"; read-only "!
Excel

Select the cells that do not need to be protected, click Right-click to set the cell, clear the Lock check box in the Protection tab, and then set protection for 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 entered 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 after you have to protect your worksheet or workbook, your protection and hiding will work. 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, don’t let your results be taken by others. Hairy feet.