Shulou(Shulou.com)05/31 Report--

How to encrypt the Excel form? Sometimes you need to add a password to the Exce form when you work, but some novice office software don't know how to encrypt it, so take a look at this tutorial.

The first is file encryption. That is, as soon as you open the EXCEL file, you need to enter a password. Method: click the tools, the options in the menu, and then click the Security tab.

The second kind: worksheet protection. Others can see your table, but cannot modify it (or can only partially modify it, as you specify): click tools, protect, protect worksheet (or protect workbook) in the menu. Then specify what can be done. In addition: the cell is all locked by default. If you want to modify part of it, unlock it before protection: right-click the cell, "format the cell", click the "protect" tab, and unlock the tick in front of the "lock".

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.