Two ways to add a password to a exce table

Sometimes work need to add a password for the Exce form (for example, the office is more than a person with a computer, I want to encrypt some of the tables inside), so as to enhance the security performance, prevent unrelated personnel see the table and the data, the following describes two methods

The first type: file encryption. When you open this Excel file, you need to enter a password. Methods: Click the Tools, Options, and then click the Security tab in the menu.

The second type: Worksheet protection. Others can see your table, but cannot modify (or only partially modify, you specify) method: Click on the tool, protect, protect the worksheet (or protect the workbook) in the menu. Then specify the action that can be made. Another: Cell default is all locked, if you want to partially modify, to unlock before protection: Right click cell, "Format cell", click "Protection" tab, Cancel "lock" in front of the hook