Make Excel tables look nothing but change

Hard to design a personal resume form, but someone else is a mess, is it annoying? If it is a private file is OK, as long as set a password on it, but this is to be someone else to fill in the data or to give you reference, often because of other people's "careless", and caused himself to redo the whole form, this kind of thing do not know that everyone encountered no, I have encountered, hard work overtime spent 7 days before the design of the form, Because I did not do a good job of protective measures, resulting in ... Alas, sad past, do not say it or not!

Now, I teach you a good way to let others in your Excel table can only see, can not move! The method is to make these cells read-only!

Select the cells that you don't want to protect, right-click-set the cell, clear the Locked check box in the Protection tab, and then set protection on the worksheet.

At this point, the locked cells are read-only, and the cells that have just been cleared for the locked check box can be entered normally. If you don't want people to see the contents of some of the cells, choose Hide if the locked check box in the Cell Protection tab is selected, so that the contents of these cells are not displayed.

But you have to protect your worksheet or workbook, and your protection and concealment works. To protect a worksheet, you can select the following: [Tool]→[Protection]→[Protect worksheet]→ Select password, repeat the same password, so that you want to enter the worksheet, just enter the password.